SQL DBA

Course Info

  • Category: IT Program
  • TRAINER: MR.ASHUTOSH
  • Duration: 2 Months.
  • Share Course:

SQL DBA Course

1. Introduction to SQL
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 Numbers in SQL
33. BETWEEN Texts in SQL
34. BETWEEN Dates 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 [chartist] Wildcard in SQL
43. NOT LIKE in SQL
44. ORDER BY descending order in SQL
45. ORDER BY Ascending 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 records 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