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
- Refresher on SELECT, WHERE, and GROUP BY
- Brief overview of various JOIN types
- Comprehending the logical order of query execution
Data Manipulation Operations
- INSERT INTO statements
- Executing UPDATE and DELETE operations
- Managing transactions using BEGIN, COMMIT, and ROLLBACK
Advanced Joins and Set Operations
- FULL OUTER JOIN implementation
- Using UNION, INTERSECT, and EXCEPT
- Performing SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Utilizing CTEs (Common Table Expressions)
Window Functions
- Applying ROW_NUMBER, RANK, and DENSE_RANK
- Configuring PARTITION BY and ORDER BY clauses
- Working with LEAD and LAG functions
Data Types and Functional Utilities
- String and date-related functions
- Implementing CASE and IF logic
- Handling type conversions and null values
Optimizing Query Performance
- Gaining insight into indexes
- Analyzing execution plans using EXPLAIN
- Adopting best practices for efficient query writing
Conclusion and Future Learning Path
Requirements
- Fundamental understanding of SQL SELECT statements
- Prior experience with filtering, sorting, and basic joins
- General knowledge of relational database concepts
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
