MySQL
1. foreign key constraints
2. Triggers in MySQL
3. Partitioning tables in MySQL.
4. real world case studies in MySQL
5. Stored Procedures and Functions in MySQL
6. updatable vs. non updatable view
7. updatable vs. non updatable view
8. What is a View
9. UNION, INTERSECTION, and DIFFERENCE
10. EXPLAIN command in MySQL
11. Naming Rules
12. installing and setting up MySQL on Windows, macOS, and Linux
13. RDBMS vs. MySQL
14. What is a Database
15. Aggregate Function
16. count(),avg(),sum() functions
17. Program to create client table
18. Program to create employee table
19. Query Optimization in MySQL
20. MySQL Backup and Recovery Strategies (Logical & Physical Backups)
21. MySQL JSON Data Handling
22. MySQL Event Scheduler (Automating Tasks)
23. MySQL Performance Tuning and Optimization Techniques
24. MySQL Replication (Master–Slave & Group Replication)
25. MySQL Transaction Isolation Levels – Detailed Explanation
26. MySQL Storage Engines (InnoDB vs MyISAM vs MEMORY)
27. Index Types in MySQL (B Tree, Hash, Full Text, Spatial)
28. MySQL Query Execution Plan (EXPLAIN & ANALYZE)
29. user defined functions (UDFs)
30. transaction control statements
31. GRANT
32. Backup and Recovery in MySQL
33. Point in Time Recovery (PITR) in MySQL
34. Introduction
35. Installation on Linux and Windows
36. Databases
37. Data Types
38. Types of MySQL Queries
39. Create Table
40. More About Create Table
41. Alter Table
42. Select Query Display Records
43. Insert Query Add New Record
44. Update Query Edit Records
45. Delete Query Remove Records
46. Primary Key & Foreign Key
47. Alias for Table & Columns
48. Concept of JOINS
49. Self Join Queries
50. Inner Join Queries
51. Left Join Queries
52. Right Join Queries
53. Cross Join Queries
54. Union Operator
55. Group By Queries
56. PHP Limit Data Selections From MySQL
57. Exists Queries
58. Any, All Operators
59. Unique Constraints
60. String Library Function
61. Numeric Library Function
62. Date & Time Library Function
63. Aliases
64. Views Part 1: Introduction to Views
65. Views Part 2: Managing Views
66. Views Part 3: Advanced Queries with Views
67. Views Part 4: Updating Data Through Views
68. Views Part 5: Best Practices and Limitations