Reading and Deciphering Structured Query Language (SQL) for Auditors

Course:  AUDSQL
Duration:  2 Days
Level:  I
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.

« Hide The Details
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.

« Hide The Details

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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com