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
Refresher on SQL Fundamentals
- Review of SELECT, WHERE, and GROUP BY
- Quick recap of JOIN variations
- Comprehending the order of query execution
Data Manipulation Operations
- INSERT INTO syntax
- Executing UPDATE and DELETE commands
- Managing transactions (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- Utilizing FULL OUTER JOIN
- Applying UNION, INTERSECT, and EXCEPT
- Implementing SELF JOIN
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries in the FROM clause
- Working with CTEs (Common Table Expressions)
Window Functions
- Using ROW_NUMBER, RANK, and DENSE_RANK
- Applying PARTITION BY and ORDER BY
- Leveraging LEAD and LAG functions
Data Types and Functions
- Handling string and date functions
- Using CASE and IF logic
- Managing type conversions and null values
Query Optimization
- Understanding the role of indexes
- Utilizing the EXPLAIN command
- Best practices for developing efficient queries
Conclusions and Future Learning
Requirements
- Familiarity with basic SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- A solid grasp of relational database fundamentals
Target Audience
- Data analysts
- Developers working with SQL databases
- Business intelligence specialists
14 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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
