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…
Watch on YouTube ↗
(saves to browser)
Chapters (29)
Course Introduction and Overview
6:02
Data vs. Information
15:00
Databases and DBMS
30:00
File System vs. DBMS
50:00
DBMS Architecture and Abstraction
1:00:00
Three-Level Data Abstraction
1:20:00
Database Environment and Roles
1:30:00
DBMS Architectures (Tiered)
2:33:31
Introduction to User Posts and Attributes
2:33:54
Post Comments and Likes
2:34:16
Establishing Relationships and Cardinality
2:35:28
Creating an ER Diagram for a Social Media Application
2:36:49
ER Model vs. Relational Model
2:37:40
Relational Model Overview
2:38:52
Understanding Relations and Cartesian Product
2:41:54
Basic Terms and Properties of Relations
2:47:00
Completeness of Relational Model
2:49:01
Converting ER Model to Relational Model
2:56:58
Relationships in ER to Relational Conversion
3:42:48
Descriptive Attributes and Unary Relationships
3:56:06
Generalization, Specialization, and Aggregation
5:14:40
Introduction to Intersection Operator as a Derived Operator
5:15:09
Example - Finding Students Who Issued Both Books and Stationery
5:16:33
Introduction to Joins
5:16:37
Theta Join and Equi-Join
5:17:56
Natural Join
5:22:35
Revisiting Inner Joins and Moving to Outer Joins
5:35:30
Outer Joins - Left, Right, and Full Outer Join
5:40:45
Final Problem on Joins and Introduction
Playlist
Uploads from freeCodeCamp.org · freeCodeCamp.org · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Deploy 12 apps to AWS, Azure, & Google Cloud
freeCodeCamp.org
Reinforcement Learning Course: Intro to Advanced Actor Critic Methods
freeCodeCamp.org
How does the internet work? (Full Course)
freeCodeCamp.org
Code a Dictionary with React and Material UI - Tutorial
freeCodeCamp.org
Graph Algorithms for Technical Interviews - Full Course
freeCodeCamp.org
HTML Tutorial - Website Crash Course for Beginners
freeCodeCamp.org
Google Cloud Digital Leader Certification Course - Pass the Exam!
freeCodeCamp.org
Advanced OpenGL - Crash Course
freeCodeCamp.org
FastAPI Course for Beginners
freeCodeCamp.org
Google Sheets - Full Course
freeCodeCamp.org
Python Django and Google APIs - Project Tutorial
freeCodeCamp.org
Java Native Interface (28-Hour Course)
freeCodeCamp.org
Learn How to Code - Programming for Beginners Tutorial with Python and C#
freeCodeCamp.org
Android Programming Course - Kotlin, Jetpack Compose UI, Graph Data Structures & Algorithms
freeCodeCamp.org
Code a Discord Chat Bot That Talks Like Your Favorite Character - Tutorial
freeCodeCamp.org
Machine Learning Course for Beginners
freeCodeCamp.org
Selenium Course for Beginners - Web Scraping Bots, Browser Automation, Testing (Tutorial)
freeCodeCamp.org
Figma Course - Web Design Tutorial for Beginners
freeCodeCamp.org
Vue.js Course for Beginners
freeCodeCamp.org
Data Structures and Algorithms in Python - Full Course for Beginners
freeCodeCamp.org
Solidity, Blockchain, and Smart Contract Course – Beginner to Expert Python Tutorial
freeCodeCamp.org
Linux Essentials for Ethical Hackers - Full InfoSec Course
freeCodeCamp.org
Gatsby Static Site Generator Tutorial
freeCodeCamp.org
Django For Everybody - Full Python University Course
freeCodeCamp.org
Python Automation Tutorial – How to Automate Tasks for Beginners [Full Course]
freeCodeCamp.org
R Shiny for Data Science Tutorial – Build Interactive Data-Driven Web Apps
freeCodeCamp.org
Natural Language Processing with spaCy & Python - Course for Beginners
freeCodeCamp.org
HTML & CSS Project Tutorial - Build a Recipes Website
freeCodeCamp.org
Git for Professionals Tutorial - Tools & Concepts for Mastering Version Control with Git
freeCodeCamp.org
TensorFlow for Computer Vision Course - Full Python Tutorial for Beginners
freeCodeCamp.org
HashiCorp Terraform Associate Certification Course - Pass the Exam!
freeCodeCamp.org
AWS VPC Beginner to Pro - Virtual Private Cloud Tutorial
freeCodeCamp.org
Object Oriented Programming with Python - Full Course for Beginners
freeCodeCamp.org
Node.js / Express Course - Build 4 Projects
freeCodeCamp.org
Binary Tree Algorithms for Technical Interviews - Full Course
freeCodeCamp.org
TensorFlow Lite for Edge Devices - Tutorial
freeCodeCamp.org
Angular Tutorial for Beginners - Web Framework with Typescript Course
freeCodeCamp.org
Unreal Engine & C++ Tutorial - Endless Runner Game 🏃🏽♀️
freeCodeCamp.org
Android App Development Tutorial for Beginners - Your First App
freeCodeCamp.org
Django Tutorial - Create a Digital Resume with a Python Backend
freeCodeCamp.org
Learn React by Building an eCommerce Site - Tutorial
freeCodeCamp.org
JavaScript Tutorial - PuzzleCam Game
freeCodeCamp.org
Python API Development - Comprehensive Course for Beginners
freeCodeCamp.org
The 50 Most Popular Linux & Terminal Commands - Full Course for Beginners
freeCodeCamp.org
Web Applications for Everybody Course - Dr. Chuck Teaches HTML, PHP, SQL, CSS, JavaScript, and more!
freeCodeCamp.org
Code a Squid Game JavaScript Game Using Three.js - Tutorial for Beginners
freeCodeCamp.org
Micro-Frontends Course - Beginner to Expert
freeCodeCamp.org
Unreal Engine & C++ Tutorial - 1st Person Shooter Game
freeCodeCamp.org
C++ Programming Tutorial - Build a 3-Band Compressor Audio Plugin (w/ JUCE Framework)
freeCodeCamp.org
Infrastructure as Code - Crash Course
freeCodeCamp.org
AWS Certified Cloud Practitioner Certification Course (CLF-C01) - Pass the Exam!
freeCodeCamp.org
Advanced Git Tutorial - Interactive Rebase, Cherry-Picking, Reflog, Submodules and more
freeCodeCamp.org
Learn ASP.NET Core MVC (.NET 6) - Full Course
freeCodeCamp.org
Feature Toggles - Why and How to Add to Your Software
freeCodeCamp.org
Data Analysis with Python for Excel Users - Full Course
freeCodeCamp.org
NoSQL Database Tutorial – Full Course for Beginners
freeCodeCamp.org
Rust Programming Course for Beginners - Tutorial
freeCodeCamp.org
Razor Pages for ASP.NET Core - Full Course (.NET 6)
freeCodeCamp.org
The Business of Building Apps - App Product Management Course for Developers
freeCodeCamp.org
Bootstrap CSS Framework - Full Course for Beginners
freeCodeCamp.org
DeepCamp AI