From the course: Fundamentals of Data Transformation for Data Engineering
Unlock the full course today
Join today to access over 24,100 courses taught by industry experts.
DuckDB basics and query structure - SQL Tutorial
From the course: Fundamentals of Data Transformation for Data Engineering
DuckDB basics and query structure
- [Instructor] In our first lesson, we'll be learning data transformation in SQL with DuckDB. And this will be pretty straightforward, this video. We'll just be walking through how to run SQL in each cell, we'll be talking about how our SQL exercises work, we'll talk about how to tinker in this framework, and we'll also give an introduction to the first lesson and get started. So we can jump right into it. And once we're in our code space, we need only open the SQL folder and navigate to the Lessons directory to see a list of the lessons that we'll be interacting with. So clicking into the first lesson, DuckDB Basics, is pretty straightforward and all we need to do is run the first cell. And that's going to prompt us to choose an environment in our code space. So we'll select the only environment that exists and all of the necessary libraries should be loaded and we're ready to start running the cells in our course. So running the first cell should display this message when it…
Contents
-
-
-
-
(Locked)
DuckDB basics and query structure4m 2s
-
(Locked)
Wrangling unstructured data10m 30s
-
(Locked)
Joins and comparisons10m 19s
-
(Locked)
Aggregations10m 16s
-
(Locked)
Windows functions: A quick refresher5m 41s
-
(Locked)
Window functions10m 15s
-
(Locked)
Advanced filters3m 9s
-
(Locked)
Advanced joins8m 12s
-
(Locked)
Lambdas and UDFs10m 3s
-
(Locked)
Data generation4m 52s
-
(Locked)
SQL challenge2m 37s
-
(Locked)
SQL solution13m 8s
-
(Locked)
-
-