Courses
Investigating with AI
Data analysis with AI - no technical background required
Relational Databases - PostgreSQL
A comprehensive course in intermediate databases and PostgreSQL
- Welcome
- Install
- S01 Wrap up
- Postgres Server Config Files
- Loading Dataset
- Keys, Types, Sequences
- Improve Trees
- Normalization
- Window Functions and CTEs Introduction
- Normalization Lab
- Normalization Solutions
- Windows Functions
- CTEs
- Window Functions CTEs Lab
- Query Performance Introduction
- Query Performance - Explain - Scans
- Database Indexes Introduction
- Bitmap Heap and Index Scans
- Energy Production Database
- Database Indexes Implementation
- Database Scan Algorithms Quiz
- Indexing Practice Lab
- Views and Functions Introduction
- PostgreSQL Views
- Views Exercise
- Views Exercise Solutions
- SQL Functions COALESCE and Strings
- SQL Functions Solutions
- PL/pgSQL Functions
- SHA256 Functions Worksheet
- Writing Scalable Functions
- BAN API Integration Workshop
- Installing HTTP Extension Windows
- Outstanding Database Topics
- Database Triggers and Procedures
- PostgreSQL Authentication
- PostgreSQL Roles Management
- Final Lab Session
- ADEME Database Worksheet
- ADEME Database Solutions
- Titanic Dataset Practice
- Titanic Table SQL
- Installing on Windows
MLOps - DPE
Production pipeline for energy diagnostic prediction using ADEME data