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 (2 days)
Course Outline
Revisiting SQL Fundamentals
- Recap of SELECT, WHERE, and GROUP BY clauses
- Refresher on various JOIN types
- Grasping the order of query execution
Data Modification Operations
- Using INSERT INTO statements
- Applying UPDATE and DELETE commands
- Managing transactions via BEGIN, COMMIT, and ROLLBACK
Complex Joins and Set Operations
- Implementing FULL OUTER JOIN
- Working with UNION, INTERSECT, and EXCEPT
- Utilizing SELF JOIN techniques
Nested Queries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries in the FROM clause
- Working with CTEs (Common Table Expressions)
Advanced Analytics with Window Functions
- Applying ROW_NUMBER, RANK, and DENSE_RANK
- Using PARTITION BY and ORDER BY within windows
- Utilizing LEAD and LAG functions
Handling Data Types and Functions
- Employing string and date-related functions
- Implementing CASE and IF logic
- Managing type conversions and null values
Enhancing Query Performance
- Comprehending index strategies
- Analyzing query plans using EXPLAIN
- Adopting best practices for writing efficient queries
Wrap-up and Future Directions
Requirements
- Fundamental understanding of SQL SELECT syntax
- Practical experience with data filtering, sorting, and basic joins
- Conceptual grasp of relational database structures
Target Audience
- Data analysts
- Developers working with SQL databases
- Business intelligence specialists
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
