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
Foundation Refresher
- Summary of SELECT, WHERE, and GROUP BY clauses
- Brief overview of various JOIN types
- Insight into the order of query execution
Data Modification Operations
- Utilizing INSERT INTO
- Applying UPDATE and DELETE statements
- Managing transactions using BEGIN, COMMIT, and ROLLBACK
Complex Joins and Set Logic
- Implementation of FULL OUTER JOIN
- Operations using UNION, INTERSECT, and EXCEPT
- Executing SELF JOINs
Nested Queries and Virtual Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Working with CTEs (Common Table Expressions)
Window Function Applications
- Usage of ROW_NUMBER, RANK, and DENSE_RANK
- Structuring queries with PARTITION BY and ORDER BY
- Employing LEAD and LAG functions
Handling Data Types and Built-in Functions
- Application of string and date functions
- Conditional logic using CASE and IF statements
- Managing type conversions and null values
Performance Tuning
- Concepts behind database indexes
- Analyzing execution plans with EXPLAIN
- Adopting best practices for efficient query writing
Conclusion and Future Development
Requirements
- Fundamental understanding of SQL SELECT statements
- Practical experience with data filtering, sorting, and basic joins
- Conceptual grasp of relational database principles
Target Audience
- Data analysts
- Developers managing SQL databases
- Business intelligence specialists
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
