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
- Comprehending relational database structures
- Overview of database engines and associated tools
Essential Data Retrieval
- Constructing SELECT statements
- Applying filters using the WHERE clause
- Ordering results with ORDER BY
Managing Columns and Rows
- Eliminating duplicates with DISTINCT
- Assigning column aliases
- Restricting the number of returned rows
Advanced Filtering and Comparisons
- Utilizing standard comparison operators
- Applying BETWEEN, IN, and LIKE conditions
- Combining conditions with logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Using functions like COUNT, SUM, AVG, MIN, and MAX
- Grouping records with the GROUP BY clause
- Filtering groups using the HAVING clause
Introduction to Table Joins
- Explaining primary and foreign key relationships
- Implementing INNER JOINs
- Using LEFT JOINs and RIGHT JOINs
Introduction to Subqueries
- Concepts behind nested queries
- Placing subqueries within SELECT statements
- Incorporating subqueries into WHERE clauses
Wrap-Up and Recommended Next Steps
Requirements
- Proficiency in basic computer operations
- Experience working with spreadsheets or tabular formats
- No previous 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
