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
- Refreshing key concepts: SELECT, WHERE, and GROUP BY
- Brief overview of various JOIN types
- Analyzing the sequence of query execution
Data Modification Commands
- Implementing INSERT INTO
- Executing UPDATE and DELETE operations
- Managing transactions with BEGIN, COMMIT, and ROLLBACK
Advanced Join Strategies and Set Operations
- Applying FULL OUTER JOIN
- Utilizing UNION, INTERSECT, and EXCEPT
- Performing SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Working with CTEs (Common Table Expressions)
Utilizing Window Functions
- Employing ROW_NUMBER, RANK, and DENSE_RANK
- Configuring PARTITION BY and ORDER BY clauses
- Applying LEAD and LAG functions
Data Types and Functional Operations
- Handling string and date functions
- Using CASE and IF logic statements
- Managing type conversions and null values
Optimizing Query Performance
- Gaining insight into index mechanisms
- Interpreting EXPLAIN outputs
- Adopting best practices for efficient query writing
Conclusion and Recommended Next Steps
Requirements
- Familiarity with fundamental SQL SELECT statements
- Practical experience in filtering, sorting, and executing basic joins
- A solid grasp of relational database principles
Target Audience
- Data analysts
- Developers engaged with SQL database environments
- 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
