SQL SERVER 2019 DEVELOPER (TSQL)
1. DBMS
2. RDBMS
3. What is SQL server
4. Introduction to SQLSERVER 2019
5. Tools of SQLSERVER 2019
6. Management studio
7. System databases
8. Database Creation
9. Authentications
A. Windows
B. SQL Server
10. Data types
11. TSQL Introduction
12. Data Definition language
13. Data Manipulation Language
14. Data Retrieval Language
15. Commit & Rollback
16. Buffer Management
17. Operators
18. Functions
A. Number Functions
B. Character Functions
C. Date time Functions
D. Aggregate Functions
19. Clauses
A. Group By
B. Having
C. Order by
20. Set Operators
21. Joins
A. Inner Join
B. Outer Join
C. Cross Join
22. Sub Queries
23. Copying table concept
24. Constraints
A. Primary key
B. Unique
C. Foreign key
D. Check Constraint
E. Not Null
25. Normalization
26. Views
27. Indexes & B tree Structure & Execution Plan
28. Synonyms
29. Temp Tables
30. CTE
31. Profiler
32. Introduction to Programming
33. Batches and Basic programs
34. If. Else, While
35. Cursors
36. User Defined Functions
37. Stored Procedures
38. Edit & Recompile SP’s
39. Error Handling
40. Triggers
41. Database Creation
42. Backup
43. Introduction to SSIS
44. Introduction to SSRS