This course is designed for people who aspires to become a Data Analyst/Data Scientist/Data Engineer/Software Developer or anyone who wish to learn SQL.All the concepts will be taught in an easier way with examples and practice questions wherever necessary.By the end of this course learners will be able to manipulate data and write complex queries in a best possible way.We will be using MICROSOFT SSMS for this tutorial.This course is divided into three parts as below.

BASIC

1. SQL Overview and Basics
2. Types of SQL Statements
3. Working with Databases and Tables
4. Alter, Drop and Truncate statements
5. Various constraints
6. Select and where
7. Update,Insert and Delete Statements
8. Case statement,Like, in,not in, intersect and except operator
9. Identity column
10. Handling NULLS
11. Distinct, Orderby
12. Group By and Having
13. Where vs Having
14. Union and union all
15. union vs join
16. Joins and Comparison
17. Schemas

INTERMEDIATE

1. Coalesce function
2. String functions
3. Date Functions
4. Casting and mathematical functions
5. User Defined functions
6. Sequence
7. Indexes
8. Views
9. Materialized Views and comparison
10. Stored procedures
11. Debugging procedures
12. Exception Handling
13. Stored Procedures vs Functions
14. Temporary Tables
15. Triggers
16. Audit tables and other triggers
17. Subqueries
18. Subquery vs join
19. CTE
20. CTE vs Temporary Tables
21. Partition and OVER 
22. Row number, Rank and Dense Rank
23. Transactions
24. Normalisation

ADVANCED

1. Cursors
2. Why should we avoid cursors
3. Merge 
4. Concurrent Transactions
5. Deadlocks
6. Table valued and other functions
7. Optional parameters in SQL
8. Grouping function
9. Pivot and Unpivot
10. Miscellaneous Functions
11. Offset fetch and GUID
12. Dynamic SQL
13. Caching Sql query
14. Exec vs execute sql
15. ACID properties
16. Miscellaneous topics

ADD ONS

1. Performance tuning
2. Interview questions