Главная
Study mode:
on
1
Introduction
2
What is SQL
3
History of SQL
4
SQL Standard
5
Relational Language
6
Overview
7
Example Database
8
Aggregate Functions
9
Aggregate Example
10
Aggregate Limitations
11
Group By Clauses
12
Group By Clause Example
13
Group By Clause Summary
14
Group By Clause Demonstration
15
Having Clause Demonstration
16
String Operations
17
Constants
18
String Matching
19
String Functions
20
Concatenation
21
Date Time
22
Postgres
23
SQL Shortcut
24
Sliding Calculations
Description:
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it 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.

Modern SQL - Lecture 2

CMU Database Group
Add to list
0:00 / 0:00