Видео курса

  • Урок 1. 00:03:07
    Overview
  • Урок 2. 00:06:11
    Introduction
  • Урок 3. 00:08:04
    MySQL Server Installation
  • Урок 4. 00:02:52
    How To Maintain Memory
  • Урок 5. 00:02:43
    Sample Database
  • Урок 6. 00:04:24
    Select Statement to query data
  • Урок 7. 00:04:27
    Distinct to eliminate duplicate records
  • Урок 8. 00:02:30
    Filter data records with where clause
  • Урок 9. 00:03:09
    2. Logic And and OR
  • Урок 10. 00:03:01
    Greater Than, Less Than and Between operator
  • Урок 11. 00:02:17
    IN and NOT operator
  • Урок 12. 00:05:29
    LIKE operator to select records based on patterns
  • Урок 13. 00:01:53
    LIMIT operator to limit the number of records displayed
  • Урок 14. 00:04:10
    ORDER BY clause to sort data
  • Урок 15. 00:03:15
    Using Alias to make queries more readable
  • Урок 16. 00:09:11
    MySQL INNER JOIN to join two or multiple tables
  • Урок 17. 00:07:35
    MySQL LEFT JOIN to include left set when joining tables
  • Урок 18. 00:04:40
    MySQL self joining tables
  • Урок 19. 00:09:11
    GROUP BY to put same value records into groups
  • Урок 20. 00:05:07
    HAVING clause to filter data after grouping
  • Урок 21. 00:04:37
    Subquery in MySQL
  • Урок 22. 00:03:51
    Combining result sets by UNION
  • Урок 23. 00:03:37
    Create Table
  • Урок 24. 00:08:18
    Insert records into tables
  • Урок 25. 00:07:15
    Storage Engines
  • Урок 26. 00:03:21
    Update record values
  • Урок 27. 00:04:49
    Delete records
  • Урок 28. 00:03:51
    Manage database
  • Урок 29. 00:01:34
    Drop statement
  • Урок 30. 00:03:53
    Sample Database for problems
  • Урок 31. 00:11:22
    Problems 1 - 6
  • Урок 32. 00:12:08
    Problems 7 - 12
  • Урок 33. 00:18:06
    Problems 13 - 19
  • Урок 34. 00:12:08
    Problems 20 - 23
  • Урок 35. 00:14:40
    Problems 24 - 27
  • Урок 36. 00:14:23
    Problems 28 - 29
  • Урок 37. 00:03:12
    Problems 30
  • Урок 38. 00:10:36
    Problems 31 - 32
  • Урок 39. 00:08:05
    Problems 33 - 34
  • Урок 40. 00:11:50
    Problems 36 - 38
  • Урок 41. 00:09:43
    Problems 39 - 42

Материалы курса

К этому курсу прилагаются дополнительные материалы. Здесь вы можете скачать их.

Материалы к курсу