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