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.
- Comprehending relational databases.
- Database engines and associated tools.
Basic Data Retrieval
- Utilizing SELECT statements.
- Filtering data using WHERE.
- Sorting results with ORDER BY.
Managing Columns and Rows
- Applying DISTINCT.
- Creating column aliases.
- Restricting the number of results.
Filtering and Comparison Techniques
- Comparison operators.
- Using BETWEEN, IN, and LIKE.
- Logical operators (AND, OR, NOT).
Aggregating and Grouping Data
- Functions: COUNT, SUM, AVG, MIN, MAX.
- The GROUP BY clause.
- The HAVING clause.
Table Joins Fundamentals
- Understanding primary and foreign keys.
- INNER JOIN.
- LEFT JOIN and RIGHT JOIN.
Utilizing Subqueries
- Introduction to subqueries.
- Implementing subqueries in SELECT.
- Implementing subqueries in WHERE.
Summary and Next Steps
Requirements
- Familiarity with basic computer operations.
- Experience using spreadsheets or tabular data formats.
- No previous programming background is necessary.
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
The lecture about cte
