Course overview
Advanced CSV and SQL profiling techniques using DuckDB and Codex. Includes CSV ingestion, automated data quality assertions, Codex-assisted SQL profiling, and reading/optimizing EXPLAIN plans to strengthen BI analytics.
Covers CSV ingestion with DuckDB and SQL to prepare analytic datasets, including test data examples and BI use cases.
Explains setting up automated data quality assertions: framework overview and a hands-on build of quality tests.
Demonstrates Codex-assisted SQL profiling: advanced profiling patterns and practical exercises to deepen data insights.
Addresses reading EXPLAIN plans and query optimization, paired with a lab for profiling and quality assessment.
Skills and topics covered
Access the platform
Open the catalogue to review course details, access conditions, and your personal progress. Sign in.