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
Recap of SQL Fundamentals
- Revision of SELECT, WHERE, and GROUP BY
- Brief review of JOIN types
- Grasping the order of query execution
Data Manipulation Statements
- INSERT INTO
- UPDATE and DELETE operations
- Transaction management (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- FULL OUTER JOIN
- UNION, INTERSECT, and EXCEPT
- SELF JOIN
Subqueries and Derived Tables
- Distinguishing correlated vs. non-correlated subqueries
- Utilising subqueries within FROM clauses
- Common Table Expressions (CTEs)
Window Functions
- ROW_NUMBER, RANK, and DENSE_RANK
- Partitioning and ordering with PARTITION BY and ORDER BY
- LEAD and LAG functions
Data Types and Functions
- String and date functions
- CASE and IF statements
- Type conversions and handling null values
Query Optimisation
- Understanding indexes
- Utilising EXPLAIN
- Best practices for crafting efficient queries
Summary and Path Forward
Requirements
- Foundational understanding of SQL SELECT statements
- Practical experience with filtering, sorting, and simple joins
- Comprehension of relational database concepts
Target Audience
- Data analysts
- Developers working with SQL databases
- 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
