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
Review of SQL Fundamentals
- Recap of SELECT, WHERE, and GROUP BY
- Quick review of JOIN types
- Understanding the order of query execution
Data Manipulation Statements
- INSERT INTO
- UPDATE and DELETE
- Transaction control (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- FULL OUTER JOIN
- UNION, INTERSECT, EXCEPT
- SELF JOIN
Subqueries and Derived Tables
- Correlated versus non-correlated subqueries
- Utilizing subqueries in the FROM clause
- CTEs (Common Table Expressions)
Window Functions
- ROW_NUMBER, RANK, DENSE_RANK
- PARTITION BY and ORDER BY
- LEAD and LAG functions
Data Types and Functions
- String and date functions
- CASE and IF statements
- Type conversions and handling null values
Query Optimization
- Understanding indexes
- Using EXPLAIN
- Best practices for writing efficient queries
Summary and Next Steps
Requirements
- Foundational knowledge of SQL SELECT statements
- Experience with filtering, sorting, and basic joins
- Comprehension of relational database concepts
Audience
- Data analysts
- Developers interacting with SQL databases
- Business intelligence professionals
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
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
