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
Course Outline
Introduction to SQL
- Defining SQL
- Concepts of relational databases
- Database engines and associated tools
Foundations of Data Retrieval
- SELECT commands
- Applying filters using WHERE
- Ordering results with ORDER BY
Managing Columns and Rows
- Utilizing DISTINCT
- Assigning column aliases
- Restricting result sets
Advanced Filtering and Comparisons
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- COUNT, SUM, AVG, MIN, MAX
- The GROUP BY clause
- The HAVING clause
Essentials of Table Joins
- Primary and foreign key relationships
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Implementing Subqueries
- Overview of subqueries
- Subqueries within SELECT statements
- Subqueries within WHERE clauses
Wrap-up and Future Learning
Requirements
- A grasp of fundamental computer navigation
- Experience with spreadsheets or tabular data structures
- No prior coding background is necessary
Intended Learners
- Business analysts
- Data entry specialists
- 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
