SQL & PostgreSQL - Databases
SQL queries, joins, indexes, transactions and PostgreSQL administration. Model, query and optimise your data.
- Write well-controlled SQL queries
- Model relational data
- Optimise with indexes
- Administer PostgreSQL day to day
- Write complex SQL queries (multiple joins, subqueries, aggregations) without help
- Identify and fix a performance problem on a slow query using execution plans
- Administer a PostgreSQL database in production: backups, users, permissions, monitoring
- Model a data schema that withstands changing business needs
The programme
Day 1 - Essential SQL
- SELECT, WHERE, ORDER BY, LIMIT: syntax and pitfalls
- Joins: INNER, LEFT, RIGHT, FULL, CROSS, self-join
- Correlated subqueries, CTEs (WITH), window functions (ROW_NUMBER, LAG, LEAD)
- Aggregations: GROUP BY, HAVING, ROLLUP
- Workshop: complex business queries on a real e-commerce schema
Day 2 - Modelling & integrity
- Normalisation: 1NF, 2NF, 3NF, and when to denormalise
- Primary and foreign keys, UNIQUE, CHECK and NOT NULL constraints
- Transactions: ACID, isolation levels, deadlocks
- Migrations: ALTER TABLE, zero-downtime strategies
- Workshop: designing a multi-table schema, migration and rollback
Day 3 - PostgreSQL & performance
- B-tree, GIN, GiST and partial indexes: choosing the right type
- EXPLAIN ANALYZE: reading an execution plan, spotting seq scans
- pg_stat_statements, autovacuum, connections and pooling (PgBouncer)
- Backup: pg_dump, pg_basebackup, point-in-time recovery
- Workshop: optimising slow queries, before/after EXPLAIN ANALYZE
Who is this for
Developers, analysts, data and technical profiles.
Prerequisites
- No SQL prerequisites
- Basic logic
Format
Frequently asked questions
Is the course eligible for OPCO or CPF funding?
No. Sphinx-Digital is not Qualiopi certified and is not listed on Mon Compte Formation. The course is invoiced directly to the company or the individual, with no external funding.
What is the difference between the public (inter-company) and in-company formats?
In the public format, you join a session with participants from other companies (3 to 10 people). In-company, we run a session dedicated to your team, on your site or remotely, with content adapted to your context. In-company pricing is available on quote.
Remote or on-site: what are the practical differences?
Content and labs are identical. Remotely, labs run on cloud environments accessible from a browser, with nothing to install. On-site, you provide the workstations; labs can run in the cloud or locally depending on your infrastructure.
How many participants per session?
3 to 10 participants at most. This deliberate limit ensures everyone can ask questions, adapt the exercises to their context and get a detailed answer.
What is the evening format?
The evening format spreads the same course over 4 sessions of 3.5 hours (14 hours in total), in the evening from 6:30 pm to 10:00 pm. Same content, same labs, same price, so you can build skills without taking days off.
How does payment work?
Courses are invoiced on quote, by bank transfer. Payment in instalments is possible. We issue a training agreement for companies that want their training department to cover the cost.
Interested in this course?
Join the next session or request a tailored in-company session.
What participants say
Not sure this course fits your context?
A 20-minute call to take stock before you enrol, with no sales pitch.