MySQL
1. Aggregate Function
2. count(),avg(),sum() functions
3. Program to create client table
4. Program to create employee table
5. Introduction
6. Installation on Linux and Windows
7. Databases
8. Data Types
9. Types of MySQL Queries
10. Create Table
11. More About Create Table
12. Alter Table
13. Select Query Display Records
14. Insert Query Add New Record
15. Update Query Edit Records
16. Delete Query Remove Records
17. Primary Key & Foreign Key
18. Alias for Table & Columns
19. Concept of JOINS
20. Self Join Queries
21. Inner Join Queries
22. Left Join Queries
23. Right Join Queries
24. Cross Join Queries
25. Union Operator
26. Group By Queries
27. PHP Limit Data Selections From MySQL
28. Exists Queries
29. Any, All Operators
30. Unique Constraints
31. String Library Function
32. Numeric Library Function
33. Date & Time Library Function
34. Aliases
35. Views Part 1: Introduction to Views
36. Views Part 2: Managing Views
37. Views Part 3: Advanced Queries with Views
38. Views Part 4: Updating Data Through Views
39. Views Part 5: Best Practices and Limitations
