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.
Duration 14 hours
Course Outline
Introduction to Structured Query Language (SQL)
- Definition and purpose of SQL
- Foundations of relational database systems
- Database management engines and associated toolsets
Foundational Data Retrieval Procedures
- Composition of SELECT queries
- Applying filters using the WHERE clause
- Sorting output via the ORDER BY clause
Managing Data Columns and Rows
- Eliminating duplicates with DISTINCT
- Assigning column aliases
- Restricting result set size
Advanced Filtering and Comparison Logic
- Application of comparison operators
- Utilizing BETWEEN, IN, and LIKE constructs
- Combining conditions with logical operators (AND, OR, NOT)
Data Aggregation and Grouping Techniques
- Implementing COUNT, SUM, AVG, MIN, and MAX functions
- Structuring output with the GROUP BY clause
- Refining groups using the HAVING clause
Introduction to Table Joining Operations
- Role of primary and foreign keys in data integrity
- Executing INNER JOIN operations
- Performing LEFT and RIGHT JOINs
Application of Nested Queries
- Conceptual overview of subqueries
- Integrating subqueries within SELECT statements
- Incorporating subqueries within WHERE clauses
Conclusions and Recommended Progression
Requirements
- Proficiency in fundamental computer operations
- Familiarity with spreadsheet applications or tabular data formats
- No prior experience in programming languages is required
Target Audience
- Business analysts
- Data entry specialists
- Personnel newly introduced to database management
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
