Modern SQL with DuckDB
31 videos • 142 views • by AIgineer
In this course video series we'll go through SQL from the ground up using DuckDB.
1
Introduction to SQL and duckdb (theory)
AIgineer
Download
2
Course structure for modern SQL with DuckDB
AIgineer
Download
3
Course structure for modern SQL with DuckDB part 2 - github repository
AIgineer
Download
4
First navigation of DuckDB (theory)
AIgineer
Download
5
DuckDB CLI to ingest data from csv file
AIgineer
Download
6
Dbeaver navigation (theory)
AIgineer
Download
7
DBeaver connect with DuckDB with SQL introduction
AIgineer
Download
8
Querying data in DuckDB SQL (coding)
AIgineer
Download
9
Querying data in DuckDB with SELECT statements (theory)
AIgineer
Download
10
Filtering data using DuckDB (theory)
AIgineer
Download
11
FIltering data in DuckDB (coding)
AIgineer
Download
12
CRUD operations in DuckDB (theory)
AIgineer
Download
13
CRUD operations in DuckDB SQL
AIgineer
Download
14
Generating synthetic data using DuckDB (theory)
AIgineer
Download
15
Generating synthetic data using DuckDB SQL (coding)
AIgineer
Download
16
Working with string and regexp in DuckDB (theory)
AIgineer
Download
17
Working with strings in SQL and DuckDB (coding)
AIgineer
Download
18
Grouping data in DuckDB SQL (theory)
AIgineer
Download
19
Grouping data in DuckDB (coding)
AIgineer
Download
20
Set operations in DuckDB (theory)
AIgineer
Download
21
Set operations in DuckDB part 1
AIgineer
Download
22
Set operations in DuckDB part 2
AIgineer
Download
23
Joins in SQL DuckDB to combine rows between several tables (coding)
AIgineer
Download
24
Joins in SQL DuckDB to combine rows between several tables
AIgineer
Download
25
Commont table expressions (CTE) in DuckDB
AIgineer
Download
26
Common table expressions in DuckDB (coding)
AIgineer
Download
27
Connecting duckdb with Python part 1 (coding)
AIgineer
Download
28
Connecting duckdb with Python part 2 (coding)
AIgineer
Download
29
Connecting duckdb with Python part 3 (coding)
AIgineer
Download
30
Course repetition of SQL using DuckDB part 1
AIgineer
Download
31
Course repetition of SQL using DuckDB part2
AIgineer
Download