Description
Training objective: This "SQL Language - Mastery" training covers the general structure of RDBMS (Relational Database Management Systems) and the philosophy of the SQL language, learning to naturally and easily formulate simple or complex queries. This training also teaches you to read and write more complex SQL queries using a robust methodology.
Learning Objectives
- Discover and understand the SQL environment as well as the schema of a database and tables
- Learn to write SQL queries to extract data and update the database
- Extract information from multiple tables
- Understand standard SQL functions as well as joins and their variants
- Know how to use set-based queries
- Master writing complex SQL queries
- Understand the modeling of a complex query using a tree and then transcribe this tree into an SQL query
Target Audience
Developers
Operators working on a database server
Future database administrators
BI users
Prerequisites
Understanding of database management systems
Optional: Basics of SQL
Program Outline
Informations
Duration
5 jour(s)
35h
Tarif
3250 € HT
HT
Similar Trainings
IA & Data
Cloud Migration
2 jour(s)
Sur demande
IA & Data
AI Agents – Designing Autonomous Systems with LangChain and LangGraph – Advanced
3 jour(s)
Sur demande
IA & Data
European AI Act — Understanding your obligations and ensuring compliance — Beginner level
1 jour(s)
Sur demande
IA & Data
Data Analysis with Microsoft Power BI (4-167)
3 jour(s)
2200 € HT