MySQL

• 1. Introduction

• 2. Installation on Linux and Windows

• 3. Databases

• 4. Data Types

• 5. Types of MySQL Queries

• 6. Create Table

• 7. More About Create Table

• 8. Alter Table

• 9. Select Query Display Records

• 10. Insert Query Add New Record

• 11. Update Query Edit Records

• 12. Delete Query Remove Records

• 13. Primary Key & Foreign Key

• 14. Alias for Table & Columns

• 15. Concept of JOINS

• 16. Self Join Queries

• 17. Inner Join Queries

• 18. Left Join Queries

• 19. Right Join Queries

• 20. Cross Join Queries

• 21. Union Operator

• 22. Group By Queries

• 23. PHP Limit Data Selections From MySQL

• 24. Exists Queries

• 25. Any, All Operators

• 26. Unique Constraints

• 27. String Library Function

• 28. Numeric Library Function

• 29. Date & Time Library Function

• 30. Aliases

• 31. Views Part 1: Introduction to Views

• 32. Views Part 2: Managing Views

• 33. Views Part 3: Advanced Queries with Views

• 34. Views Part 4: Updating Data Through Views

• 35. Views Part 5: Best Practices and Limitations