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
Getting Started with SQL
- Defining SQL
- The concept of relational databases
- Overview of database engines and utilities
Fundamental Data Extraction
- Using SELECT statements
- Applying filters with WHERE
- Ordering results with ORDER BY
Managing Columns and Rows
- Eliminating duplicates with DISTINCT
- Assigning column aliases
- Restricting the number of results
Advanced Filtering and Logic
- Using comparison operators
- Applying BETWEEN, IN, and LIKE
- Combining conditions with AND, OR, and NOT
Summarizing and Grouping Information
- Applying COUNT, SUM, AVG, MIN, and MAX
- Using the GROUP BY statement
- Filtering groups with the HAVING statement
Introduction to Table Joins
- Primary and foreign key concepts
- Implementing INNER JOINs
- Utilizing LEFT and RIGHT JOINs
Exploring Subqueries
- Basics of nested queries
- Using subqueries within SELECT statements
- Applying subqueries in WHERE clauses
Review and Future Path
Requirements
- Proficiency with basic computer navigation and operations
- Experience working with spreadsheets or tabular data structures
- Previous programming knowledge is not necessary
Intended Learners
- Business analysts
- Data entry specialists
- Individuals starting their journey with database management
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
