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
- Exploring relational database structures
- Overview of database engines and utilities
Basic Data Extraction
- Writing SELECT queries
- Data filtering using WHERE
- Data ordering via ORDER BY
Handling Columns and Rows
- Applying DISTINCT
- Assigning column aliases
- Restricting result sets
Data Filtering and Comparison
- Utilizing comparison operators
- Using BETWEEN, IN, and LIKE clauses
- Employing logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Applying COUNT, SUM, AVG, MIN, MAX
- Using the GROUP BY clause
- Using the HAVING clause
Foundations of Table Joins
- Comprehending primary and foreign keys
- Executing INNER JOINs
- Executing LEFT JOINs and RIGHT JOINs
Leveraging Subqueries
- Overview of subqueries
- Nested subqueries within SELECT
- Nested subqueries within WHERE
Recap and Future Learning
Requirements
- Knowledge of fundamental computer operations
- Experience with spreadsheets or tabular data structures
- No previous coding background is necessary
Target Audience
- Business analysts
- Professionals handling data entry
- Individuals new to 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
