English | MP4 | AVC 3840×2160 | AAC 44KHz 2ch | 17 Lessons (12h 9m) | 5.11 GB
Modern business processes depend on data, and most companies use complex database management systems (DBMS) for storing and processing it. Advances in database technologies and competitive pressures have led to the development of powerful and sophisticated systems that require a deep understanding to use effectively. Mistakes in working with such systems can be costly. This course provides foundational knowledge of DBMS operations, enabling informed decisions when designing and using relational databases.
During the course exercises, you will create a simple relational database management system. The exercises are designed so you can solve tasks independently, referring to video tutorials and additional explanations only when necessary. Instead of rigidly defining when an exercise is complete, you are given flexibility: you can focus on the core tasks and explore interesting additional objectives.
The course also includes workshops, recorded with participants from the CS Primer, which address complex conceptual aspects that are challenging to grasp through exercises alone. It is recommended to attend these workshops after studying the corresponding course module.
Table of Contents
1 Basic query executor
2 A brief overview of query execution using EXPLAIN
3 Observing PostgreSQL client and server communication
4 A very brief history of early DBMSs
5 Column vs row stores
6 What is the core of a core dump or out of core sort
7 CSV FileScan
8 Heap File
9 Basic inserts
10 Nested loops join
11 Hash join
12 Sort-merge join
13 Aggregation
14 What is a join
15 The three basic join stratgies
16 Nested loop variants and practical considerations
17 Hash join variants and practical considerations
HTML
18 A brief overview of query execution using EXPLAIN
19 A very brief history of early DBMSs
20 Aggregation
21 Basic inserts (1)
22 Basic inserts
23 Basic query executor (1)
24 Basic query executor
25 CSV FileScan (1)
26 CSV FileScan
27 Heap File (1)
28 Heap File
29 Nested loops join
30 Observing PostgreSQL client and server communication
31 Sort-merge join
32 The layout of a PostgreSQL table
Resolve the captcha to access the links!