Querying Databases with SQL

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 an advanced 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 primarly 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

  • 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

From €2400 per group, including three training days. To be further specified with a quote. Additional travelling fees apply.

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!