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
- Definition and role of SQL.
- Understanding relational databases.
- Overview of database engines and tools.
Basic Data Retrieval
- Utilizing SELECT statements.
- Filtering data with WHERE clauses.
- Sorting results with ORDER BY.
Working with Columns and Rows
- Implementing DISTINCT.
- Defining column aliases.
- Limiting result sets.
Filtering and Comparison Techniques
- Applying comparison operators.
- Using BETWEEN, IN, and LIKE.
- Utilizing logical operators (AND, OR, NOT).
Aggregating and Grouping Data
- Functions: COUNT, SUM, AVG, MIN, MAX.
- Using the GROUP BY clause.
- Implementing the HAVING clause.
Basics of Table Joins
- Comprehending primary and foreign keys.
- Executing INNER JOIN.
- Executing LEFT JOIN and RIGHT JOIN.
Using Subqueries
- Introduction to subqueries.
- Applying subqueries within SELECT statements.
- Applying subqueries within WHERE clauses.
Summary and Next Steps
Requirements
- A foundational understanding of basic computer operations.
- Familiarity with using spreadsheets or tabular data.
- No previous programming experience is required.
Target Audience
- Business analysts.
- Data entry professionals.
- Individuals who are new to working with databases.
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
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
