SQL for Non-Technical Users - Online Training Course - CPDUK Accredited
SQL for Non-Technical Users - Online Training Course - CPDUK Accredited.
Welcome to The Mandatory Training Group's online SQL for Non-Technical Users training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
SQL for Non-Technical Users
Teacher - Peggy Ward
Learner - Jacki Flynn
This online SQL for Non-Technical Users training course will teach you how to write a basic SQL query from start to finish. You will learn to retrieve data from multiple tables, sort and filter your query results, and use simple calculations in this course.
Course content
This online SQL for Non-Technical Users training course includes the following:
- Unit 1: Getting started
- Unit 2: Single-table queries
- Unit 3: Multi-table queries
- Unit 4: Functions and subqueries.
Who is the course for?
This online SQL for Non-Technical Users training course is suitable for business users with little to no experience writing SQL queries who want to use SQL to pull information from their organisation’s databases.
Course aims
The aims of this SQL for Non-Technical Users e-learning course aims to:
- Teach you how to write a basic SQL query from start to finish.
- Equip you with the proper tools and techniques to manage and query data held in databases.
Learning objectives
On completion of this SQL for Non-Technical Users eLearning course, the learner will be able to:
- Define basic SQL terminology and list the seven types of clauses in an SQL statement.
- Write an SQL query that retrieves data from one table.
- Clean your query results by sorting, filtering, and adding column aliases.
- Use the WHERE clause to filter results based on comparisons to numbers and strings.
- Write an SQL query that retrieves data from multiple tables using inner joins and WHERE clause joins.
- Use outer joins to retrieve results where one of the tables does not have matching records.
- Use date functions to format dates in your results (DATEPART, DATENAME) and to calculate the difference between two dates (DATEDIFF).
- Concatenate columns using string functions (+, TRIM) and summarise a column using aggregate functions (SUM, AVG)
- Collect data across multiple records and group the results using the GROUP BY clause and filter based on grouped data using the HAVING clause.
- Use subqueries to retrieve more complex results that cannot be achieved with a single SQL query.
Learning outcomes
Once you have completed this online SQL for Non-Technical Users training course, the learner will be able to:
- Use the GROUP BY and HAVING clauses to retrieve and filter on summarised data.
- Retrieve data from one table or multiple tables
- Filter data with the WHERE clause
- Retrieve data from multiple tables
- List the seven types of clauses in an SQL statement.
- Sort and filter your query results
- Use simple calculations.
- Format dates and text
- Calculate sums and averages
- Create a simple query.
Download Full Course Description (PDF)
