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
Getting Started with SQL
- Defining SQL
- Concepts of relational databases
- Overview of database engines and utilities
Essential Data Extraction
- Utilizing SELECT commands
- Applying filters via WHERE
- Arranging results with ORDER BY
Managing Columns and Rows
- Applying DISTINCT
- Assigning column aliases
- Restricting result sets
Advanced Filtering and Comparisons
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical conditions (AND, OR, NOT)
Data Aggregation and Grouping
- Functions: COUNT, SUM, AVG, MIN, MAX
- The GROUP BY directive
- The HAVING directive
Foundations of Table Joins
- Primary and foreign key concepts
- INNER JOIN operations
- LEFT and RIGHT JOIN operations
Leveraging Subqueries
- Introduction to subqueries
- Nesting subqueries in SELECT
- Nesting subqueries in WHERE
Recap and Future Pathways
Requirements
- Proficiency in standard computer usage
- Comfort with spreadsheet or tabular data formats
- No previous coding background is necessary
Target Learners
- Business analysts
- Data management specialists
- Individuals new to database operations
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
