General
- CONCEPTION DE BASES DE DONNÉES
- Why SQL is neither legacy, nor low-level, nor difficult, nor the wrong place for (business) data logic, but simply awesome!
- Why Auto Increment Is A Terrible Idea
- Difference between INNER and OUTER joins
- How to Insert Data Into Tables with AUTO_INCREMENT Column(s)
- Primary key or Unique index?
- Quand faut-il une table associative ?
- Clean DB schemas talk
- with — Organize Complex Queries
- Impress Your Coworkers by Using SQL UNPIVOT!
- 10 SQL Tricks That You Didn’t Think Were Possible
- Gestion des dates et heures dans les bases de données
- Mysqldumpslow – Pour repérer rapidement vos requêtes SQL à optimiser
- Stockage des données Quel système pour quel usage (Zouheir Cadi)
- Avoiding “OR” for better query performance
PostgreSQL
- What PostgreSQL has over other open source SQL databases
- PostgreSQL Magic
- Review of operators in Postgres
- Tips and tricks for clean relational db schemas
- PostgreSQL on the Command Line
- Postgresql Table Partitioning
- The unofficial guide to JSONB operators in Postgres - Part 1
- Pense-bête SQL à télécharger