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
Introduction to SQL
- Defining SQL
- Exploring relational databases
- Database engines and associated tools
Essential Data Retrieval
- SELECT commands
- Filtering via WHERE
- Sorting using ORDER BY
Managing Columns and Rows
- Applying DISTINCT
- Creating column aliases
- Restricting result sets
Advanced Filtering and Comparisons
- Comparison operators
- BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- COUNT, SUM, AVG, MIN, MAX
- The GROUP BY clause
- The HAVING clause
Fundamentals of Table Joins
- Primary and foreign keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Implementing Subqueries
- Overview of subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Recap and Further Learning
Requirements
- Proficiency in basic computer operations
- Experience with spreadsheets or tabular data formats
- No prior programming background necessary
Target Audience
- Business analysts
- Data entry specialists
- Individuals newly introduced to database management
Testimonials (2)
The SQL simulator designed by Philippe
Jean-Pierre ABRIAL - AGL
Course - SQL Fundamentals
Machine Translated
Small group, in-person for 3 days,
