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
Overview of SQL
- Defining SQL
- Exploring relational database structures
- Common database engines and utilities
Foundational Data Extraction
- Employing SELECT commands
- Refining data using WHERE
- Ordering output via ORDER BY
Managing Columns and Records
- Applying DISTINCT
- Creating column aliases
- Restricting output volume
Advanced Filtering and Comparison
- Utilizing comparison operators
- Using BETWEEN, IN, and LIKE
- Applying logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Functions like COUNT, SUM, AVG, MIN, MAX
- Using the GROUP BY directive
- Applying the HAVING directive
Essentials of Table Joins
- Concepts of primary and foreign keys
- Implementing INNER JOIN
- Understanding LEFT JOIN and RIGHT JOIN
Introduction to Subqueries
- Foundations of subqueries
- Integrating subqueries within SELECT
- Utilizing subqueries inside WHERE
Review and Future Directions
Requirements
- Proficiency in standard computer operations
- Experience with spreadsheets or tabular information
- No previous coding background is necessary
Intended Learners
- Business analysts
- Specialists in 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
