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
- Defining SQL
- Understanding relational databases
- Database engines and tools
Fundamentals of Data Retrieval
- Utilising SELECT statements
- Filtering data with WHERE
- Sorting results with ORDER BY
Working with Columns and Rows
- Applying DISTINCT
- Creating column aliases
- Limiting the number of results
Filtering and Comparison Techniques
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Aggregating and Grouping Data
- COUNT, SUM, AVG, MIN, MAX
- The GROUP BY clause
- The HAVING clause
Fundamentals of Table Joins
- Understanding primary and foreign keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Utilising Subqueries
- Introduction to subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Summary and Future Steps
Requirements
- A foundational understanding of basic computer operations
- Familiarity with spreadsheets or tabular data
- No prior programming experience is necessary
Target Audience
- Business analysts
- Data entry professionals
- Individuals new to database management
14 Hours
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
