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 Basics
- Recap of SELECT, WHERE, and GROUP BY.
- Quick review of JOIN types.
- Understanding query execution order.
Data Manipulation Statements
- INSERT INTO.
- UPDATE and DELETE.
- Transaction control (BEGIN, COMMIT, ROLLBACK).
Advanced Joins and Set Operations
- FULL OUTER JOIN.
- UNION, INTERSECT, EXCEPT.
- SELF JOIN.
Subqueries and Derived Tables
- Correlated vs. non-correlated subqueries.
- Using subqueries in FROM.
- CTEs (Common Table Expressions).
Window Functions
- ROW_NUMBER, RANK, DENSE_RANK.
- PARTITION BY and ORDER BY.
- LEAD and LAG functions.
Data Types and Functions
- String and date functions.
- CASE and IF statements.
- Type conversions and null handling.
Query Optimization
- Understanding indexes.
- Using EXPLAIN.
- 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.
- 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
The lecture about cte
