Main Office:	800.631.0410
Sales Office:	800.533.3893

Reading and Deciphering Structured Query Language (SQL) for Auditors

Course: AUDSQL

Duration: 2 Days

Level: I

On our website at: http://www.verhoef-training.com/courses/AUDSQL.html

Course Summary

In this course, participants should learn to read and understand Structured Query Language (SQL), with a focus on data extractions from an automated system.

Topics Covered In This Course

SQL overview

SQL operating environment

SQL Objects

Executing SQL

SQL - Data Manipulation Language

Simple SQL Queries

SELECT

FROM

WHERE

ORDER BY

SQL Expressions

Joins

SQL Commands

Using Variables

MSS/10

What You Can Expect

At the end of this course, participants will be able to:

Construct an SQL statement.
Retrieve data with the SELECT statement.
Extract data using SQL expressions.
Prepare basic table joins and how they affect data extracts.
Understand a basic list of SQL commands.
Use variables in SQL commands.

Who Should Take This Course

This course is designed particularly to meet the needs of auditors, but will be valuable to anyone interested in gaining an understanding of SQL.

Training Style

Instructor led with hands on workshops.

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at: http://www.verhoef-training.com