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.
Course Outline
Revisiting SQL Fundamentals
- Overview of SELECT, WHERE, and GROUP BY clauses
- Brief examination of different JOIN types
- Comprehending the order of query execution
Data Manipulation Operations
- INSERT INTO statements
- UPDATE and DELETE commands
- Managing transactions using BEGIN, COMMIT, and ROLLBACK
Advanced Joins and Set Operations
- Utilizing FULL OUTER JOINs
- Working with UNION, INTERSECT, and EXCEPT
- Implementing SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Using CTEs (Common Table Expressions)
Window Functions
- Applying ROW_NUMBER, RANK, and DENSE_RANK
- Employing PARTITION BY and ORDER BY
- Utilizing LEAD and LAG functions
Data Types and Functions
- String and date manipulation functions
- Conditional logic with CASE and IF statements
- Handling type conversions and null values
Optimizing Queries
- The role and mechanics of indexes
- Analyzing performance with EXPLAIN
- Best practices for developing efficient queries
Wrap-up and Future Directions
Requirements
- Familiarity with basic SQL SELECT statements
- Practical experience with filtering, sorting, and simple join operations
- A fundamental understanding of relational database architecture
Target Audience
- Data analysts
- Developers working within SQL database environments
- Business intelligence professionals
14 Hours
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
