NEXT DATA's SQL training teaches the language of relational databases, used to query, join and aggregate company data. It goes from the first query to window functions, with exercises on a database close to those found in companies, in Mohammedia or remotely.
SQL is the language of relational databases: it is used to query, combine and aggregate company data.
This course goes from the first query to window functions, with exercises on a database similar to those found in companies.
Who is this course for?
- Analysts and reporting officers
- Developers and testers
- Anyone who needs to extract their own data
SQL training sessions
- Price: 2 700 MAD
- Duration: 3 days (18 hours)
- Format: live online or in person in Mohammedia
- Schedule and arrangements: provided by our team upon registration
Sign up now for the SQL course
Registration request
Leave us your contact details: our team will call you back to discuss your project, the session schedule and the practical details of the SQL course.
By the end of the course, you will be able to:
- Write queries to select, filter and sort data
- Combine several tables with joins
- Aggregate and analyze with window functions
- Understand a relational model and its indexes
SQL course syllabus
- Relational model, tables and keys
- SELECT, WHERE, ORDER BY
- Data types and null values
- Inner and outer joins
- Unions and subqueries
- Common table expressions
- GROUP BY and HAVING
- Aggregate functions
- Reporting case studies
- Window functions: rank, running total, offset
- Dates and character strings
- Views
- Creating tables and constraints
- Insert, update, delete and transactions
- Indexes and reading an execution plan
Frequently Asked Questions (FAQ)
Analysts, developers, testers and business managers who need to access data without an intermediary.
No. The course starts with basic database concepts.
An open-source relational system. The queries studied follow the SQL standard and carry over to other systems.
Yes. Each concept is followed by exercises on a practice database.
It complements the Power BI and Python for data tracks, and prepares you for the Data Analyst and Data Engineer courses.
Fill in the form on this page: our team will get back to you with the session schedule and arrangements.
What our clients say about us
Youssef Harrak
Harrak is a seasoned data scientist specialising in machine learning models for predictive analytics. An expert in statistical analysis, he identifies trends in large datasets to guide business strategy.
Mohammed El Amrani
Mohammed is a data scientist and an expert in NLP and deep learning. He combines linguistics and machine learning to extract insights from text data, and is passionate about innovative solutions for language understanding and generation.
Sanaa Bouazza
Bouazza, a data analyst specialising in Business Intelligence (BI) and reporting. An expert in Tableau and Power BI, she turns complex data into user-friendly visualisations. Amily communicates trends effectively, enabling informed decisions for organisational success.
Karim El Mansouri
El Mansouri is an experienced data engineer in cloud and DevOps. An expert in AWS and Azure, he designs scalable data solutions. Focused on automation, Karim ensures efficient data delivery in the cloud.
Achraf Imrani
Achraf Imrani is a data analyst specialising in marketing and customer segmentation. An expert in extracting insights, he optimises campaigns for effective customer engagement.
Soufiane Tabrikt
Tabrikt is an experienced data engineer in big data processing and distributed systems. An expert in Apache Hadoop and Spark, Soufiane designs scalable architectures. His key role in building robust data infrastructures meets the varied and complex needs of organisations.
They trust us
Next Data is an IT, Data and Digital HR centre: recruitment, sourcing, training and consulting for IT, data and digital professions. We are drivers of performance, placing people at the heart of our success. What matters is not so much what we do as how we do it. In addition to our core activities, we also offer training courses to help our partners and employees develop their skills.
©2026. NEXT DATA. All Rights Reserved.