1. Урок 1.00:00:19
    Introduction
  2. Урок 2.00:03:25
    What is SQL
  3. Урок 3.00:04:59
    Installing MySQL on Mac
  4. Урок 4.00:05:21
    Installing MySQL on Windows
  5. Урок 5.00:08:33
    Creating the Databases
  6. Урок 6.00:02:32
    What You'll Learn
  7. Урок 7.00:05:51
    The SELECT Statement
  8. Урок 8.00:08:49
    The SELECT Clause
  9. Урок 9.00:05:18
    The WHERE Clause
  10. Урок 10.00:06:53
    The AND, OR and NOT Operators
  11. Урок 11.00:03:04
    The IN Operator
  12. Урок 12.00:02:13
    The BETWEEN Operator
  13. Урок 13.00:05:38
    The LIKE Operator
  14. Урок 14.00:09:22
    The REGEXP Operator
  15. Урок 15.00:02:27
    The IS NULL Operator
  16. Урок 16.00:07:07
    The ORDER BY Clause
  17. Урок 17.00:03:27
    The LIMIT Clause
  18. Урок 18.00:08:27
    Inner Joins
  19. Урок 19.00:02:48
    Joining Across Databases
  20. Урок 20.00:04:14
    Self Joins
  21. Урок 21.00:06:47
    Joining Multiple Tables
  22. Урок 22.00:03:42
    Compound Join Conditions
  23. Урок 23.00:02:21
    Implicit Join Syntax
  24. Урок 24.00:06:28
    Outer Joins
  25. Урок 25.00:06:19
    Outer Join Between Multiple Tables
  26. Урок 26.00:02:13
    Self Outer Joins
  27. Урок 27.00:05:23
    The USING Clause
  28. Урок 28.00:01:22
    Natural Joins
  29. Урок 29.00:03:15
    Cross Joins
  30. Урок 30.00:08:30
    Unions
  31. Урок 31.00:03:25
    Column Attributes
  32. Урок 32.00:05:47
    Inserting a Row
  33. Урок 33.00:03:19
    Inserting Multiple Rows
  34. Урок 34.00:05:54
    Inserting Hierarchical Rows
  35. Урок 35.00:08:48
    Creating a Copy of a Table
  36. Урок 36.00:03:56
    Updating a Single Row
  37. Урок 37.00:03:15
    Updating Multiple Rows
  38. Урок 38.00:05:38
    Using Subqueries in Updates
  39. Урок 39.00:01:25
    Deleting Rows
  40. Урок 40.00:01:07
    Restoring the Databases
  41. Урок 41.00:09:20
    Aggregate Functions
  42. Урок 42.00:07:22
    The GROUP BY Clause
  43. Урок 43.00:08:51
    The HAVING Clause
  44. Урок 44.00:05:06
    The ROLLUP Operator
  45. Урок 45.00:01:29
    Introduction
  46. Урок 46.00:02:30
    Subqueries
  47. Урок 47.00:03:40
    The IN Operator
  48. Урок 48.00:05:08
    Subqueries vs Joins
  49. Урок 49.00:04:53
    The ALL Keyword
  50. Урок 50.00:02:37
    The ANY Keyword
  51. Урок 51.00:05:37
    Correlated Subqueries
  52. Урок 52.00:05:40
    The EXISTS Operator
  53. Урок 53.00:04:30
    Subqueries in the SELECT Clause
  54. Урок 54.00:02:59
    Subqueries in the FROM Clause
  55. Урок 55.00:02:55
    Numeric Functions
  56. Урок 56.00:05:48
    String Functions
  57. Урок 57.00:04:09
    Date Functions in MySQL
  58. Урок 58.00:02:15
    Formatting Dates and Times
  59. Урок 59.00:03:09
    Calculating Dates and Times
  60. Урок 60.00:03:30
    The IFNULL and COALESCE Functions
  61. Урок 61.00:04:55
    The IF Function
  62. Урок 62.00:05:24
    The CASE Operator
  63. Урок 63.00:05:37
    Creating Views
  64. Урок 64.00:02:53
    Altering or Dropping Views
  65. Урок 65.00:05:13
    Updatable Views
  66. Урок 66.00:02:19
    THE WITH OPTION CHECK Clause
  67. Урок 67.00:02:38
    Other Benefits of Views
  68. Урок 68.00:02:19
    What are Stored Procedures
  69. Урок 69.00:05:35
    Creating a Stored Procedure
  70. Урок 70.00:01:22
    Creating Procedures Using MySQLWorkbench
  71. Урок 71.00:02:10
    Dropping Stored Procedures
  72. Урок 72.00:05:27
    Parameters
  73. Урок 73.00:08:19
    Parameters with Default Value
  74. Урок 74.00:06:41
    Parameter Validation
  75. Урок 75.00:03:56
    Output Parameters
  76. Урок 76.00:04:34
    Variables
  77. Урок 77.00:06:29
    Functions
  78. Урок 78.00:01:52
    Other Conventions
  79. Урок 79.00:07:32
    Triggers
  80. Урок 80.00:01:21
    Viewing Triggers
  81. Урок 81.00:00:53
    Dropping Triggers
  82. Урок 82.00:04:53
    Using Triggers for Auditing
  83. Урок 83.00:04:34
    Events
  84. Урок 84.00:02:05
    Viewing, Dropping and Altering Events
  85. Урок 85.00:02:45
    Transactions
  86. Урок 86.00:05:12
    Creating Transactions
  87. Урок 87.00:04:08
    Concurrency and Locking
  88. Урок 88.00:07:26
    Concurrency Problems
  89. Урок 89.00:05:43
    Transaction Isolation Levels
  90. Урок 90.00:03:27
    READ UNCOMMITTED Isolation Level
  91. Урок 91.00:03:02
    READ COMMITTED Isolation Level
  92. Урок 92.00:03:30
    REPEATABLE READ Isolation Level
  93. Урок 93.00:02:19
    SERIALIZABLE Isolation Level
  94. Урок 94.00:06:12
    Deadlocks
  95. Урок 95.00:00:44
    Introduction
  96. Урок 96.00:02:26
    String Types
  97. Урок 97.00:02:53
    Integer Types
  98. Урок 98.00:01:43
    Fixed-point and Floating-point Types
  99. Урок 99.00:00:47
    Boolean Types
  100. Урок 100.00:03:37
    Enum and Set Types
  101. Урок 101.00:00:45
    Date and Time Types
  102. Урок 102.00:01:18
    Blob Types
  103. Урок 103.00:10:25
    JSON Type
  104. Урок 104.00:01:26
    Introduction
  105. Урок 105.00:02:27
    Data Modelling
  106. Урок 106.00:04:35
    Conceptual Models
  107. Урок 107.00:07:25
    Logical Models
  108. Урок 108.00:06:29
    Physical Models
  109. Урок 109.00:03:24
    Primary Keys
  110. Урок 110.00:05:49
    Foreign Keys
  111. Урок 111.00:05:23
    Foreign Key Constraints
  112. Урок 112.00:01:25
    Normalization
  113. Урок 113.00:02:43
    1NF- First Normal Form
  114. Урок 114.00:04:02
    Link Tables
  115. Урок 115.00:06:34
    2NF- Second Normal Form
  116. Урок 116.00:01:44
    3NF- Third Normal Form
  117. Урок 117.00:02:56
    My Pragmatic Advice
  118. Урок 118.00:04:25
    Don't Model the Universe
  119. Урок 119.00:02:36
    Forward Engineering a Model
  120. Урок 120.00:04:49
    Synchronizing a Model with a Database
  121. Урок 121.00:03:12
    Reverse Engineering a Database
  122. Урок 122.00:00:24
    Project- Flight Booking System
  123. Урок 123.00:08:01
    Solution- Conceptual Model
  124. Урок 124.00:09:04
    Solution- Logical Model
  125. Урок 125.00:01:06
    Project - Video Rental Application
  126. Урок 126.00:07:00
    Solution- Conceptual Model
  127. Урок 127.00:08:30
    Solution- Logical Model
  128. Урок 128.00:01:42
    Creating and Dropping Databases
  129. Урок 129.00:03:14
    Creating Tables
  130. Урок 130.00:02:57
    Altering Tables
  131. Урок 131.00:04:48
    Creating Relationships
  132. Урок 132.00:02:11
    Altering Primary and Foreign Key Constraints
  133. Урок 133.00:06:30
    Character Sets and Collations
  134. Урок 134.00:02:28
    Storage Engines
  135. Урок 135.00:00:42
    Introduction
  136. Урок 136.00:02:50
    Indexes
  137. Урок 137.00:05:01
    Creating Indexes
  138. Урок 138.00:03:20
    Viewing Indexes
  139. Урок 139.00:03:41
    Prefix Indexes
  140. Урок 140.00:07:51
    Full-text Indexes
  141. Урок 141.00:05:13
    Composite Indexes
  142. Урок 142.00:09:17
    Order of Columns in Composite Indexes
  143. Урок 143.00:05:04
    When Indexes are Ignored
  144. Урок 144.00:07:03
    Using Indexes for Sorting
  145. Урок 145.00:01:59
    Covering Indexese
  146. Урок 146.00:01:26
    Index Maintenance
  147. Урок 147.00:00:34
    Introduction
  148. Урок 148.00:03:14
    Creating a User
  149. Урок 149.00:01:30
    Viewing Users
  150. Урок 150.00:00:49
    Dropping Users
  151. Урок 151.00:01:07
    Changing Passwords
  152. Урок 152.00:04:54
    Granting Privileges
  153. Урок 153.00:01:35
    Viewing Privileges
  154. Урок 154.00:01:21
    Revoking Privileges
  155. Урок 155.00:00:45
    Wrap Up