1. Prerequisites:

2. Overview -- Relational Database Management -- SQL (Structured 
Query Language) -- History -- Installation, Architecture, Edition -- 
Connecting to SQL Server -- SSMS  

3. SQL Statement Types -- DDL --DML

4. DATABASE -- Login, Create, Drop, Truncate, Rename, Backup, 
Restore -- Working with Databases  

5. TABLES and Operations on Table -- CRUD, Datatypes/Data 
Conversion -- Working with Tables  

6. Keys and Constraints -- Types (Primary, Foreign, Unique, 
Default, Check, Referential Integrity…) -- Usage -- Identity Columns -- Basic DBCC Commands  

7. Indexes and Triggers -- Introduction, Type, Advantages, 
disadvantages of Indexes -- Introduction and types of Triggers 
(DDL/DML….) -- Working with Triggers and Indexes  

8. Data Types and Operators -- Overview -- Working Data Types 
(Exact Numeric, Approximate Numeric, Date &Time, Character 
Strings, Unicode Character Strings, Binary, Misc.) -- Working with 
Operators (Arithmetic, Comparison, Logical) -- Working with NULL, 
COALESCE -- Data Type Conversion (Detailed), 
Type Casting (convert & cast)

9. Basic SQL Queries -- Select Statement, Where Clause -- 
Operations on Rows and Column

10.SQL Sub Query & SQL CASE Statement

11. JOIN -- Concept of Set Theory -- Types and Usage, Operations -- Self Join  

12. Stored Procedures -- Overview, Usage, Advantages and 
Disadvantages --Working on SPs With Output, Without Output  

13. Functions -- Difference between Function and Stored Procedure -- Scalar User Defined -- Inline Table Values Functions -- 
Mathematical Functions -- Multi-Statement Table Values Function  

14. Aggregate Functions -- Overview, Types and Usage -- Working 
with Aggregate functions (MIN, MAX, SUM, AVG, COUNT) -- OVER 
Clause -- EXCEPT Operator  

15. Temporary Tables -- Overview, Types and Scope -- Working with 
Temp Tables  

16. UNION VS UNION ALL -- WHERE and HAVING -- UNION 
INTERSECT and EXCEPT  

17. SQL STRING FUNCTIONS: LEFT, RIGHT, CHARINDEX, 
PATINDEX, SUBSTRING, REPLICATE, REPLACE, RANK, 
ROW_NUMBER, DENSE_RANK, ORDER BY, OVER ()  

18. Views -- Overview, Advantages and disadvantages/limitations -- 
Updatable Views,Indexed Views  

19. Pivot and Unpivot  

20. Error Handling  

21. Transactions in Sql Server