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
- Comprehending relational database models
- Overview of database management systems and utilities
Fundamentals of Data Extraction
- Executing SELECT commands
- Refining data using the WHERE clause
- Ordering results via ORDER BY
Manipulating Rows and Columns
- Applying the DISTINCT keyword
- Assigning column nicknames
- Restricting the number of output rows
Advanced Filtering and Logic
- Utilizing comparison symbols
- Applying BETWEEN, IN, and LIKE conditions
- Combining conditions with AND, OR, and NOT
Summarizing and Categorizing Data
- Working with COUNT, SUM, AVG, MIN, and MAX
- Employing the GROUP BY directive
- Filtering groups using the HAVING clause
Essentials of Table Joining
- Recognizing primary and foreign key relationships
- Implementing INNER JOIN operations
- Using LEFT JOIN and RIGHT JOIN techniques
Leveraging Subqueries
- Overview of nested queries
- Integrating subqueries within SELECT statements
- Incorporating subqueries into WHERE conditions
Recap and Future Learning
Requirements
- Proficiency with standard computer tasks
- Exposure to spreadsheet software or tabular data structures
- No previous coding knowledge is necessary
Intended Participants
- Business analysts
- Data processing specialists
- Individuals beginning their journey with 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
