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 (2 days)
Course Outline
Refresher on SQL Fundamentals
- Summary of SELECT, WHERE, and GROUP BY clauses
- Brief overview of various JOIN types
- Grasping the sequence of query execution
Data Modification Commands
- INSERT INTO syntax
- UPDATE and DELETE operations
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Complex Joins and Set Operations
- FULL OUTER JOIN usage
- UNION, INTERSECT, and EXCEPT operations
- Executing SELF JOINs
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Implementing CTEs (Common Table Expressions)
Window Functions
- Application of ROW_NUMBER, RANK, and DENSE_RANK
- Utilizing PARTITION BY and ORDER BY
- Employing LEAD and LAG functions
Data Types and Utility Functions
- String and date handling functions
- Logic using CASE and IF statements
- Type casting and managing null values
Enhancing Query Performance
- Insights into index usage
- Analyzing queries with EXPLAIN
- Best practices for crafting efficient queries
Conclusions and Future Learning
Requirements
- Familiarity with fundamental SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- Comprehension of relational database principles
Intended Audience
- Data analysts
- Developers engaged with 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
