Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай SQL - The Complete Guide (MySQL, PostgreSQL & more), а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:02:25
    Welcome To The Course!
  2. Урок 2. 00:06:05
    What Is SQL?
  3. Урок 3. 00:06:11
    A Closer Look At SQL & Databases
  4. Урок 4. 00:03:36
    Course Content
  5. Урок 5. 00:02:16
    There Are Two Ways Of Taking This Course!
  6. Урок 6. 00:03:06
    How To Get The Most Out Of This Course
  7. Урок 7. 00:00:49
    Module Introduction
  8. Урок 8. 00:06:37
    Understanding The Core SQL Syntax
  9. Урок 9. 00:03:34
    SQL in Action
  10. Урок 10. 00:03:50
    The Core SQL Rules
  11. Урок 11. 00:03:33
    Data Definition vs Data Manipulation
  12. Урок 12. 00:02:43
    Module Introduction
  13. Урок 13. 00:02:59
    Installing Different Database Management Systems
  14. Урок 14. 00:07:13
    What We Need To Install
  15. Урок 15. 00:10:35
    MySQL Setup Overview & macOS Setup
  16. Урок 16. 00:08:10
    MySQL Windows Setup
  17. Урок 17. 00:06:15
    Postgresql Setup Overview & macOS Setup
  18. Урок 18. 00:04:32
    Postgresql Windows Setup
  19. Урок 19. 00:15:30
    Connecting To Database Servers (MySQL & Postgresql) With Various Clients
  20. Урок 20. 00:10:44
    Setting Up Visual Studio Code With The SQLTools Extension (Course Environment)
  21. Урок 21. 00:11:59
    Configuring VS Code & Exploring SQLTools
  22. Урок 22. 00:02:02
    Module Introduction
  23. Урок 23. 00:02:43
    Key Terms When Working With Data Definition Statements & Commands
  24. Урок 24. 00:02:24
    Introducing The Course Section Example
  25. Урок 25. 00:03:12
    Introducing Key Data Definition Clauses
  26. Урок 26. 00:09:57
    Creating a new Database (CREATE DATABASE)
  27. Урок 27. 00:05:22
    The Importance Of Data Types (Value Types)
  28. Урок 28. 00:06:38
    Introducing Key Text Value Types
  29. Урок 29. 00:05:51
    Introducing Numeric Values, Date Types & More
  30. Урок 30. 00:03:37
    How Do You Store Files?
  31. Урок 31. 00:05:17
    Getting Started With The CREATE TABLE Statement & Syntax
  32. Урок 32. 00:03:50
    Creating a First Text Column
  33. Урок 33. 00:09:04
    Creating a Numeric Value Column
  34. Урок 34. 00:07:07
    Working with Enums & Finishing Table Creation
  35. Урок 35. 00:06:20
    Inserting Data Into The Created Table (INSERT INTO)
  36. Урок 36. 00:04:03
    Inserting & Querying More Data
  37. Урок 37. 00:08:54
    Working With Fixed Point & Floating Point Numbers
  38. Урок 38. 00:01:59
    Adding Boolean Value Types
  39. Урок 39. 00:05:11
    Creating a new Table with Text & Timestamp Data
  40. Урок 40. 00:07:33
    Inserting Data Into The New Tables
  41. Урок 41. 00:03:14
    Introducing Default Column Values
  42. Урок 42. 00:05:22
    Deleting (Dropping) Tables & Inserting Data With Default Values
  43. Урок 43. 00:08:58
    Updating Tables & Columns
  44. Урок 44. 00:06:28
    Dealing With "No Data" (NULL) vs "0"
  45. Урок 45. 00:09:24
    Exploring the NOT NULL Constraint
  46. Урок 46. 00:12:35
    Exploring the CHECK Constraint
  47. Урок 47. 00:11:40
    We Need Unique Values & Identifiers!
  48. Урок 48. 00:10:21
    Working With Auto Incrementing IDs & Primary Keys
  49. Урок 49. 00:02:46
    Constraints - Summary
  50. Урок 50. 00:07:36
    Understanding Text Encoding & Collation
  51. Урок 51. 00:02:41
    Temporary Tables & Tables From Other Tables
  52. Урок 52. 00:07:49
    Creating Generated Columns
  53. Урок 53. 00:03:03
    Module Summary
  54. Урок 54. 00:04:00
    Time To Practice: Problem
  55. Урок 55. 00:13:49
    Time To Practice: Solution (1/2)
  56. Урок 56. 00:08:56
    Time To Practice: Solution (2/2)
  57. Урок 57. 00:01:22
    Module Introduction
  58. Урок 58. 00:02:34
    What Are CRUD Operations?
  59. Урок 59. 00:02:35
    Inserting Data: Theory
  60. Урок 60. 00:01:25
    Selecting Data: Theory
  61. Урок 61. 00:01:38
    Updating Data: Theory
  62. Урок 62. 00:01:23
    Deleting Data: Theory
  63. Урок 63. 00:03:34
    Introducing The Section Example
  64. Урок 64. 00:07:47
    Setting Up An Example Database & Table
  65. Урок 65. 00:07:27
    Example: Inserting Data
  66. Урок 66. 00:01:12
    Inserting More (Dummy) Data
  67. Урок 67. 00:05:23
    Updating In Action
  68. Урок 68. 00:02:09
    Deleting In Action
  69. Урок 69. 00:04:43
    Selecting Data - The Basics
  70. Урок 70. 00:05:03
    SELECT, Column Names & Data Expressions
  71. Урок 71. 00:04:24
    Filtering with WHERE: Available Comparison Operators & Variations
  72. Урок 72. 00:03:40
    Filtering In Action (WHERE In Action)
  73. Урок 73. 00:03:37
    Combining Comparisons With AND & OR
  74. Урок 74. 00:07:16
    Greater, Smaller & Ranges
  75. Урок 75. 00:04:30
    Filtering Text Values
  76. Урок 76. 00:05:17
    Working With Dates & Date Differences
  77. Урок 77. 00:02:10
    Introducing ORDER BY & LIMIT
  78. Урок 78. 00:07:24
    Ordering & Limiting Results In Action
  79. Урок 79. 00:01:42
    Looking For DISTINCT Values
  80. Урок 80. 00:07:06
    Subqueries & Views
  81. Урок 81. 00:02:34
    Module Summary
  82. Урок 82. 00:01:46
    Module Introduction
  83. Урок 83. 00:04:10
    A First Look At Related Data
  84. Урок 84. 00:04:04
    Data Normalization - First Steps
  85. Урок 85. 00:09:49
    Splitting Data Into Tables
  86. Урок 86. 00:03:06
    Forms Of Data Normalization
  87. Урок 87. 00:04:10
    Our First Section Example
  88. Урок 88. 00:10:24
    Creating Tables With Relations
  89. Урок 89. 00:08:12
    Inserting Related Data
  90. Урок 90. 00:04:07
    Joining Data & Introducing INNER JOIN
  91. Урок 91. 00:08:11
    Using INNER JOIN
  92. Урок 92. 00:04:14
    Combining Multiple JOINs
  93. Урок 93. 00:03:49
    Data Joining & Filtering
  94. Урок 94. 00:02:11
    Introducing LEFT JOIN
  95. Урок 95. 00:03:58
    Using LEFT JOIN
  96. Урок 96. 00:02:41
    Combining Multiple LEFT JOINs
  97. Урок 97. 00:01:24
    What About RIGHT JOIN?
  98. Урок 98. 00:12:11
    Example Time & INNER JOIN vs LEFT JOIN
  99. Урок 99. 00:01:44
    Introducing CROSS JOIN
  100. Урок 100. 00:08:52
    UNION & Why It's Different
  101. Урок 101. 00:05:08
    What's Wrong With Our Foreign Keys?
  102. Урок 102. 00:04:07
    Introducing Foreign Key Constraints
  103. Урок 103. 00:05:36
    Diving Deeper Into Foreign Key Constraints
  104. Урок 104. 00:12:06
    Foreign Key Constraints In Action
  105. Урок 105. 00:04:35
    Data Relationship Types: One-to-Many, Many-to-Many, One-to-ONe
  106. Урок 106. 00:05:40
    A Bigger Example
  107. Урок 107. 00:16:57
    Example: Adding First Tables & Relations
  108. Урок 108. 00:11:11
    Example: Adding More Tables & Data
  109. Урок 109. 00:07:19
    Many-to-Many Relationships & Intermediate Tables ("Linking Tables")
  110. Урок 110. 00:08:58
    Querying The Example Data
  111. Урок 111. 00:09:14
    Practicing JOINs With Filtering
  112. Урок 112. 00:06:01
    Experimenting With Referential Integrity
  113. Урок 113. 00:01:31
    Module Introduction
  114. Урок 114. 00:02:52
    Remember: Primary Keys Don't Have To Be Auto-Incrementing IDs!
  115. Урок 115. 00:07:53
    Introducing Composite Primary Keys
  116. Урок 116. 00:02:37
    Defining Composite Primary Keys (Composite Keys In Action)
  117. Урок 117. 00:04:48
    Composite Foreign Keys
  118. Урок 118. 00:02:52
    Composite Keys In Action
  119. Урок 119. 00:09:25
    Self-Referencing Relationships (Self-Referential Relationships)
  120. Урок 120. 00:07:59
    Self-Referencing Many To Many Relationships
  121. Урок 121. 00:01:28
    Module Introduction
  122. Урок 122. 00:04:38
    The Module Project
  123. Урок 123. 00:04:24
    What are Aggregate Functions - Theory
  124. Урок 124. 00:10:56
    Understanding COUNT()
  125. Урок 125. 00:07:39
    Working with MIN() & MAX() and Adding Aliases to Aggregate Functions
  126. Урок 126. 00:06:17
    Using SUM(), AVG() & ROUND()
  127. Урок 127. 00:11:35
    Working with Filters & Joining Tables
  128. Урок 128. 00:05:04
    Theory Time - Understanding GROUP BY
  129. Урок 129. 00:04:41
    Applying GROUP BY in Practice
  130. Урок 130. 00:06:12
    GROUP BY & Joined Queries
  131. Урок 131. 00:10:01
    Understanding WHERE vs HAVING
  132. Урок 132. 00:07:30
    Applying HAVING in Practice
  133. Урок 133. 00:11:01
    Working with Nested Subqueries
  134. Урок 134. 00:08:19
    Introducing Window Functions
  135. Урок 135. 00:07:01
    Understanding ORDER BY and RANK()
  136. Урок 136. 00:01:57
    Module Introduction
  137. Урок 137. 00:03:12
    The Module Project
  138. Урок 138. 00:14:29
    Working with Mathematical Functions & Arithmetic Operators
  139. Урок 139. 00:06:57
    Understanding String Functions with SELECT
  140. Урок 140. 00:08:49
    Using String Functions with INSERT
  141. Урок 141. 00:04:41
    Understanding Date / Time Functions
  142. Урок 142. 00:08:08
    Working with Weekdays
  143. Урок 143. 00:09:42
    Calculating INTERVALS
  144. Урок 144. 00:07:55
    Adding INTERVALS to Dates
  145. Урок 145. 00:09:52
    Understanding LIKE & Pattern Matching
  146. Урок 146. 00:06:19
    Understanding EXISTS
  147. Урок 147. 00:03:57
    Working with Subquery Expressions and EXISTS
  148. Урок 148. 00:08:10
    Working with Subquery Expressions and IN
  149. Урок 149. 00:07:16
    Introducing Conditional Expressions
  150. Урок 150. 00:04:41
    Challenge Solution
  151. Урок 151. 00:03:21
    Database (SQL) vs Application Level
  152. Урок 152. 00:00:53
    Module Introduction
  153. Урок 153. 00:02:19
    Understanding Transactions
  154. Урок 154. 00:09:20
    Applying Transactions & ROLLBACK
  155. Урок 155. 00:08:15
    Committing Changes
  156. Урок 156. 00:04:37
    Working with Savepoints
  157. Урок 157. 00:04:53
    Transactions in PostgreSQL
  158. Урок 158. 00:01:16
    Module Introduction
  159. Урок 159. 00:06:40
    What Are Indexes? And Why Would You Need Them?
  160. Урок 160. 00:04:33
    Don't Use Too Many Indexes!
  161. Урок 161. 00:05:07
    Index Types: An Overview
  162. Урок 162. 00:03:16
    Setting Up Some Example Data
  163. Урок 163. 00:05:17
    EXPLAINing Queries & Query Planning
  164. Урок 164. 00:05:52
    Creating & Using Single-Column Indexes
  165. Урок 165. 00:02:06
    Unique Indexes
  166. Урок 166. 00:09:21
    Working With Multi-Column Indexes (Composite Indexes)
  167. Урок 167. 00:02:37
    Partial Indexes
  168. Урок 168. 00:01:49
    Module Introduction
  169. Урок 169. 00:06:05
    What Is SQL?
  170. Урок 170. 00:06:11
    A Closer Look At Databases In General
  171. Урок 171. 00:06:50
    The Core SQL Syntax
  172. Урок 172. 00:05:06
    Course Setup (For Following Along)
  173. Урок 173. 00:06:07
    Analyzing The Section Example Project
  174. Урок 174. 00:03:36
    Introducing "Data Normalization"
  175. Урок 175. 00:10:26
    Planning Tables & Relationships
  176. Урок 176. 00:04:13
    Creating A New Database
  177. Урок 177. 00:03:11
    Choosing Identifier Names
  178. Урок 178. 00:03:44
    Defining Columns
  179. Урок 179. 00:05:33
    Exploring Important Data Types
  180. Урок 180. 00:04:14
    How To Store Files & Adding More Data Types
  181. Урок 181. 00:05:20
    Constraints: An Introduction
  182. Урок 182. 00:02:37
    Introducing Database Functions
  183. Урок 183. 00:06:38
    Understanding Primary Keys & Unique IDs
  184. Урок 184. 00:08:13
    INSERTing Data
  185. Урок 185. 00:02:29
    Basic Data Querying (via SELECT)
  186. Урок 186. 00:05:58
    UPDATE & DELETE In Action
  187. Урок 187. 00:04:37
    Filtering (WHERE) & Sorting (ORDER BY)
  188. Урок 188. 00:08:24
    Adding More Tables
  189. Урок 189. 00:09:11
    Relations & Foreign Keys
  190. Урок 190. 00:03:39
    Understanding ON DELETE & ON UPDATE
  191. Урок 191. 00:07:15
    Adding More Tables & Relationships
  192. Урок 192. 00:08:48
    Many To Many Relationships & Linking (Intermediate) Tables
  193. Урок 193. 00:13:27
    Inserting Related Data
  194. Урок 194. 00:11:18
    Connecting Data With INNER JOIN
  195. Урок 195. 00:05:21
    Combining Multiple Joins
  196. Урок 196. 00:10:33
    Introducing LEFT JOIN
  197. Урок 197. 00:04:02
    Joining Data & Filtering
  198. Урок 198. 00:06:03
    Filtering Text With LIKE
  199. Урок 199. 00:03:57
    Introducing Aggregate Functions
  200. Урок 200. 00:05:43
    Grouping Aggregate Results (GROUP BY)
  201. Урок 201. 00:03:32
    The HAVING Clause (vs WHERE)
  202. Урок 202. 00:01:45
    Module Summary
  203. Урок 203. 00:00:54
    Congratulations + More Content