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.
Duration 14 hours (2 days)
Course Outline
Introduction to SQL
- Defining SQL
- Concepts of relational databases
- Database engines and associated tools
Basic Data Retrieval
- SELECT queries
- Data filtering using WHERE
- Sorting data with ORDER BY
Handling Columns and Rows
- Application of DISTINCT
- Using column aliases
- Restricting result sets
Filtering and Comparisons
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Aggregating and Grouping Data
- COUNT, SUM, AVG, MIN, MAX functions
- The GROUP BY clause
- The HAVING clause
Basics of Table Joins
- Primary and foreign key relationships
- INNER JOIN operations
- LEFT and RIGHT JOIN techniques
Implementing Subqueries
- Overview of subqueries
- Subqueries within SELECT statements
- Subqueries within WHERE clauses
Conclusion and Future Pathways
Requirements
- A general grasp of standard computer operations
- Experience with spreadsheets or tabular data formats
- No previous coding background is necessary
Target Audience
- Business analysts
- Data entry specialists
- Individuals new to database management
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
