SQL Advanced Training in Madrid, Spain

This advanced SQL course is designed for professionals who are familiar with basic SQL and want to enhance their skills to handle complex queries, performance tuning, data manipulation, and analytical functions. The course emphasizes practical applications using real-world data scenarios, preparing participants for roles in data analysis, business intelligence, and database development.

Course Agenda

Advanced Querying Techniques

• Complex joins and subqueries

• Set operations (UNION, INTERSECT, EXCEPT)

• Nested and correlated subqueries

• Derived tables and inline views

Analytical & Window Functions

• Introduction to window functions

• RANK(), DENSE_RANK(), ROW_NUMBER()

• LEAD(), LAG(), FIRST_VALUE(), LAST_VALUE()

• Aggregate functions over partitions

Common Table Expressions (CTEs) & Recursive Queries

• Simple CTEs and readability

• Recursive CTEs for hierarchical data

• Real-world use cases

Performance Tuning and Indexing

• Execution plans and query profiling

• Index types and use cases

• Optimizing complex queries

• Avoiding common performance pitfalls

SQL Programming & Best Practices

• Stored procedures and functions

• Triggers and error handling

• Transaction control and isolation levels

• SQL security basics

Hands-on Exercises

Case Study