Course Outline
Review of SQL Fundamentals
- Summary of SELECT, WHERE, and GROUP BY
- Rapid overview of JOIN types
- Comprehension of query execution sequences
Data Manipulation Statements
- INSERT INTO
- UPDATE and DELETE
- Transaction management (BEGIN, COMMIT, ROLLBACK)
Advanced Joins and Set Operations
- FULL OUTER JOIN
- UNION, INTERSECT, EXCEPT
- SELF JOIN
Subqueries and Derived Tables
- Distinguishing between correlated and non-correlated subqueries
- Utilizing subqueries within the FROM clause
- CTEs (Common Table Expressions)
Window Functions
- ROW_NUMBER, RANK, DENSE_RANK
- PARTITION BY and ORDER BY
- LEAD and LAG functions
Data Types and Functions
- String and date functions
- CASE and IF statements
- Type conversions and handling of null values
Query Optimization
- Grasping the concept of indexes
- Using EXPLAIN
- Adopting best practices for writing efficient queries
Summary and Future Directions
Requirements
- Foundational understanding of SQL SELECT statements
- Practical experience with filtering, sorting, and basic joins
- Comprehension of relational database principles
Target Audience
- Data analysts
- Developers interacting with SQL databases
- Business intelligence specialists
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
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.
