English
Issued by BI-REX Big Data Innovation & Research Excellence
BI-REX is one of the 8 Italian Competence Centers funded by the Italian Ministry of Enterprises and Made in Italy within the Industry 4.0 National Plan and our main focus is on Big Data.
Date of the event:
from 13/01/2026 to 21/01/2026
Duration:
16 h
Description:
Key topics covered:
- What is the SQL language and what is it used for
- Fundamentals of the relational model
- Selecting data: SELECT
- Filtering data: WHERE and logical operators
- Sorting data: ORDER BY
- Aggregation functions and grouping
- Joins and combinations between tables
- Conditional expressions: CASE…WHEN
- Managing null values with COALESCE
- Operations on strings and dates
- Subqueries with WHERE and HAVING
- Subqueries with IN and EXIST
- Creating, modifying, and deleting tables
- Union
Competences:
- Write efficient SQL queries to retrieve and analyze data in relational databases.
- Select, filter, aggregate, and combine data using appropriate SQL functions.
- Create and manage tables, and correctly manipulate strings and dates.
- Understand and apply relational database logic, using advanced JOINs and subqueries.
Evaluation criteria:
Frequency
