SQL SERVER

As SQL beginners, most of us struggle to find out like where to start and where to end. I tried to provide an exhaustive list of topics that we have to learn in order to work as DB developer. I am pretty sure that after learning all the below concepts you will definitely in a position to write any kind of queries in SQL Server

SQL SERVER Training Plan:

Topic	References
Introduction To TSQL
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)
Transaction Control Language (TCL)
Database
Creating Database
Altering Database
Deleting Database
Restore Database
Constrains
Not Null, Unique, Default and Check constraints
Primary Key and Referential Integrity or foreign key constraints
Data Types In TSQL
Table
Creating Table
Altering Table
Deleting Table
Data Manipulation Language
Insert
Identity
Creating A Table From Another Table
Inserting Rows From One Table To Another
Update
Computed Columns
Delete
Truncate
Differences Between Delete and Truncate
Data Query Language (DQL)
Select
Where clause
Order By Clause
Distinct Keyword
Isnull() function
Column aliases
Predicates
Between … And
In
Like
Is Null
Group By and Having Clauses
Built In Functions
Scalar Functions
Numeric Functions
Character Functions
Conversion Functions
Date Functions
Aggregate Functions
Over(partition by …) Clause
Ranking Functions
Common Table Expressions (CTE)
Top n Clause
Set Operators
Union
Intersect
Except
Joins
Inner Join, Self Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join
Sub Queries
Single Row Sub Queries (single row)
Multi Row Sub Queries (IN)
Any or Some
ALL
Nested Sub Queries
Co-Related Sub Queries
Exists and Not Exists
Views
Purpose Of Views
Creating , Altering and Dropping Views
Simple and Complex Views
Encryption and Schema Binding Options in creating views
With Check Option
TSQL Programming
Drawbacks Of TSQL that leads to TSQL Programming
Introduction To TSQL Programming
Control statements In TSQL Programming
Conditional Control Statements
If
Case
Looping Control Statements
While
Stored Procedures
Advantages Of Stored Procedures compared to Independent SQL Statements
Stored Procedures
Creating , Altering and Dropping
Optional Parameters
Input and Output Parameters
Permissions on Stored Procedures
Indexes
Different types of indexes
Scan vs Seeks
bookmark lookup, RID lookup
Functions
User Defined Functions
Creating, Altering and Dropping
Types Of User Defined Functions
Scalar Functions
Table Valued Functions
Inline Table Valued Functions
Multi Statement Table Valued Functions
Permissions On User Defined Functions
cross apply AND outer apply
Triggers
Purpose of Triggers
Differences Between Stored Procedures and User Defined Functions and Triggers
Creating, Altering and Dropping Triggers
Magic Tables
Instead Of Triggers
Exception Handling
Implementing Exception Handling
Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
Raising Exceptions Manual
Transaction Management
Introduction
Begin Transaction
Commit Transaction
Rollback Transaction
Save Transaction
Role Of Log File In Transaction Management
Implicit Transactions

Other Important SQL Server Posts:

1.     SQLSERVER -History of SQL SERVER_BASICs of DDL,DML,DCL,and DTL

2.     SQLServer Data Types

3.    How to create rename delete database in SQLServer 2008,2012,2014,2016 management studio

4.     DisplayQueryand Results in a Separatetab

5.     GetRow Count Of All The Tables In SQL Server Database

6.      SELECTTOP COUNT dynamically

7.      Howto Identify a SQL Server Express Instance