Short Coding Course — South Africa
Database Design, Advanced SQL & Performance
PostgreSQL is the world's most advanced open-source relational database. This course covers database design from ERDs to implementation, advanced SQL queries, indexing strategies, stored procedures, triggers and performance optimisation — all using PostgreSQL.
Install PostgreSQL, use psql and pgAdmin, understand roles and authentication.
Entity-Relationship Diagrams, normalisation (1NF–3NF), primary and foreign keys.
CREATE, ALTER, DROP; INSERT, UPDATE, DELETE, TRUNCATE — with safety.
JOINs (inner, left, right, full, cross, self), subqueries, CTEs and window functions.
GROUP BY, HAVING, aggregate functions and ROLLUP/CUBE.
B-tree, hash and partial indexes; EXPLAIN ANALYZE and query optimisation.
ACID properties, isolation levels, locking and avoiding deadlocks.
PL/pgSQL functions, control flow, loops and using them from your application.
Row-level and statement-level triggers; materialised views.
pg_dump, pg_restore, row-level security and production best practices.
All courses are taught by experienced bootcamp instructors of the Code College team — with a total of 30+ years of industry experience in the team.
You write code from day one. Every concept is reinforced with real exercises and a practical project you keep.
Attend in-person at our Woodmead (JHB) campus or join 100% online from anywhere.
Receive a Code College certificate on completion — recognised by employers across South Africa.
Book the PostgreSQL Course today — full-time (5 days) or part-time. Johannesburg, Cape Town and online.