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
- Refresher on SELECT, WHERE, and GROUP BY clauses
- Brief overview of various JOIN types
- Clarity on the order of query execution
Data Manipulation Statements
- Using INSERT INTO for adding records
- Executing UPDATE and DELETE operations
- Managing transaction control via BEGIN, COMMIT, and ROLLBACK
Advanced Joins and Set Operations
- Implementing FULL OUTER JOIN
- Applying UNION, INTERSECT, and EXCEPT
- Utilizing SELF JOIN techniques
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Incorporating subqueries within the FROM clause
- Employing CTEs (Common Table Expressions)
Window Functions
- Applying ROW_NUMBER, RANK, and DENSE_RANK
- Using PARTITION BY and ORDER BY effectively
- Leveraging LEAD and LAG functions
Data Types and Functions
- Working with string and date functions
- Utilizing CASE and IF statements for conditional logic
- Handling type conversions and null values
Query Optimization
- Gaining insight into the role of indexes
- Interpreting output from the EXPLAIN command
- Adopting best practices for developing efficient queries
Conclusion and Future Steps
Requirements
- Fundamental understanding of SQL SELECT statements
- Practical experience with filtering, sorting, and basic join operations
- Conceptual grasp of relational database structures
Target Audience
- Data analysts
- Developers working extensively 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 3200 € + 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
