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.
Back-end and full-stack developers who want to design better schemas and write faster, safer SQL.
Go beyond basic queries with joins, CTEs, window functions and aggregation.
Manage roles, backups, restores, security and performance in PostgreSQL.
Teams migrating from MySQL, SQL Server or Oracle to the leading open-source database.
All courses are taught by Code College’s senior development trainers — practitioners with real-world industry experience, backed by over 20 years of professional developer training since 2004.
You write code from day one. Every concept is reinforced with real exercises and a practical project you keep.
Join 100% live online from anywhere, or hybrid — one or two days a week at our Midrand campus and the rest live online. Full-time face-to-face attendance can be requested, and is possible when an onsite group class is running.
Receive a Code College certificate on completion — recognised by employers across South Africa.
A basic understanding of databases helps, but the course starts with setup and database design before moving on to advanced SQL, performance and administration.
Both. Developers focus on design, advanced queries and performance; administrators benefit from transactions, backups, restores and security. Many teams send both together.
Yes. Most SQL concepts — joins, indexes, transactions and normalisation — apply to MySQL, SQL Server and Oracle as well. PostgreSQL-specific features such as PL/pgSQL and row-level security are clearly highlighted.
Individuals join live online from anywhere, or hybrid — one or two days a week at our Midrand campus and the rest live online. Group courses run live online or hybrid, with fully onsite delivery at our Midrand campus optional, on request. Contact us for a group quote.
Yes. Code College is a B-BBEE Level 4 contributor and training spend qualifies as skills development under the B-BBEE scorecard. The course fee also counts toward your SDL (Skills Development Levy) spend.
Book the PostgreSQL Course today — full-time (5 days) or part-time. Johannesburg and online.