Relational DBMS Course – Database Concepts, Design & Querying Tutorial

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:48 Descriptive Attributes and Unary Relationships
03:56:06 Generalization, Specialization, and Aggregation
05:14:40 Introduction to Intersection Operator as a Derived Operator
05:15:09 Example - Finding Students Who Issued Both Books and Stationery
05:16:33 Introduction to Joins
05:16:37 Theta Join and Equi-Join
05:17:56 Natural Join
05:22:35 Revisiting Inner Joins and Moving to Outer Joins
05:35:30 Outer Joins - Left, Right, and Full Outer Join
05:40:45 Final Problem on Joins and Introduction to Division Operator
05:42:13 Division Operator Details and Examples
05:51:26 Handling "All" in Queries with Division Operator
05:56:00 Null Values in Relational Algebra
06:10:44 Database Modification (Insertion, Deletion, Update)
06:16:09 Minimum and Maximum Tuples in Joins
06:23:54 Introduction to Relational Calculus
06:26:28 Tuple Relational Calculus
06:58:48 Domain Relational Calculus
07:02:40 Introduction to SQL
07:59:17 Sorting in SQL
08:02:46 Aggregate Functions in SQL
08:08:21 Grouping Data with GROUP BY
08:21:24 Handling NULL Values in SQL
08:31:16 Pattern Matching in SQL
08:34:06 Set Operations and Duplicates
08:35:01 Handling Empty Queries
08:36:23 Complex Queries and WITH Clause
08:39:10 Joins in SQL
08:45:55 Data Modification Commands
08:48:09 Views in SQL
08:52:58 Constraints and Schema Modification

🎉 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

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news