1. Introduction to SQL
2. How to Download and Install MySQL in Windows 11
3. How to Download MYSQL
4. How to Install and Configure MYSQL
5. How to Start MYSQL
6. Create Database in SQL
7. Use Database in SQL
8. Create Table in SQL
9. Describe Table in SQL
10. Show Database and Table in SQL
11. INT and DEC Data Type in SQL
12. CHAR, VARCHAR and TEXT Data Type in SQL
13. DATE, DATATIME and TIMESTAMP Data Type in SQL
14. Example of All Data Type in SQL
15. Help and Support by MYSQL
16. INSERT INTO in SQL
17. INSERT INTO without specifying Column Name in SQL
18. INSERT INTO with Changing order of column in SQL
19. INSERT INTO Specified Column in SQL
20. INSERT INTO Multiple rows in SQL
21. SELECT All or Particular Column records in SQL
22. Single Quotes Problem in SQL
23. SELECT with LIMIT in SQL
24. WHERE Clause and equal operator in SQL
25. WHERE Clause and Not equal operator in SQL
26. WHERE Clause and Greater than less than in SQL
27. IS NULL and IS NOT NULL in SQL
28. AND operator in SQL
29. OR operator in SQL
30. Combination of AND & OR in SQL
31. IN Operator in SQL
32. NOT IN operator in SQL
33. BETWEEN Number in SQL
34. BETWEEN Text in SQL
35. BETWEEN Date in SQL
36. NOT BETWEEN Number in SQL
37. NOT BETWEEN Text in SQL
38. NOT BETWEEN Date in SQL
39. BETWEEN with IN SQL
40. BETWEEN with NOT IN SQL
41. LIKE with % WildCard in SQL
42. LIKE with \_ Wildcard in SQL
43. LIKE with \[charlist] Wildcard in SQL
44. NOT LIKE in SQL
45. ORDER BY decending order in SQL
46. ORDER BY Asecending order in SQL
47. NOT NULL in SQL
48. UNIQUE KEY in SQL
49. 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 localho