Modern SQL Essentials with Supabase and Python
Who is this for?
Relational databases and SQL remain the foundation of nearly all modern software systems, from web apps and SaaS platforms to analytics pipelines.
Students, developers, and anyone interested in getting started with the theory and practice of relational databases, SQL, Supabase, and Python.
Who is leading the session?
The session is led by Dr. Stelios Sotiriadis, CEO of Warestack, Associate Professor and MSc Programme Director at Birkbeck, University of London. His expertise includes cloud computing, distributed systems, data engineering, and AI engineering.
Stelios holds a PhD from the University of Derby, completed a postdoctoral fellowship at the University of Toronto, and has worked with Huawei, IBM, Autodesk, and several startups. Since 2018 he has taught at Birkbeck and, in 2021, founded Warestack, building software for startups globally.
What we’ll cover
A practical introduction to the core concepts of relational databases, including how to build and manage databases using SQL and modern tools like Supabase and Python.
You will learn:
What relational databases are and why they matter
SQL fundamentals
Joins, constraints, keys, indexing, and schemas
Hands-on database design and normalisation
Using Supabase as a modern PostgreSQL backend
Querying databases with Python
Building a simple CRUD application
Requirements
A laptop with Python (Windows, macOS, or Linux)
Visual Studio Code installed
Python pip installed
A free Supabase account
Basic internet access
If you don’t have a suitable laptop, you may use the lab computers.
Why Supabase and Python?
Supabase has become one of the most popular modern PostgreSQL platforms, widely adopted by startups and developers for its speed and simplicity. Python is one of the most used programming languages in the world, especially for data and backend development. Together, they form a highly popular and practical stack for building real applications.
Format
A 2-hour live session including:
Interactive theory
Hands-on SQL practice
Step-by-step coding exercises
Prerequisites
You should be comfortable writing simple Python scripts (basic to intermediate level). No prior SQL experience is required.