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
- Understanding relational databases
- Database engines and tools
Fundamental Data Retrieval
- Utilizing SELECT statements
- Filtering data with WHERE
- Ordering results with ORDER BY
Managing Columns and Rows
- Employing DISTINCT
- Assigning column aliases
- Restricting output results
Filtering and Comparisons
- Comparison operators
- BETWEEN, IN, LIKE
- Logical operators (AND, OR, NOT)
Aggregating and Grouping Data
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY clause
- HAVING clause
Introduction to Table Joins
- Understanding primary and foreign keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Leveraging Subqueries
- Overview of subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Summary and Next Steps
Requirements
- Basic understanding of computer operations
- Familiarity with spreadsheets or tabular data management
- No previous programming experience necessary
Target Audience
- Business analysts
- Data entry specialists
- Individuals new to database operations
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
