Introduction to SQL language
Duration
3 Days
Price
895,00 €
This course introduces the fundamental concepts of relational databases and the SQL language used to interact with them. Participants will start by exploring database models, architectures, and the essential objects that define relational systems. The training then focuses on writing SQL queries—from basic data retrieval with SELECT statements, filtering, and sorting, to working with multiple tables through various types of joins. Learners will also gain hands-on experience in grouping data with aggregate functions, applying set operators, and working with subqueries to solve more complex scenarios. By the end of the course, you will be equipped with the core SQL skills needed to query, organize, and analyze data effectively in a relational database environment.
Learning Objectives
After completing this course, you will be able to:
- Understand the fundamental concepts and structures of relational databases.
- Write basic SQL queries to retrieve, filter, and sort data.
- Combine data from multiple tables using different types of joins.
- Use aggregate functions to summarize data and apply grouping with GROUP BY and HAVING.
- Apply set operators to merge and compare query results.
- Create and use subqueries to solve more complex data retrieval tasks.
-
-
-
Course Outline
1 - Introduction to Databases
- Definition, models, and types of databases.
- Basic architectures.
- Introduction to relational databases.
- Key objects in relational databases.
2 - Introduction to SQL
- SQL query language and tools for working with it.
- Creating basic SELECT queries.
- Filtering data using the WHERE clause.
- Sorting data.
3 - Queries from Multiple Tables
- General concepts.
- Using INNER JOIN.
- Using OUTER JOIN.
- Using CROSS JOIN and SELF JOIN.
4 - Data Grouping
- Aggregate functions.
- Grouping data using the GROUP BY clause.
- Filtering grouped data using the HAVING clause.
5 - Set Operators
- General overview of set operators.
- Using set operators.
6 - Subqueries
- General description and use cases.
- Types of subqueries.
Target Audience
he audience for this course includes:
-Beginners in databases who want to build a solid foundation in SQL.
- Data professionals and analysts who need to query and organize data from relational databases.
- Developers and IT specialists who work with applications that interact with databases.
- Business users who want to gain essential SQL skills to support reporting and decision-making.
Candidates must have basic knowledge of the Windows operating system.
Experience with Access would be an advantage.