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
Foundations of Structured Query Language
- Definition and scope of SQL
- Concepts of relational database architecture
- Overview of database management systems and associated tools
Core Data Retrieval Operations
- Executing SELECT commands
- Applying data filters via WHERE clauses
- Sorting output using ORDER BY directives
Managing Data Elements
- Employing DISTINCT to eliminate duplicates
- Assigning column aliases for clarity
- Restricting the volume of returned records
Advanced Filtering and Logical Comparisons
- Utilization of comparison operators
- Application of BETWEEN, IN, and LIKE functions
- Integration of logical operators (AND, OR, NOT)
Data Aggregation and Grouping Techniques
- Use of statistical functions: COUNT, SUM, AVG, MIN, MAX
- Implementing the GROUP BY clause
- Filtering aggregated results with the HAVING clause
Table Join Fundamentals
- Interpreting primary and foreign key relationships
- Execution of INNER JOIN operations
- Implementation of LEFT JOIN and RIGHT JOIN strategies
Application of Subqueries
- Basic concepts and utility of subqueries
- Nesting subqueries within SELECT statements
- Nesting subqueries within WHERE clauses
Conclusion and Continuing Education Pathways
Requirements
- Basic proficiency in standard computer operations
- Experience working with spreadsheets or tabular data formats
- No prior programming background is necessary
Target Audience
- Business analysts supporting public sector functions
- Data entry specialists and administrative staff
- Personnel new to database management and reporting for government
Testimonials (3)
Need more self-learning and exercise to improve my skill
Alvin Wilta - PT LENTERA DANA NUSANTARA
Course - SQL Intermediate
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,