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
Introduction to SQL
- What constitutes SQL?
- Comprehending relational databases
- Database engines and utilities
Essential Data Retrieval
- SELECT commands
- Filtering using WHERE
- Sorting via ORDER BY
Managing Columns and Rows
- Applying DISTINCT
- Column aliases
- Constraining results
Filtering and Comparison
- Comparison operators
- BETWEEN, IN, LIKE
- Logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY directive
- HAVING directive
Basics of Table Joins
- Understanding primary and foreign keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Utilizing Subqueries
- Overview of subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Conclusion and Future Steps
Requirements
- A grasp of basic computer operations
- Acquaintance with utilizing spreadsheets or tabular data
- No previous programming 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
