Relational DBMS Course - Concepts, Design and Querying

00:00:00 Course Introduction and Overview
00:06:02 Data vs. Information
00:15:00 Databases and DBMS
00:30:00 File System vs. DBMS
00:50:00 DBMS Architecture and Abstraction
01:00:00 Three-Level Data Abstraction
01:20:00 Database Environment and Roles
01:30:00 DBMS Architectures Tiered
02:33:31 Introduction to User Posts and Attributes
02:33:54 Post Comments and Likes
02:34:16 Establishing Relationships and Cardinality
02:35:28 Creating an ER Diagram for a Social Media Application
02:36:49 ER Model vs. Relational Model
02:37:40 Relational Model Overview
02:38:52 Understanding Relations and Cartesian Product
02:41:54 Basic Terms and Properties of Relations
02:47:00 Completeness of Relational Model
02:49:01 Converting ER Model to Relational Model
02:56:58 Relationships in ER to Relational Conversion
03:42:48 Descriptive Attributes and Unary Relationships
03:56:06 Generalization, Specialization, and Aggregation
05:14:40 Introduction to Intersection Operator as a Derived Operator
05:15:09 Example - Finding Students Who Issued Both Books and Stationery
05:16:33 Introduction to Joins
05:16:37 Theta Join and Equi-Join
05:17:56 Natural Join
05:22:35 Revisiting Inner Joins and Moving to Outer Joins
05:35:30 Outer Joins - Left, Right, and Full Outer Join
05:40:45 Final Problem on Joins and Introduction to Division Operator
05:42:13 Division Operator Details and Examples
05:51:26 Handling "All" in Queries with Division Operator
05:56:00 Null Values in Relational Algebra
06:10:44 Database Modification Insertion, Deletion, Update
06:16:09 Minimum and Maximum Tuples in Joins
06:23:54 Introduction to Relational Calculus
06:26:28 Tuple Relational Calculus
06:58:48 Domain Relational Calculus
07:02:40 Introduction to SQL
07:59:17 Sorting in SQL
08:02:46 Aggregate Functions in SQL
08:08:21 Grouping Data with GROUP BY
08:21:24 Handling NULL Values in SQL
08:31:16 Pattern Matching in SQL
08:34:06 Set Operations and Duplicates
08:35:01 Handling Empty Queries
08:36:23 Complex Queries and WITH Clause
08:39:10 Joins in SQL
08:45:55 Data Modification Commands
08:48:09 Views in SQL
08:52:58 Constraints and Schema Modification