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
Revisiting SQL Fundamentals
- Recap of SELECT, WHERE, and GROUP BY clauses
- Brief overview of various JOIN types
- Grasping the sequence of query execution
Data Manipulation Commands
- INSERT INTO syntax
- UPDATE and DELETE statements
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Complex Joins and Set Operations
- FULL OUTER JOIN
- 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 Functionality
- ROW_NUMBER, RANK, and DENSE_RANK
- Utilizing PARTITION BY and ORDER BY
- Applying LEAD and LAG functions
Data Types and Functional Operations
- Handling string and date functions
- Using CASE and IF statements
- Managing type conversions and null values
Optimizing Queries
- Gaining insight into indexes
- Utilizing the EXPLAIN command
- Adopting best practices for efficient query construction
Wrap-up and Future Directions
Requirements
- Familiarity with fundamental SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- Comprehension of core relational database principles
Target Audience
- Data analysts
- Developers managing 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
