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
Review of SQL Fundamentals
- Recap of SELECT, WHERE, and GROUP BY clauses.
- Quick review of various JOIN types.
- Understanding the order of query execution.
Data Manipulation Statements
- INSERT INTO operations.
- UPDATE and DELETE commands.
- Transaction control (BEGIN, COMMIT, ROLLBACK).
Advanced Joins and Set Operations
- FULL OUTER JOIN.
- UNION, INTERSECT, and EXCEPT operations.
- SELF JOIN techniques.
Subqueries and Derived Tables
- Differentiating between correlated and non-correlated subqueries.
- Utilizing subqueries within the FROM clause.
- Working with CTEs (Common Table Expressions).
Window Functions
- Understanding ROW_NUMBER, RANK, and DENSE_RANK.
- Implementing PARTITION BY and ORDER BY.
- Using LEAD and LAG functions.
Data Types and Functions
- Working with string and date functions.
- Utilizing CASE and IF statements.
- Managing type conversions and null values.
Query Optimization
- Gaining an understanding of indexes.
- Using the EXPLAIN utility.
- Adopting best practices for writing efficient queries.
Summary and Next Steps
Requirements
- Fundamental knowledge of SQL SELECT statements.
- Practical experience with filtering, sorting, and basic joins.
- A solid understanding 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
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
