Université Catholique de Lille
Sitraka FORLEREnterprise System Architect

Data Analytics for Business, M2 International Management

Session 3

SQL essentials for managers

Thursday 7 January 2027, 10:00–12:00, on campus
Université Catholique de Lille, Campus Vauban, Lille

customersid 101 Almaid 102 Baoid 103 Chloéid 104 Devordersid 101 49 €id 102 12 €id 104 80 €id 109 15 €INNER JOIN ON customers.id = orders.idChloé never ordered, order 109 has no customer: lost without LEFT or RIGHT
Figure 1: an inner join keeps only the keys present on both sides, the question to ask before every JOIN.

Open the session

Each session has its own password, given in class. Capitals, spaces and hyphens do not matter. The slides are encrypted: nothing can be read without it.

In this session

  1. How the case tables fit
  2. Select, filter, group
  3. Joins and their traps
  4. Auditing AI-written SQL
Session 19 December 2026Session 217 December 2026Session 37 January 2027Session 47 January 2027Session 58 January 2027Session 68 January 2027
Figure 2: the thread of the course; this session is highlighted.
SessionTitleDate
Session 1From data to decisions9 December 2026Open
Session 2Data visualisation and storytelling17 December 2026Open
Session 3SQL essentials for managers7 January 2027
Session 4Predictive analytics for decision-makers7 January 2027Open
Session 5Generative AI, governance and the EU AI Act8 January 2027Open
Session 6Capstone: pitch your insights8 January 2027Open

Table 1: the sessions of the course, in order; each one opens with its own password.