1. Introduction to SQL
2. Types of SQL Commands
3. Create and Alter Theory and Hands-On
4. Rename Theory and Hands-On
5. Drop and Truncate Theory and Hands-On
6. Comment Theory and Hands-On
7. DML Commands Theory
8. DML Commands Hands-On
9. Ways of Inserting Data into Tables Theory
10. Ways of Inserting Data into Tables Hands-On
11. DCL Commands Theory
12. DCL Commands Hands-On
13. TCL Commands Theory
14. TCL Commands Hands-On
15. DQL Commands Theory
16. DQL Commands Hands-On
17. SQL Statements
18. Alias Theory and Hands-On
19. Distinct Theory and Hands-On
20. What are Operators
21. Arithmetic Operators Theory
22. Arithmetic Operators Hands-On
23. Comparison Operators
24. Logical Operators - And & Between
25. Logical Operators - In & Not In
26. Logical Operators - Like & OR
27. Logical Operators - Exists & Not Exists
28. Aggregate Functions Theory
29. Aggregate Functions Hands-On
30. SQL Clauses
31. Where Clause Theory
32. Where Clause Hands-On
33. Order By Clause Introduction
34. Order By Clause - Ascending Order Theory and Hands-On
35. Order By Clause - Descending Order Theory and Hands-On
36. Order By Clause - Ascending & Descending Order Theory and Hands-On
37. Order By Clause - Ascending with Null Values Theory and Hands-On
38. Order By Clause - Descending with Null Values Theory and Hands-On
39. Group By Clause Theory
40. Group By Clause Hands-On Part-1
41. Group By Clause Hands-On Part-2
42. Having Clause Theory
43. Having Clause Hands-On
44. What is Null Value
45. Inserting Null Values Theory
46. Inserting Null Values Hands-On
47. Null vs Empty Space-Theory
48. Null vs Empty Space -Hands On
49. How to find Null Values Theory
50. How to find Null Values Hands-On
51. Null Values in Arithmetic Expressions- Theory
52. Null Values in Arithmetic Expressions Hands-On
53. Subquery Theory
54. Subquery Hands-On
55. Subquery Types Theory Part 1
56. Subquery Types Theory Part 2
57. Subquery Types Hands-On Part 1
58. Subquery Types Hands-On Part-2
59. What are Joins
60. How Joins work
61. Inner Joins Theory
62. Inner Joins Hands-On
63. Outer Joins Theory
64. Outer Joins Hands-On
65. Self Joins Theory
66. Self Joins Hands-On
67. Cross Joins Theory
68. Cross Joins Hands-On
69. Set Operator Introduction
70. Union Set Operator Theory
71. Union Set Operator Hands-On
72. Union All Set Operator Theory
73. Union All Set Operator Hands-On
74. Intersect Set Operator Theory and Hands-On
75. Minus Set Operator Theory
76. Minus Set Operator Hands-On
77. Introduction to String Functions
78. Strings Case Manipulation Theory And Hands-On
79. Adding and Removing Spaces Theory Part-1
80. Adding and Removing Spaces Theory Part-2
81. Adding and Removing Spaces Theory Part-3
82. Adding and Removing Spaces Hands-On Part-1 ,Part-2 & Part-3
83. Substring Theory Part-1
84. Substring Theory Part-2
85. Substring Hands-On
86. Substring Index Theory
87. Substring Index Hands-On