Get in Touch
 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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories