SQLFOND
SQL Fundamentals
The best course to get started with SQL
✓ 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
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.
Train multiple employees
- Volume discounts (multiple seats)
- Private or custom session
- On-site or remote