SQL analytics course with DuckDB - filtering data tutorial

In this video, we delve into advanced SQL filtering techniques using DuckDB with a dataset of data engineering salaries from Kaggle. We'll guide you through downloading the dataset, setting it up in Visual Studio Code, and writing SQL commands to filter data effectively. Learn how to use logical operators, the 'CASE WHEN' statement, aggregate functions, and various filtering methods. By the end of this tutorial, you'll have a solid understanding of handling and analyzing data using DuckDB. Perfect for anyone looking to enhance their SQL skills! Don't forget to commit and push your changes to GitHub.

Github repo
https://github.com/AIgineerAB/duckdb_sql_analytics_course/tree/main/05_filtering

#duckdb #sql

00:00 Introduction to Filtering with DuckDB SQL
00:37 Downloading and Setting Up the Dataset
01:25 Ingesting Data into DuckDB
03:12 Basic SQL Queries and Filtering
07:10 Advanced Filtering Techniques
10:42 Using CASE WHEN Statements
17:49 Logical Operators in SQL
24:12 IN Operator and List Filtering
25:11 Calculating Percentages and Offset Filtering
28:33 Conclusion and Final Tips

Видео SQL analytics course with DuckDB - filtering data tutorial канала AIgineer