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