Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

freeCodeCamp

Relational DBMS Course - Concepts, Design and Querying

via freeCodeCamp

Start learning Write review
Scrimba Ad

Our career paths help you become job ready faster

Learn More → Udacity Ad

Master AI & Data—50% Off Udacity (Code CC50)

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
This comprehensive 9-hour course on Relational Database Management Systems (RDBMS) provides a complete foundation for mastering database concepts, design, and querying techniques suitable for both academic studies and technical interview preparation. Master essential topics including the distinction between data and information, database fundamentals, DBMS architecture, ER modeling, relational algebra, SQL, normalization, and transaction management. Progress from basic principles to advanced applications through structured lessons covering database environment roles, tiered architectures, and practical implementation of database concepts. Learn to create ER diagrams for real-world applications like social media platforms, convert ER models to relational models, and implement various types of joins and operators. Develop proficiency in SQL with detailed instruction on sorting, aggregate functions, grouping data, handling NULL values, pattern matching, and complex queries. Created by Kshitij Sharma, the course includes comprehensive resources available through a dedicated website to support your learning journey.

Syllabus

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

Taught by

freeCodeCamp.org

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Relational DBMS Course - Concepts, Design and Querying

  • Profile image for Midhat
    Midhat @midhat
    6
    i really learn cool stuff like generalization, EDa, relational algebra, keys, and other stuff like data security, integrity, and how it used in commerce application, banking system
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.