Relational DBMS Course – Concepts, Design & Querying

Post Content

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 Introduction to the Relational DBMS Course
– 00:06:02 Data vs. Information
– 00:08:40 What is a Database?
– 00:09:51 What is DBMS (Database Management System)?
– 00:10:25 DBMS vs. File Systems: Advantages of DBMS
– 00:27:26 Levels of Data: Real-world, Metadata, Occurrences
– 00:39:37 DBMS Three-Schema Architecture (Physical, Conceptual, View Levels)
– 01:00:51 Database Schema and Instance
– 01:01:44 DBMS Tier Architectures: 1-Tier, 2-Tier, 3-Tier
– 01:03:52 Data Dictionary & Data Models Introduction
– 01:08:18 Entity-Relationship (ER) Model Introduction
– 01:11:05 Entities: Types, Sets, Instances
– 01:12:50 Strong vs. Weak Entity Types
– 01:15:43 Attributes in ER Model (Simple, Composite, Single/Multi-valued, Derived, Stored, Descriptive)
– 01:19:49 Keys in ER Model: Super, Candidate, Primary, Foreign
– 01:31:50 Relationships in ER Model & Cardinality (1:1, 1:M, M:N)
– 01:36:29 Participation Constraints: Total and Partial
– 01:39:52 Strong vs. Weak Entity Types in Relationships (Identifying Relationship)
– 01:57:50 Extended ER Model: Generalization, Specialization
– 02:05:52 Constraints on Generalization/Specialization (Membership, Disjointness, Completeness)
– 02:28:20 Aggregation in ER Model
– 02:39:37 Formulating ER Diagrams: Examples (Banking System, Social Media Platform)
– 02:56:47 Relational Model: Introduction
– 03:01:20 Properties of Relations
– 03:04:40 Mapping ER Model to Relational Model: Entities & Attributes (Simple, Composite, Multivalued)
– 03:11:52 Surrogate Keys
– 03:15:20 Mapping Relationships to Tables: One-to-Many
– 03:22:20 Mapping Relationships: One-to-One
– 03:27:47 Mapping Relationships: Many-to-Many
– 03:44:24 Mapping Unary Relationships
– 03:50:52 Mapping Generalization/Specialization & Aggregation to Tables
– 03:58:04 Relational Algebra: Introduction (Procedural vs. Non-procedural)
– 04:01:04 Relational Algebra: Selection Operator (σ)
– 04:07:00 Relational Algebra: Projection Operator (π)
– 04:10:40 Relational Algebra: Union Operator (∪)
– 04:20:20 Relational Algebra: Set Difference (-) & Intersection (∩)
– 04:29:20 Relational Algebra: Cartesian Product (X) & Basic Joins
– 05:01:08 Relational Algebra: Division Operator (÷)
– 05:06:32 Relational Algebra: Theta, Equi, Natural Joins
– 05:17:20 Relational Algebra: Outer Joins – Left, Right, Full
– 05:20:40 Relational Algebra: Division Operator (÷) Examples with “All”
– 05:30:24 Handling NULLs in Relational Algebra
– 05:34:32 Relational Algebra: Database Modification – Insert, Delete, Update
– 05:46:08 SQL: Introduction and History
– 05:49:36 SQL: Basic SELECT, FROM, WHERE (Syntax, DISTINCT, ALL)
– 05:54:04 SQL: Pattern Matching with LIKE (%, _, ESCAPE)
– 06:02:24 SQL: Set Operations – UNION, INTERSECT, EXCEPT/MINUS (and UNION ALL etc.)
– 06:06:56 SQL: Subqueries with IN, SOME/ANY, ALL
– 06:23:04 SQL: EXISTS, NOT EXISTS, UNIQUE with subqueries
– 06:43:04 SQL: ORDER BY Clause
– 06:49:20 SQL: Aggregate Functions – MIN, MAX, AVG, SUM, COUNT
– 07:00:32 SQL: GROUP BY Clause
– 07:10:00 SQL: HAVING Clause
– 07:25:36 SQL: Handling NULLs – Comparisons, Aggregates, IS NULL
– 07:37:12 SQL: Nested Queries, WITH Clause
– 07:43:36 SQL: Joins – Inner Join (ON, NATURAL, USING)
– 07:52:20 SQL: Outer Joins – LEFT, RIGHT, FULL (Natural and ON predicate)
– 08:05:28 SQL: Data Modification – INSERT, DELETE, UPDATE
– 08:16:39 SQL: Views (CREATE VIEW, Updatable/Read-Only, WITH CHECK OPTION)
– 08:31:04 SQL: DDL – TRUNCATE, DROP, CREATE TABLE, Data Types, Constraints
– 08:49:40 SQL: Foreign Key Constraints & Referential Integrity (ON DELETE/UPDATE CASCADE)
– 08:56:36 SQL: ALTER TABLE Command (ADD, MODIFY, DROP COLUMN, RESTRICT, CASCADE)
– 09:03:00 SQL: DCL – GRANT and REVOKE

Thanks to our Champion and Sponsor supporters:
Drake Milly
Ulises Moralez
Goddard Tan
David MG
Matthew Springman
Claudio
Oscar R.
jedi-or-sith
Nattira Maneerat
Justin Hual