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
- Comprehending relational databases
- Overview of database engines and utilities
Retrieving Basic Data
- The SELECT statement
- Data filtering using WHERE
- Ordering results with ORDER BY
Managing Columns and Rows
- Applying DISTINCT
- Creating column aliases
- Restricting output results
Filtering and Data Comparison
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Aggregation and Data Grouping
- Functions: COUNT, SUM, AVG, MIN, MAX
- The GROUP BY clause
- The HAVING clause
Essentials of Table Joins
- Primary and foreign key concepts
- INNER JOIN
- LEFT and RIGHT JOINs
Leveraging Subqueries
- Introduction to subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Review and Future Directions
Requirements
- A basic command of standard computer operations
- Experience with spreadsheets or tabular data formats
- Programming experience is not a prerequisite
Target Audience
- Business analysts
- Professionals responsible for 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
