Best
dbt
Create effective data management workflows with dbt
2 d
Fundamental
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
Related Trainings
Introduction to Data Analytics on Google Cloud
This course is an introduction to data analytics on Google Cloud. It is designed for learners who have no prior experience with data analytics or Google Cloud. The course covers the basics of data analysis, including collection, storage, exploration, visualization, and sharing. It also introduces learners to Google Cloud's data analytics tools and services. Through video lectures, demos, quizzes, and hands-on labs, the course demonstrates how to go from raw data to impactful visualizations and dashboards.
1 d
Fundamental
Introduction to Data Engineering on Google Cloud
In this course, you learn about data engineering on Google Cloud, the roles and responsibilities of data engineers, and how those map to offerings provided by Google Cloud. You also learn about ways to address data engineering challenges.
1 d
Fundamental
Upcoming sessions
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