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
Course Outline
Foundations of SQL
- Defining SQL
- Grasping the concept 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
- Applying DISTINCT
- Assigning column aliases
- Restricting output size
Advanced Filtering and Comparison
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Aggregation and Grouping
- Functions such as COUNT, SUM, AVG, MIN, and MAX
- The GROUP BY clause
- The HAVING clause
Introduction to Table Joins
- Primary and foreign key concepts
- INNER JOIN operations
- LEFT JOIN and RIGHT JOIN techniques
Utilizing Subqueries
- Subquery basics
- Subqueries within SELECT clauses
- Subqueries within WHERE clauses
Wrap-Up and Future Learning
Requirements
- Proficiency with fundamental computer operations
- Experience working with spreadsheets or tabular data
- No previous programming background is necessary
Target Audience
- Business analysts
- Data entry specialists
- Professionals newly entering the field of 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
