Consult our trainings :
SQL Server, programmation SQL Training
versions 2019 à 2012 - certification AVIT® à distance en option
Vidéo de présentation- Program
- Participants / Prerequisite
- Intra/Tailored
This course will enable you to learn the fundamentals of the SQL language. You'll learn about the principles of relational databases (relational algebra, set theory) and explore the syntax of SQL for querying, analyzing data, and working with databases.
Learning objectives
À l’issue de la formation, le participant sera en mesure de :- Understand the relational model and identify the objects of a database.
- Query and classify a table's data using simple operators.
- Return data from multiple tables using joins and subqueries.
- Group together data and perform calculations for analysis purposes.
- Work with data in database tables.
Relational algebra and the SQL standard.
- The concepts of the relational model.
- History of RDBMSs and the SQL language.
- Entities, associations, and ER diagrams.
- Types of data and value expressions.
Jeu de rôle
Getting started with the software SQL Server Management Studio. Discovering the studied database.
Database theory
- Elements of the DBMS.
- Tables, keys, and normal forms.
- Entities, associations, and ER diagrams.
- Column and table restrictions.
Travaux pratiques
Identifying the objects of a database. Determining the normal form type of a relationship and a transformer, creating an ER diagram.
Querying single-table data
- Structure of a SELECT query.
- WHERE filters, predicates, and ternary logic (NULL).
- SQL operators and expressions.
- Predefined functions.
Travaux pratiques
Extraction using the WHERE clause. Using IN, LIKE, CASE, etc. operators of numerical operators, data, string functions Data sorting
Multiple-table querying
- Combining results with set clauses (UNION, INTERSECT, EXCEPT).
- Overview of joins.
- Embedding queries.
- Using CTEs and discovering recursive queries.
- Correlated subqueries and the EXISTS operator.
Travaux pratiques
Using set clauses, creating queries with joins.
Data analysis
- Aggregation functions (AVG, SUM, COUNT, etc.).
- Creating subsets (GROUP BY clause).
- Filtering aggregates with the HAVING clause.
- Discovering data analysis functions (LEAD, LAG...) and ranks (RANK, ROW_NUMBER, NTILE...).
Travaux pratiques
Analyzing data by writing queries that use calculations with grouping.
