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
Fundamentals of SQL
- Defining SQL
- Grasping relational database structures
- Overview of database engines and utility tools
Core Data Retrieval
- Employing SELECT commands
- Applying filters via the WHERE clause
- Sorting results using ORDER BY
Handling Columns and Rows
- Implementing DISTINCT
- Assigning column aliases
- Restricting the volume of results
Advanced Filtering and Comparisons
- Utilizing comparison operators
- Applying BETWEEN, IN, and LIKE conditions
- Combining conditions with logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Using functions like COUNT, SUM, AVG, MIN, and MAX
- Applying the GROUP BY statement
- Refining groups with the HAVING clause
Introduction to Table Joins
- Distinguishing primary and foreign keys
- Executing INNER JOINs
- Performing LEFT and RIGHT JOINs
Exploring Subqueries
- Concepts of subqueries
- Nesting subqueries within SELECT statements
- Utilizing subqueries inside WHERE clauses
Recap and Further Learning
Requirements
- Basic proficiency with standard computer operations
- Exposure to spreadsheet software or tabular data formats
- No previous coding experience is necessary
Target Participants
- Business analysts
- Professionals focused on 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
