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
- Refresher on SELECT, WHERE, and GROUP BY
- Brief overview of JOIN types
- Grasping the order of query execution
Data Manipulation Operations
- INSERT INTO commands
- UPDATE and DELETE operations
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- FULL OUTER JOIN usage
- UNION, INTERSECT, and EXCEPT operations
- Implementing 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
- Using PARTITION BY and ORDER BY
- Employing LEAD and LAG functions
Data Types and Functions
- Working with string and date functions
- Using CASE and IF statements
- Handling type conversions and null values
Query Optimization
- Comprehending the role of indexes
- Utilizing EXPLAIN for analysis
- Adhering to best practices for efficient query writing
Summary and Future Directions
Requirements
- Familiarity with SQL SELECT statements
- Experience in filtering, sorting, and basic joins
- Foundational understanding of relational database concepts
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
