Querying Databases with SQL

Download the brochure (PDF, French)

Objectives

By the end of this training course, you will be able to use SQL to query a relational database using PostgreSQL 🐘. You will thus gain a solid understanding of the relational model, the ability to locate the information you need within a database, and use DQL (Data Query Language) to write single-table and multi-table SQL queries, including functions and aggregations.

You will also become independent: capable of learning on your own how to use unknown functions, writing increasingly complex queries, and transferring your skills to other relational DBMS (Oracle, SQL Server, MySQL, DuckDB, etc.) and to the cloud (Azure SQL, Google BigQuery, etc.).

Target Audience

  • Non-IT professionals already comfortable with data, with knowledge of spreadsheets (Excel...);
  • IT professionals wishing to upskill or refresh their knowledge in databases.

Course Outline

Day 1

The first day's programme consists of a progressive familiarization with relational databases.

NOTE

This day is optional for learners already familiar with the concept of databases who wish to focus primarily on SQL.

Morning

  • What is a database?
  • Introduction to the relational model
    • Relational schema
    • Relations, attributes, keys
  • Quiz

Afternoon

  • Introduction to single-table data querying
    • Associated relational algebra operators
    • Introduction to SQL
  • Quiz

Day 2

The second day is dedicated to the introduction to DQL and the first interactions with a database.

Morning

  • Single-table queries
    • SELECT, FROM, WHERE
    • Conditions
    • Functions
  • Practical session
    • First connection to a database
    • Discovery of a new database
    • First single-table SQL queries
  • Quiz

Afternoon

  • Complex single-table queries

    • Aggregations (GROUP BY, HAVING)

  • Practical session

    • Single-table queries with functions and aggregations

  • Multi-table queries

    • Set operations (Review of sets)
    • "Simple" joins
    • Nested queries

  • Quiz

Day 3

The third day is dedicated to mastering multi-table queries and practice, with increasing difficulty in queries.

Morning

  • Practical session
    • Multi-table queries
    • Self-joins

Afternoon

  • Window functions
  • Practical session
    • Complex multi-table queries
  • Quiz

Technical Environment

Learners do not need specific hardware or software, only a computer with Internet access and a recent browser. The learning database is hosted on a PostgreSQL server; access is provided via pgAdmin.

Pricing

EARLY BIRD OFFER

Enjoy a 30% discount on my courses to celebrate the kick-off of my training activities! 🎉

The cost of this training course, is €2400 (reduced to €1680) for its 3-day format and €1600 (reduced to €1120) for its 2-day format, per group session on your premises (VAT not applicable, Article 293 B of the General Tax Code). Additional travel fees may apply outside of the Toulouse area.

Interested?

Feel free to contact me 📫 on LinkedIn or via email ! Together, we will refine your training needs according to the characteristics of your teams and your company. See you soon!