Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Complete SQL + Databases Bootcamp: Zero to Mastery, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:07:52
    Course Outline
  2. Урок 2. 00:02:24
    The Big Data Breach At Keiko Corp
  3. Урок 3. 00:05:58
    What Is a Database?
  4. Урок 4. 00:06:36
    I Didn't Learn Anything, Try Again...
  5. Урок 5. 00:07:45
    Database Management System (DBMS)
  6. Урок 6. 00:05:35
    Exercise: Building Amazon
  7. Урок 7. 00:05:29
    Exercise: Building Amazon 2
  8. Урок 8. 00:05:38
    5 Types Of Databases
  9. Урок 9. 00:01:12
    Exercise: What Is A Database?
  10. Урок 10. 00:01:30
    Section Review
  11. Урок 11. 00:01:55
    SQL Playground
  12. Урок 12. 00:02:18
    What Is SQL
  13. Урок 13. 00:06:25
    What Is A Query?
  14. Урок 14. 00:03:25
    Imperative vs Declarative
  15. Урок 15. 00:02:22
    History of SQL
  16. Урок 16. 00:04:26
    SQL Standards
  17. Урок 17. 00:05:37
    What Is A Database? Revisited
  18. Урок 18. 00:06:52
    Database Oriented Approach
  19. Урок 19. 00:01:22
    Database Models
  20. Урок 20. 00:08:04
    Hierarchical And Networking Model
  21. Урок 21. 00:07:18
    Relational Model
  22. Урок 22. 00:13:57
    DBMS Revisited
  23. Урок 23. 00:01:07
    Relational Model Revisited
  24. Урок 24. 00:03:46
    Tables
  25. Урок 25. 00:04:08
    Columns
  26. Урок 26. 00:02:28
    Rows
  27. Урок 27. 00:05:04
    Primary And Foreign Keys
  28. Урок 28. 00:03:17
    OLTP vs OLAP
  29. Урок 29. 00:03:21
    Exercise: OLTP vs OLAP
  30. Урок 30. 00:01:53
    Why PostgreSQL
  31. Урок 31. 00:03:11
    Environment Tooling
  32. Урок 32. 00:05:22
    Command Line 101
  33. Урок 33. 00:04:53
    WINDOWS Setup
  34. Урок 34. 00:04:28
    Optional: Setting Up Windows For Command Line
  35. Урок 35. 00:06:31
    MAC Setup
  36. Урок 36. 00:05:37
    LINUX Setup
  37. Урок 37. 00:08:29
    Importing Data On WINDOWS
  38. Урок 38. 00:06:39
    Importing Data On MAC
  39. Урок 39. 00:04:58
    Importing Data On LINUX
  40. Урок 40. 00:05:15
    Starting With Query
  41. Урок 41. 00:10:11
    Exercise: Simple Queries
  42. Урок 42. 00:03:20
    Exercise: Renaming Columns
  43. Урок 43. 00:04:52
    Concat Function
  44. Урок 44. 00:06:47
    What Is A Function In SQL?
  45. Урок 45. 00:05:20
    Aggregate Functions
  46. Урок 46. 00:09:33
    Commenting Your Queries
  47. Урок 47. 00:08:40
    Common SELECT Mistakes
  48. Урок 48. 00:05:45
    Filtering Data
  49. Урок 49. 00:14:16
    AND and OR
  50. Урок 50. 00:07:57
    Exercise: Filtering Data
  51. Урок 51. 00:07:19
    The NOT Keyword
  52. Урок 52. 00:06:47
    Comparison Operators
  53. Урок 53. 00:07:32
    Logical Operators
  54. Урок 54. 00:09:39
    Operator Precedence
  55. Урок 55. 00:11:32
    Operator Precedence 2
  56. Урок 56. 00:12:02
    Checking For NULL Values
  57. Урок 57. 00:13:43
    IS Keyword
  58. Урок 58. 00:07:13
    NULL Coalescing
  59. Урок 59. 00:12:25
    3 Valued Logic
  60. Урок 60. 00:02:07
    BETWEEN + AND
  61. Урок 61. 00:03:25
    IN Keyword
  62. Урок 62. 00:13:18
    LIKE
  63. Урок 63. 00:12:54
    Dates And Timezones
  64. Урок 64. 00:03:38
    Setting Up Timezones
  65. Урок 65. 00:06:16
    How Do We Format Date And Time?
  66. Урок 66. 00:10:28
    Timestamps
  67. Урок 67. 00:04:53
    Date Functions
  68. Урок 68. 00:01:48
    Date Difference And Casting
  69. Урок 69. 00:02:10
    Age Calculation
  70. Урок 70. 00:02:52
    Extracting Information
  71. Урок 71. 00:03:14
    Intervals
  72. Урок 72. 00:04:12
    DISTINCT
  73. Урок 73. 00:06:18
    Sorting Data
  74. Урок 74. 00:10:48
    Multi Table SELECT
  75. Урок 75. 00:19:43
    Inner Join
  76. Урок 76. 00:04:55
    Self Join
  77. Урок 77. 00:11:31
    Outer Join
  78. Урок 78. 00:06:37
    Less Common Joins
  79. Урок 79. 00:04:30
    USING Keyword
  80. Урок 80. 00:14:44
    GROUP BY
  81. Урок 81. 00:07:39
    HAVING Keyword
  82. Урок 82. 00:01:45
    Ordering Grouped Data
  83. Урок 83. 00:12:11
    Group By Mental Model
  84. Урок 84. 00:09:30
    Grouping Sets
  85. Урок 85. 00:07:18
    Rollup
  86. Урок 86. 00:03:31
    Window What?
  87. Урок 87. 00:08:53
    Looking Through The Window
  88. Урок 88. 00:05:51
    PARTITION BY
  89. Урок 89. 00:05:35
    Order By Acting Strange
  90. Урок 90. 00:14:13
    Using Framing In Window Function
  91. Урок 91. 00:10:50
    Solving For Current Salary
  92. Урок 92. 00:05:49
    FIRST_VALUE
  93. Урок 93. 00:04:04
    LAST_VALUE
  94. Урок 94. 00:05:33
    SUM
  95. Урок 95. 00:03:04
    ROW_NUMBER
  96. Урок 96. 00:06:15
    Conditional Statements
  97. Урок 97. 00:02:26
    NULLIF
  98. Урок 98. 00:03:42
    Views...What Are They Good For?
  99. Урок 99. 00:05:37
    View Syntax
  100. Урок 100. 00:12:25
    Using Views
  101. Урок 101. 00:11:10
    Indexes
  102. Урок 102. 00:10:29
    Index Types
  103. Урок 103. 00:10:29
    Index Algorithms
  104. Урок 104. 00:08:19
    What Are Subqueries?
  105. Урок 105. 00:08:48
    Subqueries vs Joins
  106. Урок 106. 00:11:18
    Subquery Guidelines As Types
  107. Урок 107. 00:11:27
    Using Subqueries
  108. Урок 108. 00:14:20
    Getting The Latest Salaries
  109. Урок 109. 00:09:01
    Subquery Operators
  110. Урок 110. 00:09:57
    Time To Create Some Stuff!
  111. Урок 111. 00:04:18
    Types Of Databases In A RDBMS
  112. Урок 112. 00:07:39
    Default PostgreSQL Database
  113. Урок 113. 00:06:42
    Template Databases
  114. Урок 114. 00:04:42
    Creating A Database
  115. Урок 115. 00:07:09
    Database Organization
  116. Урок 116. 00:03:46
    Roles In Postgres
  117. Урок 117. 00:04:53
    Role Attributes And Creation
  118. Урок 118. 00:13:45
    Creating Users And Configuring Login
  119. Урок 119. 00:03:52
    Privileges
  120. Урок 120. 00:06:24
    Granting Privileges and Role Management
  121. Урок 121. 00:04:23
    Best Practices For Role Management
  122. Урок 122. 00:07:37
    Data Types & Boolean Type
  123. Урок 123. 00:05:20
    Storing Text
  124. Урок 124. 00:07:17
    Storing Numbers
  125. Урок 125. 00:04:21
    Storing Arrays
  126. Урок 126. 00:10:55
    Data Models And Naming Conventions
  127. Урок 127. 00:08:56
    CREATE TABLE
  128. Урок 128. 00:05:50
    Column Constraints
  129. Урок 129. 00:11:43
    Table Constraints
  130. Урок 130. 00:05:48
    UUID Explained
  131. Урок 131. 00:06:08
    Custom Data Types And Domains
  132. Урок 132. 00:11:53
    Creating The Tables For ZTM
  133. Урок 133. 00:08:08
    Adding Students And Teachers
  134. Урок 134. 00:12:32
    Creating A Course
  135. Урок 135. 00:06:50
    Adding Feedback To A Course
  136. Урок 136. 00:09:04
    A Tale Of 2 Feedbacks
  137. Урок 137. 00:23:20
    Backups And Why They Are Important
  138. Урок 138. 00:07:43
    Backing Up In Postgres
  139. Урок 139. 00:06:16
    Restoring A Database
  140. Урок 140. 00:18:16
    Transactions
  141. Урок 141. 00:01:46
    Clue #1 and #2
  142. Урок 142. 00:00:48
    Clue #3
  143. Урок 143. 00:05:26
    Solution: Solving The First Clues
  144. Урок 144. 00:00:28
    Clue #4
  145. Урок 145. 00:01:03
    Solution: Clue #4
  146. Урок 146. 00:01:14
    Clue #5 and #6
  147. Урок 147. 00:05:47
    Solution: Clue #5 and #6
  148. Урок 148. 00:02:53
    Solving The Mystery
  149. Урок 149. 00:09:50
    System Design And SDLC
  150. Урок 150. 00:06:01
    SDLC Phases
  151. Урок 151. 00:05:58
    System Design Deep Dive
  152. Урок 152. 00:06:29
    Top-Down vs Bottom-Up
  153. Урок 153. 00:06:42
    DRIVEME Academy
  154. Урок 154. 00:04:42
    Top Down Design
  155. Урок 155. 00:05:11
    ER Model
  156. Урок 156. 00:03:35
    Step 1: Determining Entities
  157. Урок 157. 00:03:29
    Tooling For Diagramming
  158. Урок 158. 00:13:55
    DRIVEME Academy Entities
  159. Урок 159. 00:03:05
    Step 2: Attributes
  160. Урок 160. 00:01:10
    Relational Model Extended
  161. Урок 161. 00:02:38
    Relational Schema And Instance
  162. Урок 162. 00:06:23
    Super Key and Candidate Key
  163. Урок 163. 00:07:34
    Primary Key and Foreign Key
  164. Урок 164. 00:04:08
    Compound Composite And Surrogate Key
  165. Урок 165. 00:11:57
    DRIVEME Attributes
  166. Урок 166. 00:12:06
    Step 3: Relationships
  167. Урок 167. 00:12:30
    DRIVEME Relationships
  168. Урок 168. 00:09:28
    Step 4: Solving Many To Many
  169. Урок 169. 00:02:45
    Step 5: Subject Areas
  170. Урок 170. 00:02:56
    DRIVEME Subject Areas
  171. Урок 171. 00:09:18
    Exercise: Painting Reservations
  172. Урок 172. 00:05:07
    Exercise: Movie Theatre
  173. Урок 173. 00:05:18
    Bottom Up Design
  174. Урок 174. 00:10:30
    Anomalies
  175. Урок 175. 00:07:15
    Normalization
  176. Урок 176. 00:06:36
    Functional Dependencies
  177. Урок 177. 00:06:12
    Functional Dependencies 2
  178. Урок 178. 00:04:33
    The Normal Forms
  179. Урок 179. 00:08:10
    Going from 0NF to 1NF
  180. Урок 180. 00:05:48
    Going from 1NF to 2NF
  181. Урок 181. 00:08:31
    Going from 2NF to 3NF
  182. Урок 182. 00:09:02
    Boyce-Codd Normal Form
  183. Урок 183. 00:05:58
    Why 4NF And 5NF Are Not Useful
  184. Урок 184. 00:01:37
    Bruno's Request
  185. Урок 185. 00:04:20
    Scalability
  186. Урок 186. 00:03:05
    Sharding
  187. Урок 187. 00:04:57
    Replication
  188. Урок 188. 00:02:16
    Backups
  189. Урок 189. 00:03:42
    Distributed vs Centralized Databases
  190. Урок 190. 00:04:03
    Database Security
  191. Урок 191. 00:19:43
    Optional: All About Injections Attacks
  192. Урок 192. 00:10:55
    Optional: Storing Passwords
  193. Урок 193. 00:10:36
    Relational vs NoSQL, PostgreSQL vs MongoDB Databases
  194. Урок 194. 00:01:48
    Future Of Relational Databases
  195. Урок 195. 00:03:49
    Elasticsearch
  196. Урок 196. 00:01:49
    S3 Object Storage
  197. Урок 197. 00:04:43
    Top Databases To Use
  198. Урок 198. 00:01:15
    Thank You
  199. Урок 199. 00:02:32
    Big Data + Analytics
  200. Урок 200. 00:06:04
    Reviewing How We Got Here
  201. Урок 201. 00:03:24
    Data Engineering Introduction
  202. Урок 202. 00:06:43
    What Is Data?
  203. Урок 203. 00:04:21
    What Is A Data Engineer?
  204. Урок 204. 00:05:36
    What Is A Data Engineer 2?
  205. Урок 205. 00:05:04
    What Is A Data Engineer 3?
  206. Урок 206. 00:03:23
    What Is A Data Engineer 4?
  207. Урок 207. 00:06:51
    Types Of Databases
  208. Урок 208. 00:04:23
    Hadoop, HDFS and MapReduce
  209. Урок 209. 00:02:08
    Apache Spark and Apache Flink
  210. Урок 210. 00:04:34
    Kafka and Stream Processing
  211. Урок 211. 00:06:58
    What Is Caching?
  212. Урок 212. 00:06:32
    Introducing Redis
  213. Урок 213. 00:04:48
    Installing Redis
  214. Урок 214. 00:05:58
    Redis Commands
  215. Урок 215. 00:02:00
    Redis Data Types
  216. Урок 216. 00:02:01
    Redis Hashes
  217. Урок 217. 00:03:56
    Redis Lists
  218. Урок 218. 00:06:12
    Redis Sets and Sorted Sets
  219. Урок 219. 00:03:01
    Section Summary
  220. Урок 220. 00:08:52
    Setting Up Your Database
  221. Урок 221. 00:07:07
    Connecting To The Database
  222. Урок 222. 00:04:51
    Registering A User Part 1