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.
- Exploring relational databases.
- Database engines and associated tools.
Fundamental Data Retrieval
- Utilizing SELECT statements.
- Filtering data with WHERE.
- Ordering results with ORDER BY.
Managing Columns and Rows
- Employing DISTINCT.
- Creating column aliases.
- Restricting result sets.
Filtering and Comparison Techniques
- Comparison operators.
- Utilizing BETWEEN, IN, and LIKE.
- Logical operators (AND, OR, NOT).
Aggregating and Grouping Data
- Functions: COUNT, SUM, AVG, MIN, MAX.
- Implementing the GROUP BY clause.
- Applying the HAVING clause.
Basics of Table Joins
- Understanding primary and foreign keys.
- INNER JOIN operations.
- LEFT JOIN and RIGHT JOIN techniques.
Working with Subqueries
- Introduction to subqueries.
- Using subqueries within SELECT.
- Utilizing subqueries in WHERE conditions.
Summary and Future Learning Paths
Requirements
- Familiarity with basic computer operations.
- Experience using spreadsheets or tabular data.
- No previous programming background required.
Target Audience
- Business analysts.
- Data entry specialists.
- 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
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.
