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
- What is SQL?
- Grasping relational databases
- Database engines and associated tools
Foundational Data Retrieval
- SELECT commands
- Filtering data using WHERE
- Sorting results with ORDER BY
Handling Columns and Rows
- Utilizing DISTINCT
- Assigning column aliases
- Restricting result sets
Advanced Filtering and Comparison
- Comparison operators
- BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Aggregation and Grouping of Data
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY clause
- HAVING clause
Basics of Table Joins
- Understanding primary and foreign keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Utilizing Subqueries
- Introduction to subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Summary and Future Steps
Requirements
- A grasp of fundamental computer operations
- Comfort with using spreadsheets or tabular data
- No previous programming experience is necessary
Target Audience
- Business analysts
- Data entry specialists
- Individuals new to database work
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
