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
- Overview of SQL
- Concepts of relational databases
- Database engines and associated tools
Fundamental Data Retrieval
- SELECT commands
- Data filtering using WHERE
- Data sorting using ORDER BY
Managing Columns and Rows
- Application of DISTINCT
- Assigning column aliases
- Restricting output results
Advanced Filtering and Comparisons
- Various comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Functions: COUNT, SUM, AVG, MIN, MAX
- Utilizing the GROUP BY clause
- Applying the HAVING clause
Essentials of Table Joins
- Primary and foreign key relationships
- INNER JOIN syntax
- LEFT and RIGHT JOIN variations
Incorporating Subqueries
- Intro to subqueries
- Nesting subqueries in SELECT
- Nesting subqueries in WHERE
Recap and Future Directions
Requirements
- Basic proficiency with computer operations
- Experience handling spreadsheets or tabular datasets
- No prior programming background necessary
Target Audience
- Business analysts
- Professionals involved in data entry
- 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
