Relational Databases

Name: Relational Databases
Price: 9 USD
Availability: InStock

13h 15m 17s

English

Paid

June 4, 2025

Modern business processes depend on data, and most companies use complex database management systems (DBMS) for storing and processing it. The development of database technologies and competitive pressure have led to the creation of powerful and complex systems, the use of which requires deep understanding. Errors in working with such systems can be costly. This course provides fundamental knowledge about the operation of DBMS, allowing for informed decision-making in the design and use of relational databases.

Read more about the course

During the course exercises, you will create a simple relational database management system. The exercises are designed to allow you to solve tasks independently, referring to video guides and additional explanations only when necessary. Instead of a rigid definition of exercise completion, you are provided with flexibility: you can focus on core tasks and interesting additional goals. The course also includes seminars recorded with participants from CS Primer, which cover complex conceptual aspects that are difficult to understand in an exercise format. It is recommended to attend the seminars after studying the corresponding course module.

Watch Online Relational Databases

Join premium to watch

Go to premium

#	Title	Duration
1	001 Basic query executor	58:27
2	002 A brief overview of query execution using EXPLAIN	42:43
3	003 Observing PostgreSQL client and server communication	12:27
4	004 A very brief history of early DBMSs	22:19
5	005 Column vs row stores	08:43
6	006 What is the core of a core dump or out of core sort	04:51
7	007 CSV FileScan	01:03:36
8	008 Heap File	02:06:34
9	009 Basic inserts	01:01:10
10	010 The layout of a PostgreSQL table	35:22
11	011 Nested loops join	01:00:55
12	012 Hash join	40:18
13	013 Sort-merge join	01:38:55
14	014 Aggregation	58:22
15	015 What is a join	20:50
16	016 The three basic join stratgies	18:54
17	017 Nested loop variants and practical considerations	15:25
18	018 Hash join variants and practical considerations	14:58
19	019 Transactions the big picture	30:28