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
Getting Started with SQL
- The definition and role of SQL
- The concept of relational databases
- Overview of database engines and utilities
Fetching Basic Data
- The SELECT command
- Narrowing results using WHERE
- Ordering outputs with ORDER BY
Managing Columns and Rows
- Applying DISTINCT
- Assigning column aliases
- Restricting the volume of results
Filtering and Comparison Logic
- Standard comparison operators
- Using BETWEEN, IN, and LIKE
- Combining conditions with AND, OR, and NOT
Summarising and Grouping Data
- COUNT, SUM, AVG, MIN, and MAX functions
- The GROUP BY directive
- Refining groups with the HAVING clause
Fundamentals of Table Joins
- The roles of primary and foreign keys
- INNER JOIN mechanics
- LEFT JOIN and RIGHT JOIN concepts
Working with Subqueries
- Introduction to nested queries
- Placing subqueries within SELECT
- Using subqueries in WHERE clauses
Recap and Future Learning
Requirements
- A foundational grasp of basic computer usage
- Exposure to spreadsheets or tabular data structures
- No previous coding background is necessary
Who Should Attend
- Business analysts
- Professionals involved in data entry
- Anyone beginning their journey with database systems
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
