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 the role of SQL
- Exploring relational database concepts
- Overview of database engines and utilities
Retrieving Core Data
- Applying SELECT commands
- Refining results using WHERE
- Arranging output with ORDER BY
Managing Columns and Rows
- Removing duplicates with DISTINCT
- Assigning column aliases
- Restricting the number of results
Advanced Filtering and Comparisons
- Employing comparison operators
- Utilizing BETWEEN, IN, and LIKE
- Combining conditions with AND, OR, and NOT
Summarizing and Grouping Information
- Working with COUNT, SUM, AVG, MIN, and MAX
- Structuring data with GROUP BY
- Filtering groups using HAVING
Connecting Tables
- Grasping primary and foreign key relationships
- Implementing INNER JOINs
- Exploring LEFT and RIGHT JOINs
Leveraging Subqueries
- Basics of subquery construction
- Integrating subqueries into SELECT statements
- Applying subqueries within WHERE clauses
Recap and Future Directions
Requirements
- General proficiency with standard computer operations
- Basic comfort with spreadsheets or structured tabular data
- No previous coding background is necessary
Intended Participants
- Business analysts
- Professionals focused on data entry
- Individuals beginning their journey with database technologies
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
