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
Refresher on SQL Fundamentals
- Revisiting SELECT, WHERE, and GROUP BY
- Brief overview of various JOIN types
- Grasping the order of query execution
Statements for Data Manipulation
- INSERT INTO operations
- Executing UPDATE and DELETE actions
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Sophisticated Joins and Set Operations
- Implementing FULL OUTER JOIN
- Applying UNION, INTERSECT, and EXCEPT
- Utilizing SELF JOIN
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Exploring CTEs (Common Table Expressions)
Application of Window Functions
- Employing ROW_NUMBER, RANK, and DENSE_RANK
- Using PARTITION BY and ORDER BY effectively
- Leveraging LEAD and LAG functions
Data Types and Utility Functions
- Handling string and date operations
- Using CASE and IF logic
- Managing type conversions and null values
Strategies for Query Optimization
- The role of indexes in performance
- Analyzing performance with EXPLAIN
- Adopting best practices for efficient query design
Course Wrap-up and Future Path
Requirements
- Fundamental understanding of SQL SELECT statements
- Practical experience with data filtering, sorting, and basic joins
- Grasp of core relational database principles
Target Audience
- Data analysts
- Developers interfacing with SQL databases
- Business intelligence specialists
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
