Mastering SQL: A Complete Course Syllabus for Beginners

1. Introduction to SQL 

How to Download and Install MySQL in Windows 11 

2. How to Download MYSQL 

3. How to Install and Configure MYSQL 

4. How to Start MYSQL 

5. Create Database in SQL 

6. Use Database in SQL 

7. Create Table in SQL 

8. Describe Table in SQL 

9. Show Database and Table in SQL 

10. INT and DEC Data Type in SQL 

11. CHAR, VARCHAR and TEXT Data Type in SQL 

12. DATE, DATATIME and TIMESTAMP Data Type in SQL 

13. Example of All Data Type in SQL 

14. Help and Support by MYSQL 

15. INSERT INTO in SQL 

16. INSERT INTO without specifying Column Name in SQL 

17. INSERT INTO with Changing order of column in SQL 

18. INSERT INTO Specified Column in SQL 

19. INSERT INTO Multiple rows in SQL 

20. SELECT All or Particular Column records in SQL 

21. Single Quotes Problem in SQL 

22. SELECT with LIMIT in SQL 

23. WHERE Clause and equal operator in SQL 

24. WHERE Clause and Not equal operator in SQL 

25. WHERE Clause and Greater than less than in SQL 

26. IS NULL and IS NOT NULL in SQL 

27. AND operator in SQL 

28. OR operator in SQL 

29. Combination of AND & OR in SQL 

30. IN Operator in SQL 

31. NOT IN operator in SQL 

32. BETWEEN Number in SQL 

33. BETWEEN Text in SQL 

34. BETWEEN Date in SQL 

35. NOT BETWEEN Number in SQL 

36. NOT BETWEEN Text in SQL 

37. NOT BETWEEN Date in SQL 

38. BETWEEN with IN SQL 

39. BETWEEN with NOT IN SQL 

40. LIKE with % WildCard in SQL 

41. LIKE with _ Wildcard in SQL 

42. LIKE with [charlist] Wildcard in SQL 

43. NOT LIKE in SQL 

44. ORDER BY decending order in SQL 

45. ORDER BY Asecending order in SQL 

46. NOT NULL in SQL 

47. UNIQUE KEY in SQL 

48. PRIMARY KEY in SQL 

50. AUTO INCREMENT in SQL 

51. Starting AUTO INCREMENT with a particular Number in SQL 

52. AUTO INCREMENT without specifying column name in SQL 

53. Alias in SQL 

54. Arithmetic Operators in SQL 

55. SELECT DISTINCT in SQL 

56. ALTER TABLE for adding one column without constraints in SQL 

57. ALTER TABLE for adding multiple columns without constraints in SQL 

58. ALTER TABLE for Adding Column by Position without constraints in SQL 

59. ALTER TABLE for Adding Column with constraints in SQL 

60. ALTER TABLE for Adding Column by Position with constraints in SQL 

61. ALTER TABLE for Adding Constraint in Column SQL 

62. Change Column Name and Its Data Type WIthout Constraints in SQL 

63. Change more than one column Name and its data type without constraints in SQL 

64. CHANGE COLUMN name and its Data Type with constraint in SQL 

65. MODIFY COLUMN Data Type and Its Size with or Without Constraint in SQL 

66. DROP COLUMN with or without constraint in SQL 

67. DROP TABLE or Delete Table from database in SQL 

68. Delete Data of Table using TRUNCATE TABLE in SQL 

69. Rename Table Name using RENAME TABLE in SQL 

70. Alter Database using ALTER DATABASE in SQL 

71. Delete Database using DROP DATABASE in SQL 

72. SHOW COLUMNS in SQL 

73. SHOW CREATE DATABASE in SQL 

74. SHOW CREATE TABLE in SQL 

75. Update Records in Table Part 1 in SQL 

76. Update Records in Table Part 2 in SQL 

77. UPDATE with CASE in SQL 

78. DELETE recods in Table in SQL 

79. Copy Old Table to New Table within same Database in SQL 

80. Copy Old Table to New Table different Database in SQL 

81. MIN and MAX Function in SQL 

82. SUM and AVG Function in SQL 

83. SQRT Function in SQL 

84. DECIMAL Data Type in SQL 

85. ROUND Function in SQL 

86. COUNT Function in SQL 

87. UPPER and LOWER Function in SQL 

88. MID and LENGTH Function in SQL 

89. CONCAT Function in SQL 

90. REVERSE Function in SQL 

91. NOW Function in SQL 

92. GROUP BY in SQL 

93. HAVING Clause in SQL 

94. Why do we need Multi Table in SQL 

95. Relationship between Tables in SQL 

96. One to One Relationship in SQL 

97. One to Many Relationship in SQL 

98. Many to Many Relationship in SQL 

99. What is Normalization in SQL 

100. First Normal Form 1 NF in SQL 

101. Second Normal Form 2 NF in SQL 

102. Third Normal Form 3 NF in SQL 

103. Short Note about Normalization in SQL 

104. What is Foreign Key in SQL 

105. Create Table with Foreign Key in SQL Theory 

106. Create Table with Foreign Key in SQL Practical 

107. How to find Constraint Name in SQL 

108. Drop Foreign Key from Table in SQL 

109. Add Foreign Key Constraint in a Table SQL 

110. Unable to Delete Parent Table in SQL 

111. Unable to Delete Parent Table records in SQL 

112. ON DELETE Clause in SQL 

113. ON DELETE CASCADE in SQL 

114. ON DELETE SET NULL in SQL 

115. ON DELETE NO ACTION or ON UPDATE RESTRICT in SQL 

116. ON UPDATE Clause in SQL 

117. ON UPDATE CASCADE in SQL 

118. ON UPDATE SET NULL in SQL 

119. ON UPDATE NO ACTION or ON UPDATE RESTRICT in SQL 

120. Composite Key in SQL 

121. Shorthand Notation in SQL 

122. How to Join Tables in SQL 

123. CROSS JOIN in SQL 

124. INNER EQUIJOIN in SQL 

125. INNER NON-EQUIJOIN in SQL 

126. NATURAL JOIN in SQL 

127. Outer Join in SQL 

128. LEFT OUTER JOIN in SQL 

129. RIGHT OUTER JOIN in SQL 

130. FULL OUTER JOIN in SQL 

131. What is Self Join in SQL 

132. Why do we need Self Join in SQL 

133. Self Join Example in SQL 

134. Replacing NULL in SQL 

135. UNION in SQL 

136. UNION ALL in SQL 

137. INTERSECT and EXCEPT in SQL 

138. Solve error can't connect to mysql server on localhost