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
Refresher on SQL Fundamentals
- Revision of SELECT, WHERE, and GROUP BY clauses
- Overview of various JOIN types
- Grasping the logical execution order of queries
Data Modification Commands
- Using INSERT INTO
- Performing UPDATE and DELETE operations
- Managing transactions with BEGIN, COMMIT, and ROLLBACK
Complex Joins and Set Operations
- Implementing FULL OUTER JOIN
- Utilizing UNION, INTERSECT, and EXCEPT
- Applying SELF JOINs
Nested Queries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Employing subqueries within the FROM clause
- Leveraging CTEs (Common Table Expressions)
Window Functions
- Working with ROW_NUMBER, RANK, and DENSE_RANK
- Using PARTITION BY and ORDER BY partitions
- Applying LEAD and LAG functions
Data Types and Built-in Functions
- Handling string and date functions
- Using CASE and IF statements for conditional logic
- Managing type conversions and null values
Optimizing Query Performance
- Concepts of database indexing
- Analyzing performance with EXPLAIN
- Adopting best practices for efficient query writing
Recap and Future Learning Path
Requirements
- Fundamental understanding of SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- Conceptual grasp of relational database principles
Target Audience
- Data analysts
- Developers handling 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