DuckDB Tutorial - DuckDB course for beginners Discover the power of DuckDB and why it will be so important to you! Materials: Connect with me on LinkedIn 👇 TABLE OF CONTENT 0:00 Introduction 0:32 Who am I 0:53 Why DuckDB? 1:52 What is DuckDB? 4:34 What are the limits of DuckDB 5:35 Practice time 5:41 The setup 7:22 Install DuckDB and Imports 8:11 Create a DuckDB connection 9:10 Print the top 10 rows with Pandas 10:37 Print the top 10 rows with DuckDB 11:15 Retrieving data from a request 12:13 Use read_csv to load CSVs 13:03 Using DESCRIBE 13:15 Registering a Dataframe as a Table 14:15 Counting rows with DuckDB 14:18 Data cleansing 14:52 Querying Pandas Dataframes with DuckDB 15:55 Filtering on columns 16:46 What's a view? 17:06 Creating a table with types that skips invalid rows 18:40 The First-Form clause 19:07 Excluding columns with DuckDB 19:40 The Column Expression 21:52 Create a View 22:34 GROUP BY ALL 22:48 Querying the View 23:05 Revenue by City 23:24 Writing Parquet files with DuckDB 24:05 Querying Parquet files with DuckDB 24:35 DuckDB with S3 25:08 DuckDB Extensions 25:15 Conclusion