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 overview of JOIN types
- Comprehension of query execution order
Data Manipulation Statements
- INSERT INTO
- UPDATE and DELETE operations
- Transaction control mechanisms (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- FULL OUTER JOIN
- UNION, INTERSECT, and EXCEPT operators
- SELF JOIN techniques
Subqueries and Derived Tables
- Differentiating between correlated and non-correlated subqueries
- Utilizing subqueries within the FROM clause
- Implementing CTEs (Common Table Expressions)
Window Functions
- ROW_NUMBER, RANK, and DENSE_RANK
- Utilizing PARTITION BY and ORDER BY
- Employing LEAD and LAG functions
Data Types and Functions
- String and date manipulation functions
- CASE and IF conditional statements
- Handling type conversions and NULL values
Query Optimization
- Understanding the role of indexes
- Interpreting EXPLAIN output
- Adopting best practices for writing efficient queries
Summary and Next Steps
Requirements
- Fundamental understanding of SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- Knowledge of relational database concepts
Target Audience
- Data analysts
- Developers working with SQL-based 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
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.
