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
Foundations of SQL
- Defining SQL
- Concepts behind relational databases
- Overview of database engines and utilities
Essential Data Extraction
- Constructing SELECT queries
- Applying WHERE clauses for filtering
- Ordering results with ORDER BY
Managing Columns and Rows
- Utilizing DISTINCT for unique values
- Assigning column aliases
- Restricting the number of results
Advanced Filtering and Comparisons
- Using comparison operators
- Implementing BETWEEN, IN, and LIKE
- Combining conditions with logical operators (AND, OR, NOT)
Summarizing and Categorizing Data
- Using functions like COUNT, SUM, AVG, MIN, and MAX
- Applying the GROUP BY clause
- Filtering groups with the HAVING clause
Introduction to Table Joins
- The role of primary and foreign keys
- Executing INNER JOINs
- Working with LEFT and RIGHT JOINs
Introduction to Subqueries
- Basics of nested queries
- Nesting subqueries within SELECT statements
- Using subqueries in WHERE clauses
Recap and Future Learning
Requirements
- A solid grasp of fundamental computer tasks
- Experience working with spreadsheets or tabular formats
- No previous coding knowledge is necessary
Target Learners
- Business analysts
- Professionals involved in data entry
- 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
