Completed
Three-Schema Architecture & Data Independence
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Database Management Systems
Automatically move to the next video in the Classroom when playback concludes
- 1 Introduction to Database Management Systems
- 2 DBMS Characteristics
- 3 Database Users
- 4 Advantages & Disadvantages of DBMS
- 5 History of Database Applications
- 6 Fundamentals of Database Systems
- 7 Three-Schema Architecture & Data Independence
- 8 DBMS Languages, Interfaces, and Classification
- 9 Database System Environment
- 10 DBMS Architecture
- 11 Basic Concepts of Entity-Relationship Model
- 12 Database Design Process
- 13 Concept of Relationships in ER Diagram
- 14 Exercises based on ER Model Concepts (Part 1)
- 15 Exercises based on ER Model Concepts (Part 2)
- 16 Introduction to Relational Data Model
- 17 Characteristics of Relations
- 18 Relational Model Constraints
- 19 Update Operations/Dealing with Constraint Violations
- 20 Exercises based on Relational Model (Part 1)
- 21 Exercises based on Relational Model (Part 2)
- 22 Relational Algebra Operations - Unary
- 23 Relational Algebra Operations - Set Theory
- 24 Relational Algebra Operations - Binary
- 25 Additional Relational Algebra Operations
- 26 Relational Algebra Queries (Part 1)
- 27 Relational Algebra Queries (Part 2)
- 28 Introduction to Structured Query Language (SQL)
- 29 Data Definition Language (DDL)
- 30 DDL Commands - CREATE
- 31 Constraints in SQL
- 32 Constraints in SQL (Example Queries)
- 33 Primary Key and Foreign Key Constraints in SQL
- 34 DDL Commands - ALTER
- 35 DDL Commands - TRUNCATE, DROP, and RENAME
- 36 DML Commands - INSERT and UPDATE
- 37 DML Commands - DELETE and SELECT
- 38 Data Control Language (DCL)
- 39 Transaction Control Language (TCL)
- 40 Aggregate Functions in SQL
- 41 GROUP BY and HAVING Clause in SQL
- 42 ORDER BY in SQL
- 43 LIKE in SQL
- 44 IN in SQL
- 45 BETWEEN in SQL
- 46 Alias (AS) in SQL
- 47 TOP, LIMIT, FETCH FIRST, and ROWNUM in SQL
- 48 NULL Functions in SQL
- 49 ANY and ALL Operators in SQL
- 50 CASE Expression in SQL
- 51 Comments in SQL
- 52 Joins in SQL
- 53 SQL - Solved Problem 1
- 54 SQL - Solved Problem 2
- 55 SQL - Solved Problem 3
- 56 SQL (Rapid Fire Quiz)
