SQLFOND

SQL Fundamentals

The best course to get started with SQL

✓ Formation officielle SFEIR InstituteNiveau Fundamentals⏱️ 2 jours (14h)

Ce que vous allez apprendre

Know the use cases of a relational database
Manipulate data (search, add, modify, or delete) in a table
Manipulate data across multiple tables using joins
Implement the SELECT clause in an advanced manner: filters, groups, sorts, projection, functions, joins, subqueries
Design a relational database

Prérequis

None

Public cible

Developer, project manager, manager, data engineer, data analyst, Anyone else wishing to learn data manipulation in SQL

Programme de la Formation

7 modules pour maîtriser les fondamentaux

Sujets abordés

→What is data?
→Brief history of data management systems
→Relational database management systems
→The SQL language and its components DDL, DML, DCL, TCL, Procedural SQL
→What do we do with SQL today?

Quality Process

SFEIR Institute's commitment: an excellence approach to ensure the quality and success of all our training programs. Learn more about our quality approach

Teaching Methods Used

Lectures / Theoretical Slides — Presentation of concepts using visual aids (PowerPoint, PDF).
Technical Demonstration (Demos) — The instructor performs a task or procedure while students observe.
Guided Labs — Guided practical exercises on software, hardware, or technical environments.

Evaluation and Monitoring System

The achievement of training objectives is evaluated at multiple levels to ensure quality:

Continuous Knowledge Assessment : Verification of knowledge throughout the training via participatory methods (quizzes, practical exercises, case studies) under instructor supervision.
Progress Measurement : Comparative self-assessment system including an initial diagnostic to determine the starting level, followed by a final evaluation to validate skills development.
Quality Evaluation : End-of-session satisfaction questionnaire to measure the relevance and effectiveness of the training as perceived by participants.