Видео курса

  • Урок 1. 00:00:19
    Introduction
  • Урок 2. 00:03:25
    What is SQL
  • Урок 3. 00:04:59
    Installing MySQL on Mac
  • Урок 4. 00:05:21
    Installing MySQL on Windows
  • Урок 5. 00:08:33
    Creating the Databases
  • Урок 6. 00:02:32
    What You'll Learn
  • Урок 7. 00:05:51
    The SELECT Statement
  • Урок 8. 00:08:49
    The SELECT Clause
  • Урок 9. 00:05:18
    The WHERE Clause
  • Урок 10. 00:06:53
    The AND, OR and NOT Operators
  • Урок 11. 00:03:04
    The IN Operator
  • Урок 12. 00:02:13
    The BETWEEN Operator
  • Урок 13. 00:05:38
    The LIKE Operator
  • Урок 14. 00:09:22
    The REGEXP Operator
  • Урок 15. 00:02:27
    The IS NULL Operator
  • Урок 16. 00:07:07
    The ORDER BY Clause
  • Урок 17. 00:03:27
    The LIMIT Clause
  • Урок 18. 00:08:27
    Inner Joins
  • Урок 19. 00:02:48
    Joining Across Databases
  • Урок 20. 00:04:14
    Self Joins
  • Урок 21. 00:06:47
    Joining Multiple Tables
  • Урок 22. 00:03:42
    Compound Join Conditions
  • Урок 23. 00:02:21
    Implicit Join Syntax
  • Урок 24. 00:06:28
    Outer Joins
  • Урок 25. 00:06:19
    Outer Join Between Multiple Tables
  • Урок 26. 00:02:13
    Self Outer Joins
  • Урок 27. 00:05:23
    The USING Clause
  • Урок 28. 00:01:22
    Natural Joins
  • Урок 29. 00:03:15
    Cross Joins
  • Урок 30. 00:08:30
    Unions
  • Урок 31. 00:03:25
    Column Attributes
  • Урок 32. 00:05:47
    Inserting a Row
  • Урок 33. 00:03:19
    Inserting Multiple Rows
  • Урок 34. 00:05:54
    Inserting Hierarchical Rows
  • Урок 35. 00:08:48
    Creating a Copy of a Table
  • Урок 36. 00:03:56
    Updating a Single Row
  • Урок 37. 00:03:15
    Updating Multiple Rows
  • Урок 38. 00:05:38
    Using Subqueries in Updates
  • Урок 39. 00:01:25
    Deleting Rows
  • Урок 40. 00:01:07
    Restoring the Databases
  • Урок 41. 00:09:20
    Aggregate Functions
  • Урок 42. 00:07:22
    The GROUP BY Clause
  • Урок 43. 00:08:51
    The HAVING Clause
  • Урок 44. 00:05:06
    The ROLLUP Operator
  • Урок 45. 00:01:29
    Introduction
  • Урок 46. 00:02:30
    Subqueries
  • Урок 47. 00:03:40
    The IN Operator
  • Урок 48. 00:05:08
    Subqueries vs Joins
  • Урок 49. 00:04:53
    The ALL Keyword
  • Урок 50. 00:02:37
    The ANY Keyword
  • Урок 51. 00:05:37
    Correlated Subqueries
  • Урок 52. 00:05:40
    The EXISTS Operator
  • Урок 53. 00:04:30
    Subqueries in the SELECT Clause
  • Урок 54. 00:02:59
    Subqueries in the FROM Clause
  • Урок 55. 00:02:55
    Numeric Functions
  • Урок 56. 00:05:48
    String Functions
  • Урок 57. 00:04:09
    Date Functions in MySQL
  • Урок 58. 00:02:15
    Formatting Dates and Times
  • Урок 59. 00:03:09
    Calculating Dates and Times
  • Урок 60. 00:03:30
    The IFNULL and COALESCE Functions
  • Урок 61. 00:04:55
    The IF Function
  • Урок 62. 00:05:24
    The CASE Operator
  • Урок 63. 00:05:37
    Creating Views
  • Урок 64. 00:02:53
    Altering or Dropping Views
  • Урок 65. 00:05:13
    Updatable Views
  • Урок 66. 00:02:19
    THE WITH OPTION CHECK Clause
  • Урок 67. 00:02:38
    Other Benefits of Views
  • Урок 68. 00:02:19
    What are Stored Procedures
  • Урок 69. 00:05:35
    Creating a Stored Procedure
  • Урок 70. 00:01:22
    Creating Procedures Using MySQLWorkbench
  • Урок 71. 00:02:10
    Dropping Stored Procedures
  • Урок 72. 00:05:27
    Parameters
  • Урок 73. 00:08:19
    Parameters with Default Value
  • Урок 74. 00:06:41
    Parameter Validation
  • Урок 75. 00:03:56
    Output Parameters
  • Урок 76. 00:04:34
    Variables
  • Урок 77. 00:06:29
    Functions
  • Урок 78. 00:01:52
    Other Conventions
  • Урок 79. 00:07:32
    Triggers
  • Урок 80. 00:01:21
    Viewing Triggers
  • Урок 81. 00:00:53
    Dropping Triggers
  • Урок 82. 00:04:53
    Using Triggers for Auditing
  • Урок 83. 00:04:34
    Events
  • Урок 84. 00:02:05
    Viewing, Dropping and Altering Events
  • Урок 85. 00:02:45
    Transactions
  • Урок 86. 00:05:12
    Creating Transactions
  • Урок 87. 00:04:08
    Concurrency and Locking
  • Урок 88. 00:07:26
    Concurrency Problems
  • Урок 89. 00:05:43
    Transaction Isolation Levels
  • Урок 90. 00:03:27
    READ UNCOMMITTED Isolation Level
  • Урок 91. 00:03:02
    READ COMMITTED Isolation Level
  • Урок 92. 00:03:30
    REPEATABLE READ Isolation Level
  • Урок 93. 00:02:19
    SERIALIZABLE Isolation Level
  • Урок 94. 00:06:12
    Deadlocks
  • Урок 95. 00:00:44
    Introduction
  • Урок 96. 00:02:26
    String Types
  • Урок 97. 00:02:53
    Integer Types
  • Урок 98. 00:01:43
    Fixed-point and Floating-point Types
  • Урок 99. 00:00:47
    Boolean Types
  • Урок 100. 00:03:37
    Enum and Set Types
  • Урок 101. 00:00:45
    Date and Time Types
  • Урок 102. 00:01:18
    Blob Types
  • Урок 103. 00:10:25
    JSON Type
  • Урок 104. 00:01:26
    Introduction
  • Урок 105. 00:02:27
    Data Modelling
  • Урок 106. 00:04:35
    Conceptual Models
  • Урок 107. 00:07:25
    Logical Models
  • Урок 108. 00:06:29
    Physical Models
  • Урок 109. 00:03:24
    Primary Keys
  • Урок 110. 00:05:49
    Foreign Keys
  • Урок 111. 00:05:23
    Foreign Key Constraints
  • Урок 112. 00:01:25
    Normalization
  • Урок 113. 00:02:43
    1NF- First Normal Form
  • Урок 114. 00:04:02
    Link Tables
  • Урок 115. 00:06:34
    2NF- Second Normal Form
  • Урок 116. 00:01:44
    3NF- Third Normal Form
  • Урок 117. 00:02:56
    My Pragmatic Advice
  • Урок 118. 00:04:25
    Don't Model the Universe
  • Урок 119. 00:02:36
    Forward Engineering a Model
  • Урок 120. 00:04:49
    Synchronizing a Model with a Database
  • Урок 121. 00:03:12
    Reverse Engineering a Database
  • Урок 122. 00:00:24
    Project- Flight Booking System
  • Урок 123. 00:08:01
    Solution- Conceptual Model
  • Урок 124. 00:09:04
    Solution- Logical Model
  • Урок 125. 00:01:06
    Project - Video Rental Application
  • Урок 126. 00:07:00
    Solution- Conceptual Model
  • Урок 127. 00:08:30
    Solution- Logical Model
  • Урок 128. 00:01:42
    Creating and Dropping Databases
  • Урок 129. 00:03:14
    Creating Tables
  • Урок 130. 00:02:57
    Altering Tables
  • Урок 131. 00:04:48
    Creating Relationships
  • Урок 132. 00:02:11
    Altering Primary and Foreign Key Constraints
  • Урок 133. 00:06:30
    Character Sets and Collations
  • Урок 134. 00:02:28
    Storage Engines
  • Урок 135. 00:00:42
    Introduction
  • Урок 136. 00:02:50
    Indexes
  • Урок 137. 00:05:01
    Creating Indexes
  • Урок 138. 00:03:20
    Viewing Indexes
  • Урок 139. 00:03:41
    Prefix Indexes
  • Урок 140. 00:07:51
    Full-text Indexes
  • Урок 141. 00:05:13
    Composite Indexes
  • Урок 142. 00:09:17
    Order of Columns in Composite Indexes
  • Урок 143. 00:05:04
    When Indexes are Ignored
  • Урок 144. 00:07:03
    Using Indexes for Sorting
  • Урок 145. 00:01:59
    Covering Indexese
  • Урок 146. 00:01:26
    Index Maintenance
  • Урок 147. 00:00:34
    Introduction
  • Урок 148. 00:03:14
    Creating a User
  • Урок 149. 00:01:30
    Viewing Users
  • Урок 150. 00:00:49
    Dropping Users
  • Урок 151. 00:01:07
    Changing Passwords
  • Урок 152. 00:04:54
    Granting Privileges
  • Урок 153. 00:01:35
    Viewing Privileges
  • Урок 154. 00:01:21
    Revoking Privileges
  • Урок 155. 00:00:45
    Wrap Up