Description
You regularly work with data but are not a developer: this training enables you to query a relational database, build your own SQL queries, and extract useful information independently.
Learning Objectives
- Understand the structure of a relational database and read a data model
- Write SELECT queries to extract data based on precise criteria
- Perform joins to cross-reference information from multiple tables
- Use aggregation functions to calculate statistics and produce summaries
- Sort, filter, and format query results
- Write simple subqueries to address common analytical needs
- Build end-to-end queries based on a business requirement
Target Audience
Reporting and analysis specialists, management controllers, assistants, HR managers, sales professionals, and more broadly any professional regularly querying a database as part of their role, without a technical background.
This training is aimed at business users seeking to gain autonomy in data extraction and analysis.
It is not intended for developers or database administrators.
Prerequisites
No programming or database knowledge is required. Proficiency with office tools (especially Excel) is sufficient
Program Outline
Informations
Duration
3 jour(s)
21h
Tarif
Sur demande