Relational DBMS Course – Concepts, Design & Querying

This relational Database Management System (DBMS) people serves arsenic a broad assets for mastering database concepts, design, and querying, and is tailored for some world occurrence and method interviews. You will research basal topics specified arsenic ER modeling, relational algebra, SQL, normalization, and transaction management, progressing from foundational principles to precocious applications. Course resources: https://rdbms-resource-pack-650qinf.gamma.site/ ✏️ Course created by Kshitij Sharma. ❤️ Support for this transmission comes from our friends astatine Scrimba – the coding level 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 simply 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 successful ER Model (Simple, Composite, Single/Multi-valued, Derived, Stored, Descriptive) - 01:19:49 Keys successful ER Model: Super, Candidate, Primary, Foreign - 01:31:50 Relationships successful 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 successful Relationships (Identifying Relationship) - 01:57:50 Extended ER Model: Generalization, Specialization - 02:05:52 Constraints connected Generalization/Specialization (Membership, Disjointness, Completeness) - 02:28:20 Aggregation successful 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 pinch "All" - 05:30:24 Handling NULLs successful 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 pinch LIKE (%, _, ESCAPE) - 06:02:24 SQL: Set Operations - UNION, INTERSECT, EXCEPT/MINUS (and UNION ALL etc.) - 06:06:56 SQL: Subqueries pinch IN, SOME/ANY, ALL - 06:23:04 SQL: EXISTS, NOT EXISTS, UNIQUE pinch 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 -- Learn to codification for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles connected programming: https://freecodecamp.org/news