CS Primer – Relational Databases 2025-1

Relational Databases is a relational database management principles and practices course published by CS Primer Online Academy. This course dives deep into the principles and practices of relational database management, starting with core concepts such as tables, rows, and columns, and the importance of primary and foreign keys. Students will explore relational schema design and normalization techniques to ensure data consistency and minimize redundancy. Advanced topics include indexing to optimize performance, transaction management for data integrity, and security measures to protect sensitive information.

Most businesses store data, and most do so in a complex database system. Better database engines have led to increased business capabilities, so decades of market pressure have resulted in highly capable and sophisticated systems. By the end of the course, participants will have the skills to effectively design, query, and manage relational databases in a variety of real-world scenarios.

What you will learn in Relational Databases:

• Implement the most basic join algorithm you can think of
• Sort-merge joins two sorted tables in linear time
• Supports aggregation operations such as count, sum, and average
• Designs and implements a custom file format for storing data
• Basic inserts implement the first version of the insert operation
• And…

Course specifications

Publisher: CS Primer
Instructors: CS Primer
Language: English
Level: Introductory to Advanced
Number of Lessons: 17
Duration: 12 hours and 10 minutes

Course topics

• Basic query executor
• A brief overview of query execution using EXPLAIN
• Observing PostgreSQL client and server communication
• A very brief history of early DBMSs
• Column vs row stores
• What is the core of a core dump or out of core sort
• CSV FileScan
• Heap File
• Basic inserts
• Nested loops join
• Hash join
• Sort-merge join
• Aggregation
• What is a join
• The three basic join stratgies
• Nested loop variants and practical considerations
• Hash join variants and practical considerations

Relational Databases Prerequisites

None

Pictures

Relational Databases introduction video

Installation guide

After Extract, watch with your favorite Player.

Subtitle: None

Quality: 2160p

Download link

Download Part 1 – 2 GB

Download Part 2 – 2 GB

Download Part 3 – 935 MB

Size

4.9 GB