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
Course Outline
Refresher on SQL Fundamentals
- Recap of SELECT, WHERE, and GROUP BY
- Brief review of JOIN variations
- Comprehension of query execution order
Data Manipulation Statements
- INSERT INTO usage
- Implementation of UPDATE and DELETE
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- Utilizing FULL OUTER JOIN
- Applying UNION, INTERSECT, and EXCEPT
- Executing SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Implementing CTEs (Common Table Expressions)
Window Functions
- Applying ROW_NUMBER, RANK, and DENSE_RANK
- Using PARTITION BY and ORDER BY
- Leveraging LEAD and LAG functions
Data Types and Functions
- Handling string and date functions
- Writing CASE and IF statements
- Managing type conversions and null values
Query Optimization
- Gaining insight into indexes
- Interpreting EXPLAIN output
- Adopting best practices for efficient query writing
Course Conclusion and Future Directions
Requirements
- Fundamental knowledge of SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- A solid grasp of relational database concepts
Target Audience
- Data analysts
- Developers working with SQL databases
- Business intelligence professionals
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
