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 and its purpose.
- Concepts behind relational databases.
- Common database engines and utility tools.
Foundations of Data Retrieval
- Using SELECT statements.
- Applying WHERE clauses for filtering.
- Ordering results with ORDER BY.
Managing Columns and Rows
- Eliminating duplicates with DISTINCT.
- Assigning column aliases.
- Restricting the volume of returned results.
Advanced Filtering and Comparisons
- Utilizing comparison operators.
- Employing BETWEEN, IN, and LIKE keywords.
- Combining conditions with AND, OR, and NOT.
Aggregation and Data Grouping
- Using COUNT, SUM, AVG, MIN, and MAX functions.
- Structuring queries with the GROUP BY clause.
- Filtering grouped results using the HAVING clause.
Introduction to Table Joins
- Understanding primary and foreign keys.
- Executing INNER JOINs.
- Implementing LEFT and RIGHT JOINs.
Applying Subqueries
- Overview of subquery concepts.
- Nesting subqueries within SELECT clauses.
- Incorporating subqueries into WHERE clauses.
Conclusion and Further Learning
Requirements
- Basic proficiency with standard computer operations.
- Experience working with spreadsheets or tabular data formats.
- No previous programming background is necessary.
Target Audience
- Business analysts.
- Professionals involved in data entry.
- 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
