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
Getting Started with SQL
- Defining SQL
- The logic behind relational databases
- Overview of database engines and related tools
Foundations of Data Retrieval
- Executing SELECT commands
- Applying filters using WHERE
- Arranging results with ORDER BY
Managing Columns and Rows
- Removing duplicates with DISTINCT
- Creating column aliases
- Restricting the number of returned records
Advanced Filtering and Comparisons
- Utilizing comparison operators
- Using BETWEEN, IN, and LIKE clauses
- Combining conditions with logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Applying COUNT, SUM, AVG, MIN, and MAX
- Using the GROUP BY clause
- Filtering groups with the HAVING clause
Introduction to Table Joins
- Concepts of primary and foreign keys
- Executing INNER JOIN operations
- Understanding LEFT JOIN and RIGHT JOIN
Implementing Subqueries
- Basics of subquery structure
- Using subqueries within SELECT statements
- Using subqueries within WHERE conditions
Recap and Future Learning Paths
Requirements
- Basic familiarity with computer navigation and operations
- Experience working with spreadsheets or tabular information
- No previous coding background is necessary
Target Audience
- Business analysts
- Professionals handling 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
