Completed
Primary Key and Foreign Key Constraints in SQL
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Database Management Systems (DBMS)
Automatically move to the next video in the Classroom when playback concludes
- 1 Introduction to Database Management Systems (DBMS)
- 2 DBMS - Definition
- 3 Applications of DBMS
- 4 File System vs. Database Management System
- 5 Three Tier Architecture
- 6 View of Data
- 7 Instances and Schemas in DBMS
- 8 Database Users
- 9 Database Administrator (DBA)
- 10 Introduction to Data Models
- 11 Database System Architecture - Part 1
- 12 Database System Architecture - Part 2
- 13 History of DBMS
- 14 Database Languages and Software
- 15 Introduction to DBMS - Solved Questions
- 16 Introduction to Relational Databases
- 17 Codd’s 12 Rules (13 Rules)
- 18 Database Schema
- 19 Keys in RDBMS
- 20 Keys in RDBMS (Solved Questions)
- 21 Schema Diagrams
- 22 Relational Query Languages
- 23 Basics of Relational Algebra
- 24 Relational Algebra (Select Operation)
- 25 Relational Algebra (Project Operation)
- 26 Relational Algebra (Union Operation)
- 27 Relational Algebra (Set Difference Operation)
- 28 Relational Algebra (Cartesian Product Operation)
- 29 Relational Algebra (Rename Operation)
- 30 Relational Algebra (Set Intersection Operation)
- 31 Relational Algebra (Assignment Operation)
- 32 NULL Values in RDBMS
- 33 Relational Algebra (Natural Join Operation)
- 34 Relational Algebra (Division Operation)
- 35 Relational Algebra (Outer Join Operation)
- 36 Relational Algebra (Solved Problem 1)
- 37 Relational Algebra (Solved Problem 2)
- 38 Relational Algebra (Solved Problem 3)
- 39 Relational Algebra (Solved Problem 4)
- 40 Relational Algebra (Solved Problem 5)
- 41 Tuple Relational Calculus (Formal Definition)
- 42 Tuple Relational Calculus (Example Queries)
- 43 Domain Relational Calculus (Formal Definition)
- 44 Domain Relational Calculus (Example Queries)
- 45 Relational Algebra (Rapid Fire Quiz)
- 46 Database Design
- 47 Introduction to E-R Model (Part 1)
- 48 Introduction to E-R Model (Part 2)
- 49 Types of Attribute in DBMS
- 50 Mapping Cardinalities
- 51 Entity-Relationship (ER) Diagram
- 52 Mapping Cardinality in ER Diagram
- 53 Participation Constraints in DBMS
- 54 ER Diagram for University Database
- 55 ER Diagram for Banking Enterprise
- 56 ER Diagram for Hospital Management System
- 57 Extended ER Features
- 58 ER Model (Solved Problem 1)
- 59 ER Model (Solved Problem 2)
- 60 ER Model (Solved Problem 3)
- 61 ER Model (Rapid Fire Quiz)
- 62 Introduction to Structured Query Language (SQL)
- 63 Data Definition Language (DDL)
- 64 DDL Commands - CREATE
- 65 Constraints in SQL
- 66 Constraints in SQL (Example Queries)
- 67 Primary Key and Foreign Key Constraints in SQL
- 68 DDL Commands - ALTER
- 69 DDL Commands - TRUNCATE, DROP, and RENAME
- 70 DML Commands - INSERT and UPDATE
- 71 DML Commands - DELETE and SELECT
- 72 Data Control Language (DCL)
- 73 Transaction Control Language (TCL)
- 74 Aggregate Functions in SQL
- 75 GROUP BY and HAVING Clause in SQL
- 76 ORDER BY in SQL
- 77 LIKE in SQL
- 78 IN in SQL
- 79 BETWEEN in SQL
- 80 Alias (AS) in SQL
- 81 TOP, LIMIT, FETCH FIRST, and ROWNUM in SQL
- 82 NULL Functions in SQL
- 83 ANY and ALL Operators in SQL
- 84 CASE Expression in SQL
- 85 Comments in SQL
- 86 Joins in SQL
- 87 SQL - Solved Problem 1
- 88 SQL - Solved Problem 2
- 89 SQL - Solved Problem 3
- 90 SQL (Rapid Fire Quiz)
