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
Foundations of SQL
- Overview of SELECT, WHERE, and GROUP BY
- Refresher on various JOIN types
- Grasping the order of query execution
Managing Data with SQL
- Using INSERT INTO
- Implementing UPDATE and DELETE
- Controlling transactions (BEGIN, COMMIT, ROLLBACK)
Advanced Joining and Set Operations
- FULL OUTER JOIN
- UNION, INTERSECT, and EXCEPT
- SELF JOIN techniques
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Integrating subqueries in the FROM clause
- Utilizing CTEs (Common Table Expressions)
Advanced Analytics with Window Functions
- ROW_NUMBER, RANK, and DENSE_RANK
- Applying PARTITION BY and ORDER BY
- Using LEAD and LAG functions
Data Types and Utility Functions
- String and date manipulation functions
- Conditional logic with CASE and IF statements
- Handling type conversions and null values
Optimizing Query Performance
- The role of indexes
- Analyzing query plans with EXPLAIN
- Best practices for efficient query construction
Conclusion and Future Learning
Requirements
- Familiarity with basic SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- A solid grasp of relational database fundamentals
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
