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
- Definition and purpose of SQL
- Concepts behind relational databases
- Overview of database engines and tools
Foundational Data Retrieval
- Implementing SELECT statements
- Applying filters using WHERE
- Ordering results with ORDER BY
Managing Columns and Rows
- Utilizing DISTINCT to remove duplicates
- Creating column aliases
- Restricting result sets
Advanced Filtering and Comparisons
- Using standard comparison operators
- Applying BETWEEN, IN, and LIKE
- Combining conditions with logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Employing COUNT, SUM, AVG, MIN, and MAX
- Structuring groups with GROUP BY
- Filtering groups using the HAVING clause
Introduction to Table Joins
- Distinguishing between primary and foreign keys
- Executing INNER JOIN operations
- Understanding LEFT and RIGHT JOINs
Exploring Subqueries
- Overview of subquery concepts
- Incorporating subqueries within SELECT statements
- Using subqueries in WHERE clauses
Recap and Recommended Next Steps
Requirements
- Familiarity with basic computer operations.
- Experience working with spreadsheets or tabular data.
- No prior programming background is necessary.
Target Audience
- Business analysts.
- Data entry specialists.
- Professionals 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
