Explore modern SQL concepts in this comprehensive lecture from Carnegie Mellon University's Intro to Database Systems course. Delve into SQL's history, standards, and relational language fundamentals. Learn about aggregate functions, group by clauses, and their limitations through practical examples and demonstrations. Discover string operations, constants, matching techniques, and functions. Gain insights into date/time handling and PostgreSQL shortcuts. Enhance your database skills with sliding calculations and hands-on demonstrations led by Professor Andy Pavlo.
Overview
Syllabus
Introduction
What is SQL
History of SQL
SQL Standard
Relational Language
Overview
Example Database
Aggregate Functions
Aggregate Example
Aggregate Limitations
Group By Clauses
Group By Clause Example
Group By Clause Summary
Group By Clause Demonstration
Having Clause Demonstration
String Operations
Constants
String Matching
String Functions
Concatenation
Date Time
Postgres
SQL Shortcut
Sliding Calculations
Taught by
CMU Database Group
