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
Revisiting SQL Fundamentals
- Refresh on SELECT, WHERE, and GROUP BY
- Brief overview of JOIN types
- Clarifying query execution order
Data Manipulation Language
- INSERT INTO operations
- Executing UPDATE and DELETE commands
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Complex Joins and Set Operations
- FULL OUTER JOIN implementation
- Combining results with UNION, INTERSECT, EXCEPT
- Implementing SELF JOINs
Subqueries and Derived Tables
- Distinguishing correlated vs. non-correlated subqueries
- Incorporating subqueries within FROM clauses
- Utilizing CTEs (Common Table Expressions)
Window Functions
- Applying ROW_NUMBER, RANK, DENSE_RANK
- Leveraging PARTITION BY and ORDER BY
- Implementing LEAD and LAG functions
Data Types and Functions
- String and date processing functions
- Conditional logic using CASE and IF statements
- Managing type conversions and null values
Query Performance Tuning
- Concepts regarding indexes
- Analyzing execution plans with EXPLAIN
- Best practices for writing efficient queries
Conclusion and Future Steps
Requirements
- Foundational understanding of SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- Conceptual grasp of relational database structures
Target Audience
- Data analysts
- Developers utilizing 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
The lecture about cte
