Introduction to DuckDB SQL

Mehdi, a data engineer and developer advocate, introduces you to DuckDB SQL. You'll learn about the use cases, the changes to SQL syntax to make data analysis easier (no more SELECT *!), and how to include DuckDB in your analytics workflow.

Oct 8, 2024

Code along with us onCode Along

View slides

SQL is more than 50 years old, but the language is still evolving, and DuckDB is one of the most innovative databases for analytics. It's an important tool for any data analyst, data scientist, or data engineer. It's also used in DataCamp DataLab for working with CSV files (a key task in our Data Analyst, Data Scientist, and Data Engineer professional certifications).

In this session, Mehdi, a data engineer and developer advocate, introduces you to DuckDB SQL. You'll learn about the use cases, the changes to SQL syntax to make data analysis easier (no more SELECT *!), and how to include DuckDB in your analytics workflow.

Key Takeaways:

Learn what tasks DuckDB can be used for.
Learn how DuckDB extensions to SQL can help with data analysis.
Learn how to incorporate DuckDB into your analytics workflow.

Topics

blog

DuckDB makes SQL a first-class citizen on DataLab

In this blog post, we list out all recent improvements that make it seamless and efficient to query data with SQL, all without leaving the tool.

Filip Schouwenaars

blog

An Introduction to DuckDB: What is It and Why Should You Use It?

Explore DuckDB, the fast, easy-to-use analytics database for Python and R. Learn its key features, use cases, and how it optimizes data analysis tasks.

Kurtis Pykes

7 min

Tutorial

DuckDB Tutorial: Building AI Projects

This tutorial guides you through DuckDB's key features and practical applications, including building tables, performing data analysis, building an RAG application, and using an SQL query engine with LLM.

Abid Ali Awan

Tutorial

DuckDB for Data Engineers: Speed Up Your Data Pipelines 10x and More

DuckDB is a powerful analytical engine that lives on your laptop. You can use it to speed up data reading and processing and reduce your pipeline runtimes from minutes to seconds. Follow this hands-on guide to learn how.

Dario Radečić

code-along

Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.

Jasmin Ludolf

code-along

A Beginner's Guide to Data Analysis with SQL

In this session, DataCamp's VP of Media Adel Nehme & co-host of the DataFramed podcast, shows you how to get started with SQL.

Adel Nehme

See More See More