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