The brainiest courses
for IT brainiacs.

The brainiest courses
for IT brainiacs.

Using DuckDB for Data Analytics

Course description

DuckDB is a Relational Database Management System (RDBMS) that supports the Structured Query Language (SQL). It is designed to support Online Analytical Processing(OLAP), and it is well suited for performing data analytics.

Unliketraditional database systems where you need to install them, DuckDB requires no installation and works in-process. Because on this, DuckDB can run queries directly on Pandas data without needing to import or copy any data. Moreover, DuckDB uses vectorized data processing which makes it very efficient – internally the data are stored in columnar format rather than row-format (which is commonly used by databases systems such as MySQL and SQLite).In this workshop, you will learn how to use DuckDB to perform data analytics.

Topics:

  • Use cases for DuckDB
  • Creating a DuckDB database
    – Creating tables
    – Inserting Values
    – Updating Values
    – Deleting Values
    – Retrieving Values
  • Working with Pandas DataFrames
    – Importing CSV files
    – Registering Dataframes
    – Joining dataframes
  • Using Relations
    – Setting alias
    – Filtering
    – Projection
    – Aggregation
    – Joining relations
  • Using Tad – Tabular Data Viewer
    – Installing Tad
    – Viewing CSV files using Tad

Prerequisites

  • Basic programming experience
  • Familiarity with Python recommended

Hardware

  • Mac / Windows laptop

Software

  • Anaconda
2024
30
OCT

Course details

Time: 9:00 – 17:00 (GMT +2:00)
Duration: 1 day
Trainer:

Course price

Early bird price: 349 Eur + VAT
Standard price: 399 Eur + VAT (changes 2 weeks before)

Contact us

Get in touch to find out more about this course