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