arrow_back
MySQL Study Material
MySQL Study Material Download and unzip
MY SQL-Set-2 Study Material
MySQL Video Sessions
1. Introduction to Database & SQL, User Interface of MySQL
2. Creation of Database & Tables, Datatypes
3. Sub Languages - 1 - DDL
4. Installation of MySQL & Sub Languages -2 - DML,DCL
5. Sub Languages -3 - TCL, DQL (1)
5. Sub Languages -3 - TCL, DQL
6. Integrity Constraints -1
7. Integrity Constraints -2
8. Foreign Key
9. Limitations of Excel & Intro to Real time Database
10. Operators & Clauses -1; Where Clause
11. Operators & Clauses - 2; Order by, Limit, Distinct clauses
12. Like Operator & Functions -1; Numeric Functions
13. Functions -2 ; Character ,Date Functions
14. Regular Expressions
15. Joins - 1
16. Joins -2 - Examples on Joins
17. Joins-3 Examples on Joins
18. Joins - 4
19. GROUP by Clause & Having Clause
20. Examples on Group by & Having Clauses & Sub Queries -1
21. Sub Queries -2
22. Views
23. Indexes
24. ER Diagram
25. ER Diagram - 2 & Temporary Tables
26. CTE & Joins Assignment Solutions - 1
27. Joins Assignment Solutions -2 & Stored Procedures
28. Window Functions
29. Denormalization & Normalization, Normal Forms -1
30. Normal Forms -2, INTERVIEW QUESTIONS