Completed
SQL - Solved Problem 2
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)
