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