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
Getting Started with SQL
- Defining SQL and its purpose
- Exploring the concepts of relational databases
- Overview of database engines and associated tools
Essential Data Extraction
- Mastery of SELECT statements
- Applying filters using the WHERE clause
- Organizing output with ORDER BY
Managing Columns and Rows
- Implementing DISTINCT to remove duplicates
- Assigning meaningful column aliases
- Restricting the volume of returned results
Advanced Filtering and Comparisons
- Utilizing standard comparison operators
- Applying BETWEEN, IN, and LIKE conditions
- Combining conditions with logical operators (AND, OR, NOT)
Aggregation and Grouping
- Using functions such as COUNT, SUM, AVG, MIN, and MAX
- Structuring data with the GROUP BY clause
- Filtering groups using the HAVING clause
Foundations of Table Joins
- Comprehending primary and foreign key relationships
- Executing INNER JOINs
- Exploring LEFT JOIN and RIGHT JOIN variations
Integrating Subqueries
- Introduction to the concept of subqueries
- Nesting subqueries within SELECT statements
- Using subqueries inside WHERE clauses
Wrap-Up and Future Directions
Requirements
- A solid grasp of fundamental computer operations
- Basic experience working with spreadsheets or structured tabular data
- No previous coding or programming background is necessary
Target Learners
- Business analysts
- Data entry specialists
- Individuals new to the field of database management
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
