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
Introduction to SQL
- Defining SQL
- Concepts of relational databases
- Overview of database engines and associated tools
Foundational Data Extraction
- Utilizing SELECT statements
- Applying filters via WHERE clauses
- Sorting records using ORDER BY
Managing Columns and Rows
- Eliminating duplicates with DISTINCT
- Assigning column aliases
- Restricting output volume
Advanced Filtering and Logic
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Functions: COUNT, SUM, AVG, MIN, MAX
- Applying the GROUP BY clause
- Filtering groups with HAVING
Introduction to Table Joins
- Primary and foreign key relationships
- Executing INNER JOINs
- Working with LEFT and RIGHT JOINs
Implementing Subqueries
- Overview of subqueries
- Subqueries within SELECT statements
- Subqueries within WHERE clauses
Recap and Future Learning
Requirements
- Basic proficiency with computer operations
- Experience with spreadsheets or tabular data formats
- No prior programming background is necessary
Target Audience
- Business analysts
- Professionals involved in data entry
- Individuals newly embarking on database management
14 Hours
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
