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
- An overview of SQL
- Concepts behind relational databases
- Overview of database engines and associated tools
Extracting Basic Data
- Utilizing SELECT statements
- Applying filters with WHERE
- Ordering results with ORDER BY
Managing Columns and Rows
- Eliminating duplicates with DISTINCT
- Assigning column aliases
- Restricting the number of returned results
Advanced Filtering and Comparisons
- Using comparison operators
- Employing BETWEEN, IN, and LIKE
- Combining conditions with logical operators (AND, OR, NOT)
Aggregation and Data Grouping
- Applying functions like COUNT, SUM, AVG, MIN, and MAX
- Grouping data using the GROUP BY clause
- Filtering groups with the HAVING clause
Essentials of Table Joins
- Comprehending primary and foreign keys
- Executing INNER JOINs
- Working with LEFT JOIN and RIGHT JOIN
Introducing Subqueries
- Basic concepts of subqueries
- Nesting subqueries within SELECT statements
- Using subqueries within WHERE clauses
Recap and Future Learning Paths
Requirements
- Competence in basic computer operations
- Experience with spreadsheets or managing tabular data
- No previous programming background is necessary
Target Learners
- 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
