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