SQLFOND

SQL Fundamentals Training - Learn SQL in 2 Days

Master SQL fundamentals in 2 days.

You'll start by understanding the history of data management systems and the role of relational databases today. Then you'll learn to manipulate your data: insert, update, delete, and most importantly query with SELECT.

Progressively, you'll master WHERE, ORDER BY, LIMIT clauses, then aggregations with GROUP BY and HAVING. You'll discover the power of joins to combine multiple tables, subqueries and Common Table Expressions (CTEs) to structure complex queries.

Finally, you'll cover database design: entity-relationship modeling, normalization, primary and foreign keys, indexes and views.

Hands-on training with 60% labs on real-world scenarios.

✓ Official training SFEIR InstituteLevel Fundamentals⏱️ 2 days (14h)

What you will learn

  • 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

Prerequisites

  • None

Target audience

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

Training Program

7 modules to master the fundamentals

Topics covered
  • →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?
Topics covered
  • →Databases, Schemas, Tables, and Columns
  • →Insert a row
  • →Modify a row
  • →Delete a row
  • →Read one or more rows
Topics covered
  • →FROM to define which table to read from
  • →WHERE to filter rows
  • →Usable operators in WHERE
  • →SELECT to project results
  • →Usable operators in SELECT: *, DISTINCT, AS, numeric operators,...
  • →ORDER BY to sort the result
  • →LIMIT to limit the number of search results
Topics covered
  • →GROUP BY to create groups
  • →HAVING to filter groups
  • →Aggregation functions: COUNT, SUM, AVG, ...
  • →Examples involving the clauses SELECT..FROM..WHERE..GROUP BY..HAVING..ORDER BY..LIMIT
Topics covered
  • →Joins and join conditions
  • →Inner and outer joins, self joins, cross joins
  • →Set operations
Topics covered
  • →Available functions in SQL: string manipulation, numbers, dates, regular expressions,...
  • →Subqueries
  • →Common Table Expressions
Topics covered
  • →Entity, Attribute, Relations approach
  • →Some basics of linear algebra, normalization and denormalization
  • →Integrity constraints
  • →Primary keys, foreign keys, surrogate keys
  • →DML instructions to create and modify databases, tables, and columns
  • →Indexes
  • →Views

Related Trainings

SFEIR Institute
Best

dbt

Learn to transform your data with dbt, the leading tool in the Modern Data Stack. You'll start by understanding the evolution of data architectures and the difference between ETL and ELT. You'll install dbt, create your first project and connect it to your data sources. Then you'll learn to build structured data models, choose the right materialization options (table, view, incremental) and organize your metadata with tags. You'll discover how to reference your sources and manage dependencies between models. You'll explore advanced features: seeds to initialize reference data, snapshots to track history and manage slowly changing dimensions, Jinja macros and variables to automate your transformations. Finally, you'll implement automated tests to ensure data quality, document your models with lineage, and discover packages from the dbt community. Hands-on training with 60% labs.

2 d
Fundamental
Google Cloud

Data Warehousing with BigQuery: Storage Design, Query Optimization, and Administration

In this course, you learn about the internals of BigQuery and best practices for designing, optimizing, and administering your data warehouse. Through a combination of lectures, demos, and labs, you learn about BigQuery architecture and how to design optimal storage and schemas for data ingestion and changes. Next, you learn techniques to improve read performance, optimize queries, manage workloads, and use logging and monitoring tools. You also learn about the different pricing models. Finally, you learn various methods to secure data, automate workloads, and build machine learning models with BigQuery ML.

3 d
Intermediate

Upcoming sessions

May 4, 2026
Distanciel • Français
Register
August 5, 2026
Distanciel • Français
Register
December 8, 2026
Distanciel • Français
Register

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.

Frequently Asked Questions

This training is designed for developers, project managers, managers, data engineers and data analysts who want to learn data manipulation with SQL. It's also suitable for anyone new to SQL. No prior knowledge is required.
No technical prerequisites are required. This training is designed for beginners who have never used SQL. Familiarity with data concepts (tables, rows, columns) is helpful but not mandatory.
In 2 days, you'll learn to manipulate data with SELECT, WHERE, JOIN and GROUP BY. You'll discover subqueries, Common Table Expressions (CTEs), and the basics of relational database design: primary and foreign keys, indexes and views.
SQLFOND covers SQL fundamentals: reading, writing, joins and basic design. To go further, the dbt training will teach you to structure your data transformations, and BigQuery trainings will let you apply SQL at cloud scale.
The training alternates between theoretical presentations and hands-on exercises. Each concept is immediately applied with SQL queries on a sample database. About 60% of the time is dedicated to practice.
Our training organizations SFEIR SAS and SFEIR-Est are Qualiopi certified for training activities, enabling funding through various European professional development schemes. Funding acceptance depends on your organization's policies. Contact us for a quote.

1,580€ excl. VAT

per learner