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
- Grasping relational database concepts
- Common database engines and utilities
Initial Data Extraction
- The SELECT command
- Filtering data using WHERE
- Ordering results with ORDER BY
Managing Columns and Rows
- Applying DISTINCT
- Assigning column aliases
- Restricting result sets
Data Filtering and Comparisons
- Comparative operators
- Using BETWEEN, IN, and LIKE
- Logical connectors (AND, OR, NOT)
Data Aggregation and Grouping
- COUNT, SUM, AVG, MIN, and MAX
- The GROUP BY directive
- The HAVING clause
Fundamentals of Table Joins
- Key concepts: Primary and Foreign
- INNER JOIN operations
- LEFT JOIN and RIGHT JOIN techniques
Implementing Subqueries
- Introductory concepts for subqueries
- Subqueries within SELECT statements
- Subqueries within WHERE clauses
Wrap-up and Future Learning
Requirements
- Basic proficiency with standard computer operations
- Experience with spreadsheets or tabular data formats
- No previous coding background is necessary
Target Audience
- Business analysts
- Data entry specialists
- 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
