Completed
Primary Key and Foreign Key Constraints in SQL
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)
