SQL
1. select all columns from a selected set of rows
2. Selected Rows &Selected columns
3. SQL Constraints
4. Primary Key in SQL
5. Foreign Key in SQL
6. GROUP BY Clause in SQL
7. 6 main clauses in SQL.
8. Joins in SQL
9. Subquery in SQL
10. DELETE in SQL
11. Introduction to JSON in SQL
12. JSON_EXTRACT() in SQL
13. JSON_OBJECT() in SQL
14. JSON_ARRAY() in SQL
15. JSON_SET() in SQL
16. Set Operations in SQL
17. Introduction to SQL Functions
18. Aggregate Functions in SQL
19. String Functions in SQL
20. Date & Time Functions in SQL
21. Window Functions (Analytical Queries) in SQL
22. Common Table Expressions (CTEs) in SQL
23. Query Optimization and Execution Plans in SQL
24. Indexing Strategies and Performance Tuning in SQL
25. Database Concurrency Control and Locking in SQL
26. Backup, Recovery, and High Availability in SQL
27. Advanced Security and Access Control in SQL
28. Triggers and Event Driven Automation in SQL
29. Cloud Databases and SQL in Cloud Platforms
30. SQL for Data Warehousing and Analytics
31. SQL Query Optimization Techniques (Execution Plan Analysis)
32. SQL Index Internals (B Tree, Hash, and Bitmap Indexing)
33. SQL Partitioning Strategies (Horizontal & Vertical Partitioning)
34. SQL Materialized Views vs Regular Views
35. SQL Window Frame Clauses (ROWS vs RANGE)
36. SQL Recursive Queries (Common Table Expressions – Recursive CTEs)
37. SQL Locking Mechanisms and Isolation Levels (Concurrency Control)
38. SQL Query Parallelism and Performance Tuning
39. SQL Data Masking and Anonymization Techniques
40. SQL Multi Tenant Database Design
41. SQL Query Execution Plans and Execution Tree Analysis
42. Materialized Views and Their Performance Benefits
43. SQL Partitioning Strategies for Large Tables
44. Temporal Tables and Time Travel Queries in SQL
45. SQL Change Data Capture (CDC) Techniques
46. Row Level Security (RLS) in SQL Databases
47. SQL Query Optimization Using Statistics and Histograms
48. Database Sharding Concepts and SQL Considerations
49. SQL Data Masking and Sensitive Data Protection
50. SQL Multi Version Concurrency Control (MVCC) and Transaction Isolation Internals
51. Stored Procedures in SQL
52. SQL Transactions: COMMIT, ROLLBACK, and SAVEPOINT
53. Cursors in SQL
54. Sequences in SQL
55. CASE Expressions in SQL
56. COALESCE and NULL Handling Techniques in SQL
57. MERGE Statement in SQL
58. SQL Cursors vs Set Based Processing
59. SQL User Defined Functions (UDFs)
60. Introduction to SQL
61. Data Types
62. Operators
63. Create Database
64. Drop Database
65. Rename Database
66. Select Database
67. What is Tables?
68. Create Table
69. Drop Table
70. Rename Table
71. Truncate Table
72. Copy Table
73. Temporary Tables
74. Alter Table
75. Select Statement
76. Select Unique
77. Select Count
78. Select Top
79. Select First
80. Select Last
81. Select Random
82. Views
83. Select In
84. Select Where Clause
85. Select AND
86. Select Or
87. Select With
88. Select As
89. Select Group By
90. Select Having
91. Select Order By
92. Select Order By Random
93. Select Order By Limit
94. Insert Query
95. Update Query
96. Delete Query Remove Records
97. Delete Duplicate Records
98. Joins
99. Join Outer
100. Joins Left
101. Join Right
102. Join Full
103. Join Cross
104. Primary Key
105. Foreign Key
106. Composite Key
107. Aliases
