1) Introduction to SQL Server
- What is Data
- What is Database
- What is DBMS
- What is RDBMS
- What is SQL Server
- Installing SQL server Management Studio
- SQL Server Authentication mode
- SQL Server Windows Authentication mode
2) SQL Commands
i) Data Definition Language Commands (DDL)
- CREATE
- ALTER
- DROP
- TRUNCATE
ii) Data Manipulate Language Commands (DML)
- INSERT
- DELETE
- UPDATE
- LOCK
iii) Data Query Language Commands (DQL)
- SELECT
iv) Data Control Language Commands (DCL)
- GRANT
- INVOKE
v) Transaction Control Language Commands (TCL)
- COMMIT
- TRANSACTION
- ROLLBACK
3) Database
- SYSTEM DATABASES
- USER DEFINED DATABASES
- CREATE DATABASE
4) Tables
- SYSTEM DEFINED TABLE
- USER DEFINDED TABLE
- DEFINE SCHEMA
5) SQL Datatypes
- INT
- BIGINT
- SMALL INT
- CHAR
- VARCHAR
- NVARCHAR
- DATETIME
- DATE
- TIME
- XML
- DECIMAL
- NUMERIC
6) SQL Keys
- Primary Key
- Foreign Key
- Unique Key
- Super Key
- Natural Key
- Alternative Key
- Candidate Key
- Composite key
- Surrogate Key
7) SQL Constraints
- Null
- Not Null
- Default
- Primary Key
- Unique Key
- Foreign key
8) SQL Joins
- LEFT JOIN / LEFT OUTER JOIN
- RIGHT JOIN / RIGHT OUTER JOIN
- FULL JOIN / FULL OUTER JOIN
- SELF JOIN
- INNER JOIN / JOIN
- CROSS JOIN
9) SQL Clause
- DISTINCT
- TOP
- WHERE
- ORDER BY
- IN
- NOT IN
- IS NULL
- IS NOT NULL
- EXISTS
- GROUP BY
- HAVING
10) SQL Operator
- AND
- OR
- <
- >
- <=
- >=
- <>
- !=
- LIKE
- WILDCARD
- BETWEEN
- UNION
- UNION ALL
- EXCEPT
- INTERSECT
11) SQL Window Functions
- ROW_NUMBER ()
- RANK ()
- DENSE_RANK ()
- NTILE ()
- LAG ()
- LEAD ()
- FIRST_VALUE ()
- LAST_VALUE ()
12) SQL Datatime Functions
- DATEADD ()
- DATEDIFF ()
- DATEPART ()
- DATENAME ()
- GETDATE ()
- EOMONTH ()
- DAY
- MONTH
- YEAR
13) SQL String Functions
- LTRIM
- RTRIM
- RIGHT
- LEFT
- SUBSTRING
- CHARINDEX
- PATINDEX
- UPPER
- LOWER
- REPALCE
- STUFF
- REVERSE
- LEN
- REPLICATE
- CONCATE
14) SQL Aggergate Functions
- SUM
- COUNT
- MAX
- MIN
- AVG
15) SQL Conditional Statements
- IIF
- CASE
- WHILE
- IF
- BREAK
- CONTINUE
16) SQL Adavanced Functions
- ISNULL
- COALESCE
- ROLLUP
- CUBE
- PIVOT
- UNPIVOT
- SUB QUERIES
- CO RELATED SUB QUERIES
- DERIVED TABLES
- TABLE VARIABLES
- VARIABLES
- COMMON TABLE EXPRESIONS
- TEMP TABLES
17) Views in SQL
- SIMPLE VIEW
- COMPLEX VIEW
- ENCRYPTION AND SCHEMA BINDING
18) Stored Procedure in SQL
- STORED PROCEDURE WITHOUT PARAMETER
- STORED PROCEDURE INPUT PARAMETER
- STORED PROCEDURE OUTPUT PARAMETER
- STORED PROCEDURE RETURN VALUE
- DROP STORED PROCEDURE
- TRANSACTION, COMMIT, ROLLBACK
- TRY CATCH EXCEPTION HANDLING
- ENCRPT STORED PROCEDURE
19) Functions in SQL
- MULTI TABLE VALUED FUNCTION
- INLINE FUNCTION
- SCLAR FUNCTION
20) Merge in SQL
- MERGE
21) Dynamic in SQL
- DYNAMIC SQL
22) Indexes in SQL
- CREATE INDEX
- CLUSTER INDEX
- NON-CLUSTER INDEX
- FILTER INDEX
- COVERED INDEX
- COLUMN STORED INDEX
- DROP INDEX
- REBUILD INDEX
23) Triggers in SQL
- DDL TRIGGERS
- DML TRIGGERS
24) Cursors in SQL
- LIFE CYCLE OF CURSOR
- DECLARE CURSOR STATEMENT
- OPEN CURSOR STATEMENT
- FETCH CURSOR STATEMENT
- CLOSE CURSOR STATEMENT