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.
Duration 14 hours (2 days)
Course Outline
Introduction to SQL
- What is SQL?
- Concepts behind relational databases
- Overview of database engines and tools
Basic Data Retrieval
- Using SELECT statements
- Filtering data with WHERE
- Sorting results with ORDER BY
Managing Columns and Rows
- Applying DISTINCT
- Creating column aliases
- Restricting the number of results
Filtering and Comparisons
- Utilising comparison operators
- Using BETWEEN, IN, and LIKE
- Applying logical operators (AND, OR, NOT)
Aggregating and Grouping Data
- Functions such as COUNT, SUM, AVG, MIN, and MAX
- The GROUP BY clause
- The HAVING clause
Essentials of Table Joins
- Understanding primary and foreign keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Implementing Subqueries
- Overview of subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Recap and Further Learning
Requirements
- A solid grasp of basic computer operations
- Familiarity with spreadsheets or working with tabular data
- No prior programming background is necessary
Target Audience
- Business analysts
- Data entry specialists
- Individuals new to database management
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
