1. Урок 1.00:04:15
    What does the course cover?
  2. Урок 2.00:03:18
    Why SQL?
  3. Урок 3.00:01:58
    Why MySQL?
  4. Урок 4.00:04:45
    Introduction to databases
  5. Урок 5.00:02:12
    SQL as a declarative language
  6. Урок 6.00:04:14
    Data definition language (DDL)
  7. Урок 7.00:01:13
    SQL keywords
  8. Урок 8.00:04:56
    Data manipulation language (DML)
  9. Урок 9.00:05:04
    Data control language (DCL)
  10. Урок 10.00:03:03
    Transaction control language (TCL)
  11. Урок 11.00:04:52
    Relational database essentials
  12. Урок 12.00:08:07
    Databases vs spreadsheets
  13. Урок 13.00:04:18
    Database terminology
  14. Урок 14.00:04:56
    Relational schemas - Primary key
  15. Урок 15.00:05:00
    Relational schemas - Foreign key
  16. Урок 16.00:03:08
    Relational schemas - Unique key and null values
  17. Урок 17.00:04:40
    Relationships
  18. Урок 18.00:10:49
    Installing MySQL
  19. Урок 19.00:02:35
    Setting up a connection
  20. Урок 20.00:06:19
    New Authentication Plugin - Creating a New User
  21. Урок 21.00:05:10
    Introduction to the MySQL interface
  22. Урок 22.00:05:13
    Creating a Database - Part I
  23. Урок 23.00:02:23
    Creating a Database - Part II
  24. Урок 24.00:02:17
    Introduction to data types
  25. Урок 25.00:05:02
    String data types
  26. Урок 26.00:04:11
    Integers
  27. Урок 27.00:05:45
    Fixed and floating-point data types
  28. Урок 28.00:06:13
    Other useful data types
  29. Урок 29.00:05:18
    Creating a table
  30. Урок 30.00:03:04
    Using databases and tables
  31. Урок 31.00:02:13
    Additional notes on using tables
  32. Урок 32.00:05:24
    PRIMARY KEY constraint
  33. Урок 33.00:05:26
    FOREIGN KEY constraint - Part I
  34. Урок 34.00:05:27
    FOREIGN KEY constraint - Part II
  35. Урок 35.00:05:01
    UNIQUE Constraint
  36. Урок 36.00:05:25
    DEFAULT Constraint
  37. Урок 37.00:05:54
    NOT NULL Constraint - Part I
  38. Урок 38.00:02:00
    NOT NULL Constraint - Part II
  39. Урок 39.00:05:35
    Coding techniques and best practices - Part I
  40. Урок 40.00:04:12
    Coding techniques and best practices - Part II
  41. Урок 41.00:02:20
    Loading the 'employees' database
  42. Урок 42.00:04:58
    SELECT - FROM
  43. Урок 43.00:02:31
    WHERE
  44. Урок 44.00:02:15
    AND
  45. Урок 45.00:03:36
    OR
  46. Урок 46.00:03:35
    Operator precedence
  47. Урок 47.00:03:13
    IN - NOT IN
  48. Урок 48.00:03:37
    LIKE - NOT LIKE
  49. Урок 49.00:01:46
    Wildcard characters
  50. Урок 50.00:02:21
    BETWEEN - AND
  51. Урок 51.00:01:38
    IS NOT NULL - IS NULL
  52. Урок 52.00:04:31
    Other comparison operators
  53. Урок 53.00:02:07
    SELECT DISTINCT
  54. Урок 54.00:05:25
    Introduction to aggregate functions
  55. Урок 55.00:03:47
    ORDER BY
  56. Урок 56.00:06:01
    GROUP BY
  57. Урок 57.00:02:09
    Using Aliases (AS)
  58. Урок 58.00:03:27
    HAVING
  59. Урок 59.00:04:05
    WHERE vs HAVING- Part I
  60. Урок 60.00:03:09
    WHERE vs HAVING- Part II
  61. Урок 61.00:04:53
    LIMIT
  62. Урок 62.00:06:06
    The INSERT statement - Part I
  63. Урок 63.00:02:20
    The INSERT statement - Part II
  64. Урок 64.00:03:57
    Inserting data INTO a new table
  65. Урок 65.00:02:43
    TCL's COMMIT and ROLLBACK
  66. Урок 66.00:03:19
    The UPDATE Statement - Part I
  67. Урок 67.00:02:56
    The UPDATE Statement - Part II
  68. Урок 68.00:04:15
    The DELETE Statement - Part I
  69. Урок 69.00:01:31
    The DELETE Statement - Part II
  70. Урок 70.00:03:24
    DROP vs TRUNCATE vs DELETE
  71. Урок 71.00:04:15
    COUNT()
  72. Урок 72.00:01:32
    SUM()
  73. Урок 73.00:01:16
    MIN() and MAX()
  74. Урок 74.00:01:59
    AVG()
  75. Урок 75.00:02:07
    ROUND()
  76. Урок 76.00:06:26
    IFNULL() and COALESCE()
  77. Урок 77.00:01:37
    Another Example of Using COALESCE()
  78. Урок 78.00:04:24
    Introduction to JOINs
  79. Урок 79.00:06:04
    INNER JOIN - Part I
  80. Урок 80.00:05:34
    INNER JOIN - Part II
  81. Урок 81.00:04:10
    A Note on Using Joins
  82. Урок 82.00:04:22
    Duplicate Records
  83. Урок 83.00:04:32
    LEFT JOIN - Part I
  84. Урок 84.00:05:47
    LEFT JOIN - Part II
  85. Урок 85.00:04:31
    RIGHT JOIN
  86. Урок 86.00:04:18
    The new and the old join syntax
  87. Урок 87.00:02:54
    JOIN and WHERE Used Together
  88. Урок 88.00:07:43
    CROSS JOIN
  89. Урок 89.00:02:18
    Using Aggregate Functions with Joins
  90. Урок 90.00:04:28
    JOIN more than two tables in SQL
  91. Урок 91.00:05:40
    Tips and tricks for joins
  92. Урок 92.00:05:45
    UNION vs UNION ALL
  93. Урок 93.00:04:32
    SQL Subqueries with IN nested inside WHERE
  94. Урок 94.00:03:43
    SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE
  95. Урок 95.00:07:58
    SQL Subqueries nested in SELECT and FROM
  96. Урок 96.00:07:46
    Self Join
  97. Урок 97.00:07:13
    Views
  98. Урок 98.00:03:27
    Introduction to stored routines
  99. Урок 99.00:04:33
    The MySQL syntax for stored procedures
  100. Урок 100.00:02:46
    Stored procedures - Example - Part I
  101. Урок 101.00:04:50
    Stored procedures - Example - Part II
  102. Урок 102.00:03:20
    Another way to create a procedure
  103. Урок 103.00:06:30
    Stored procedures with an input parameter
  104. Урок 104.00:03:21
    Stored procedures with an output parameter
  105. Урок 105.00:06:51
    Variables
  106. Урок 106.00:06:15
    User-defined functions in MySQL
  107. Урок 107.00:03:56
    Stored routines - conclusion
  108. Урок 108.00:04:57
    Types of MySQL Variables - Local Variables
  109. Урок 109.00:05:22
    Session Variables
  110. Урок 110.00:02:19
    Global Variables
  111. Урок 111.00:04:13
    User-Defined vs System Variables
  112. Урок 112.00:07:28
    MySQL Indexes
  113. Урок 113.00:05:58
    The CASE Statement
  114. Урок 114.00:05:21
    The Advantages of Software Integration
  115. Урок 115.00:04:55
    Why Combining SQL and Tableau is useful
  116. Урок 116.00:01:52
    Installing Tableau Public
  117. Урок 117.00:03:23
    Loading the 'employees_mod' Database
  118. Урок 118.00:05:34
    Task 1
  119. Урок 119.00:04:42
    Task 1: SQL Solution
  120. Урок 120.00:04:14
    Transferring a Dataset from SQL to Tableau
  121. Урок 121.00:06:18
    Chart 1: Visualizing and Analyzing the Solution in Tableau - Part I
  122. Урок 122.00:05:26
    Chart 1: Visualizing and Analyzing the Solution in Tableau - Part II
  123. Урок 123.00:03:51
    Task 2
  124. Урок 124.00:03:44
    Task 2: SQL Solution
  125. Урок 125.00:06:09
    Chart 2: Visualizing and Analyzing the Solution in Tableau
  126. Урок 126.00:02:22
    Task 3
  127. Урок 127.00:03:15
    Task 3: SQL Solution
  128. Урок 128.00:04:57
    Chart 3: Visualizing and Analyzing the Solution in Tableau
  129. Урок 129.00:02:46
    Task 4
  130. Урок 130.00:02:48
    Task 4: Solution in SQL
  131. Урок 131.00:03:23
    Chart 4: Visualizing and Analyzing the Solution in Tableau
  132. Урок 132.00:06:05
    Task 5: Organizing Charts 1-4 into a Beautiful Dashboard using Tableau