MySQL Tutorial

1. MySQL Introduction
2. MySQL Server Installation
3. MySQL SHOW, USE, DESCRIBE
4. MySQL CREATE and DROP
5. MySQL CREATE TABLE
6. MySQL NULL and NOT NULL
7. MySQL Data Types in Tables
8. MySQL INSERT Values Into Table
9. MySQL INSERT Alternatives
10. MySQL Custom Reports
11. MySQL SELECT DISTINCT
12. MySQL WHERE Clause
13. MySQL AND & OR Conditions
14. MySQL NOT Condition
15. MySQL ORDER BY - ASC & DESC
16. MySQL UPDATE Data
17. MySQL DELETE From Table
18. MySQL LIKE - NOT LIKE
19. MySQL WHERE IN - NOT IN
20. MySQL LIMIT - Number of Rows
21. MySQL BETWEEN Range
22. MySQL TRUNCATE TABLE
23. MySQL DROP TABLE, DROP DB
24. MySQL JOINS - Preparations
25. MySQL INNER JOIN Explained
26. MySQL LEFT JOIN Explained
27. MySQL RIGHT JOIN Explained
28. MySQL UNION & UNION ALL
29. MySQL AVG Function
30. MySQL COUNT Function
31. MySQL MAX, MIN Functions
32. MySQL SUM Function
33. MySQL UCASE, LCASE Functions
34. MySQL MID Function
35. MySQL LENGTH Function
36. MySQL VIEWs ?
37. MySQL HAVING Clause
38. MySQL ALTER TABLE
39. MySQL DEFAULT Values
40. MySQL BACKUP, RESTORE Database