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 purpose of SQL
- Comprehending relational databases
- Overview of database engines and tools
Fundamentals of Data Retrieval
- Utilizing SELECT statements
- Filtering data with WHERE
- Organizing results with ORDER BY
Managing Columns and Rows
- Employing DISTINCT to eliminate duplicates
- Defining column aliases
- Restricting the number of returned results
Filtering and Comparison Techniques
- Applying comparison operators
- Using BETWEEN, IN, and LIKE conditions
- Implementing logical operators (AND, OR, NOT)
Aggregating and Grouping Data
- Functions: COUNT, SUM, AVG, MIN, MAX
- Utilizing the GROUP BY clause
- Filtering groups with the HAVING clause
Basics of Table Joins
- Grasping primary and foreign keys
- Performing INNER JOINs
- Executing LEFT JOINs and RIGHT JOINs
Leveraging Subqueries
- Introduction to subqueries
- Using subqueries within SELECT statements
- Using subqueries within WHERE clauses
Summary and Next Steps
Requirements
- Knowledge of basic computer operations
- Comfort with using spreadsheets or tabular datasets
- No previous programming background is necessary
Target Audience
- Business analysts
- Data entry specialists
- Individuals new to database interaction
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.
