Skip to main content

Relational Databases

18h 30m 22s
English
Paid

Modern business processes depend heavily on data, with most companies relying on complex database management systems (DBMS) for efficient data storage and processing. The rapid development of database technologies, driven by competitive pressures, has resulted in the emergence of powerful and intricate systems. Understanding these systems deeply is essential as errors in their use can be costly. This course aims to provide you with the fundamental knowledge necessary to operate DBMS effectively, enabling you to make informed decisions when designing and utilizing relational databases.

Course Objectives

This course offers hands-on experience through practical exercises where you will craft a basic relational database management system. The exercises encourage independent problem-solving, allowing you to utilize video guides and additional explanations only when needed. The structure is flexible, permitting you to concentrate on essential tasks while exploring interesting additional objectives.

Hands-on Learning

Engage in practical sessions that emphasize real-world application of relational database management principles. These exercises are designed to boost your problem-solving skills and familiarize you with the creation and management of databases.

Flexible Learning Path

The course structure supports a self-paced approach, focusing on critical tasks while offering exploratory paths for advanced learners interested in delving deeper.

Seminars and Advanced Topics

The course includes recorded seminars featuring participants from CS Primer, which delve into complex conceptual topics that are challenging to grasp through exercises alone. It is advisable to attend these seminars after completing the relevant course module, as they provide a deeper understanding of advanced concepts.

In-Depth Seminar Topics

Topics in the seminars cover advanced relational database concepts and strategies. These sessions are valuable for solidifying your understanding and exploring sophisticated database approaches.

Optimal Seminar Timing

To maximize your learning, attend seminars after completing the modules they correlate with; this timing ensures that you have the necessary foundational knowledge to engage deeply with the content presented.

About the Author: Oz Nova (csprimer.com)

Oz Nova (csprimer.com) thumbnail
Hello, my name is Oz. I am a computer science instructor and a father who is homeschooling his children, living in rural Australia. Since 2015, I have been running Bradfield, a small professional school that was originally located in San Francisco and is now fully online. Starting in 2024, I am focusing my energy on csprimer.com - a flexible schedule computer science curriculum. Previously, I worked as a software engineer and CTO, including co-founding Vida Health.

Watch Online 22 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 22 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: 001 Basic query executor
All Course Lessons (22)
#Lesson TitleDurationAccess
1
001 Basic query executor Demo
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
20
020 B tree in memory
01:25:26
21
021 B tree on disk
03:04:07
22
022 What every programmer should know about B trees
45:32
Unlock unlimited learning

Get instant access to all 21 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription