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
Foundations of SQL
- Defining SQL
- Exploring relational databases
- Key database engines and utilities
Essential Data Extraction
- The SELECT command
- Data filtering via WHERE
- Ordering results with ORDER BY
Managing Columns and Records
- Applying DISTINCT
- Assigning column aliases
- Restricting the number of returned rows
Advanced Filtering and Logic
- Using comparison operators
- Implementing BETWEEN, IN, and LIKE
- Combining conditions with logical operators (AND, OR, NOT)
Summarizing and Grouping Information
- Utilizing COUNT, SUM, AVG, MIN, and MAX
- Structuring data with GROUP BY
- Filtering groups using HAVING
Basics of Table Integration
- Identifying primary and foreign keys
- Applying INNER JOIN
- Using LEFT JOIN and RIGHT JOIN
Implementing Subqueries
- Overview of subqueries
- Embedding subqueries in SELECT clauses
- Integrating subqueries in WHERE clauses
Conclusion and Future Learning
Requirements
- Proficiency with fundamental computer operations
- Experience working with spreadsheets or tabular formats
- Zero prior coding knowledge is necessary
Intended Learners
- Business analysts
- Professionals handling 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
