Relational DBMS Course – Database Concepts, Design & Querying Tutorial

From the creator

This relational Database Management System (DBMS) course serves as a comprehensive resource for mastering database concepts, design, and querying, and is tailored for both academic success and technical interviews. You will explore essential topics such as ER modeling, relational algebra, SQL, normalization, and transaction management, progressing from foundational principles to advanced applications. Course resources: https://rdbms-resource-pack-650qinf.gamma.site/ ✏️ Course created by Kshitij Sharma. ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp ⭐️ Contents ⭐️ 00:00:00 Course Introduction and Overview 00:06:02 Data vs. Information 00:15:00 Databases and DBMS 00:30:00 File System vs. DBMS 00:50:00 DBMS Architecture and Abstraction 01:00:00 Three-Level Data Abstraction 01:20:00 Database Environment and Roles 01:30:00 DBMS Architectures (Tiered) 02:33:31 Introduction to User Posts and Attributes 02:33:54 Post Comments and Likes 02:34:16 Establishing Relationships and Cardinality 02:35:28 Creating an ER Diagram for a Social Media Application 02:36:49 ER Model vs. Relational Model 02:37:40 Relational Model Overview 02:38:52 Understanding Relations and Cartesian Product 02:41:54 Basic Terms and Properties of Relations 02:47:00 Completeness of Relational Model 02:49:01 Converting ER Model to Relational Model 02:56:58 Relationships in ER to Relational Conversion 03:42

Published 2025-05-21 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.