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.
Duration 14 hours (2 days)
Course Outline
Getting Started with SQL
- Defining SQL
- Concepts of relational databases
- Overview of database engines and tools
Retrieving Basic Data
- The SELECT statement
- Data filtering via WHERE
- Ordering results with ORDER BY
Managing Columns and Rows
- Application of DISTINCT
- Creating column aliases
- Restricting the number of results
Advanced Filtering and Comparison
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Aggregating and Grouping Information
- Functions: COUNT, SUM, AVG, MIN, MAX
- The GROUP BY clause
- Utilizing the HAVING clause
Essentials of Table Joins
- Primary and foreign keys explained
- Implementing INNER JOIN
- Understanding LEFT JOIN and RIGHT JOIN
Implementing Subqueries
- Overview of subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Wrap-up and Future Steps
Requirements
- Basic knowledge of standard computer operations
- Experience with spreadsheets or tabular data formats
- No previous programming background is necessary
Target Audience
- Business analysts
- Professionals in data entry
- Individuals new to database management
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
