Description
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: 19
Duration: 13 hours and 15 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
- The layout of a PostgreSQL table
- 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
- Transactions the big picture
Relational Databases Prerequisites
None
Pictures
Relational Databases introduction video
Installation guide
After Extract, watch with your favorite Player.
Subtitle: None
Quality: 2160p
Changes:
Version 2025/5 compared to 2025/1 has increased by 2 lessons and 1 hours and 5 minutes in duration.
Download link
Downloadly
Rapidgator
Password file(s): www.downloadly.ir
Size
5.72 GB
