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
Part 1: SQL Fundamentals
Introduction to SQL and Databases
- Understanding databases.
- Introduction to SQL.
- Setting up the SQL environment.
SQL Syntax and Basic Queries
- Overview of SQL syntax.
- SELECT statements.
- Filtering data using the WHERE clause.
Working with Functions and Aggregates
- Common SQL functions.
- Aggregate functions: COUNT, SUM, AVG, MAX, MIN.
- Grouping data with GROUP BY.
Joining Tables
- Understanding JOINs.
- INNER JOIN.
- LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.
Subqueries and Set Operations
- Writing subqueries.
- UNION, INTERSECT, and EXCEPT operations.
Data Manipulation
- INSERT INTO statement.
- UPDATE statement.
- DELETE statement.
Part 2: Intermediate SQL
Advanced Data Filtering
- Advanced techniques for the WHERE clause.
- LIKE operator and pattern matching.
- IN and BETWEEN operators.
Complex Joins and Subqueries
- Self-joins.
- Non-correlated and correlated subqueries.
- EXISTS clause.
Working with Indexes and Views
- Understanding indexes and their impact on performance.
- Creating and using views.
Advanced Functions and Stored Procedures
- User-defined functions.
- Stored procedures and triggers.
- Error handling in SQL.
Data Transformation and Analysis
- Pivoting and unpivoting data.
- Window functions: ROW_NUMBER, RANK, DENSE_RANK.
- CTEs (Common Table Expressions).
Database Design and Normalization
- Principles of database design.
- Normal forms and normalization.
- Entity-Relationship (ER) modeling.
Performance Tuning and Optimization
- Query optimization techniques.
- Execution plans.
- Best practices for performance tuning.
SQL in the Real World
- Integrating SQL with other technologies.
- Case studies and real-world scenarios.
- Final project: Building a database solution from scratch.
Summary and Next Steps
Requirements
- A basic understanding of computer operations.
- Experience with any programming language is beneficial but not mandatory.
Target Audience
- Data analysts.
- Database professionals.
- Software developers.
35 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 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
Small group, in-person for 3 days,
