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