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