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