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
Overview of SQL Fundamentals
- Definition and purpose of SQL
- Principles of relational database management systems
- Database engines and associated utilities
Fundamentals of Data Retrieval
- Implementation of SELECT statements
- Data filtering using WHERE clauses
- Result ordering via ORDER BY
Managing Columns and Records
- Application of the DISTINCT operator
- Establishment of column aliases
- Restriction of result sets
Filtering Criteria and Comparison Operators
- Standard comparison operators
- Usage of BETWEEN, IN, and LIKE predicates
- Logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Aggregate functions: COUNT, SUM, AVG, MIN, MAX
- Organization using the GROUP BY clause
- Filtration of grouped data with the HAVING clause
Principles of Table Joining
- Concepts of primary and foreign keys
- Execution of INNER JOIN operations
- Application of LEFT JOIN and RIGHT JOIN
Implementation of Subqueries
- Overview of subquery functionality
- Utilization within SELECT statements
- Utilization within WHERE clauses
Executive Summary and Subsequent Training Steps
Requirements
- Proficiency in fundamental computer operations
- Competence in managing spreadsheets and tabular formats
- No prior coding background is necessary
Audience
- Business analysts
- Data entry professionals
- Anyone new to working with databases for government purposes
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
