Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to SQL
- The fundamentals of SQL
- The anatomy of relational databases
- Database engines and associated tools
Basic Data Retrieval
- Using SELECT statements
- Applying filters via WHERE
- Sorting results with ORDER BY
Working with Columns and Rows
- Utilising DISTINCT
- Assigning column aliases
- Restricting the number of results
Filtering and Comparison
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Aggregating and Grouping Data
- Functions such as COUNT, SUM, AVG, MIN, MAX
- The GROUP BY clause
- The HAVING clause
Table Joins Basics
- Comprehending primary and foreign keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Using Subqueries
- Overview of subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Summary and Next Steps
Requirements
- Basic proficiency with computer operations
- Experience working with spreadsheets or tabular data structures
- No previous programming background is necessary
Target Audience
- Business analysts
- Data entry specialists
- Individuals new to database management
14 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,
Annina - Ricardo AG
Course - SQL: Basics to Intermediate
The lecture about cte
