Skip to main content

Introduction to SQL

Back to Course Schedule
Date(s): Feb 17, 2022 - Feb 18, 2022
Time: 8:00AM - 4:30PM
Registration Fee: $379.00
Cancellation Date: Feb 10, 2022
Location: SAO COMPUTER TRAINING ROOM
City: Austin
Local Hotels:

Course Description

This course teaches students the basics of the Structured Query Language (SQL) Language in a fast paced and hands-on environment. The course begins with a discussion of relational concepts and terminology and quickly moves into a practical discussion of data retrieval and manipulation using SQL.


Potential CPE Credits: 16.0
Govt Hours: This class meets 16.0 hours of the 24-hour requirement for governmental CPE under Government Auditing Standards (yellow book), in most cases.
Technical Hours: This class meets 16.0 CPE credits of technical training in compliance with Texas Admin. Code Rule 523.102.

Instruction Type: Live
Experience Level:
Category: Auditing

Course Objectives

Upon completion of this course, students will be able to:

Understand the concepts of databases and SQL.

Write SQL queries that:

  • Use the SELECT and FROM statements.

  • Use the WHERE clause to select specific rows.

  • Use the LIKE keyword, wildcards, logical operators, and NULL testing.

  • Transform data using scalar functions, aggregate functions, and mathematical    operators.

  • Group data via the GROUP BY and HAVING clauses.

  • Sort the results.

  • Use multiple tables via join operations.

  • Use Oracle SQL Developer to execute SQL statements and review the results.

*A series of lab exercises will be used to reinforce the classroom education. 


Course Agenda

Relational Database Concepts

  • Database Management Systems

  • Relational Model of Data

  • Common Relational Terminology

Creating Tables

  • Column Definitions in a Table

  • Column Data Types

  • Lab Database Schema Review

Basic Data Retrieval

  • SQL Syntax

  • SELECT Statement

  • Computed Columns

  • WHERE Clause

Using SQL Developer

  • Starting SQL Developer

  • Customizing SQL Developer Preferences

  • Issuing SQL via SQL Developer

WHERE Clause Predicates

  • IN

  • BETWEEN

  • LIKE

Using Boolean Operators

Processing Null Values

SQL CASE Clause

Sorting Result Sets

Built-in Functions

  • The Difference Between Scalar and Aggregate Functions

  • Removing Null Values From a Result Set

  • CAST Function

  • Using Basic Numeric and String Functions

Date Processing 

  • Date Datatypes

  • Using Date Functions

  • Time Datatypes

  • Using Tine and Timestamp Functions

Aggregating Data

  • Using Aggregate Functions

  • GROUP BY Clause

  • HAVING Clause

Joining Tables

  • Introduction to the Join Operation

  • Join Syntax

  • Qualifying Ambiguous Column Names

  • Join Operations Involving More Than Two Tables

  • Compare and Contrast Inner vs. Outer Joins

  • Outer Join Syntax

  • ON Clause Extensions and Their Impact on Outer Joins

  • Self-Joins





Additional Information

TAC Rule 523.142(g) requires the CPE Sponsor to monitor individual attendance and assign the correct number of CPE credits. Participants will be asked to document their time of arrival and departure in compliance with this Rule. Additionally, attendance will be monitored throughout the day and CPE certificates will reflect actual attendance of each participant.

If you are making travel plans to come to Austin, we recommend making "refundable" air and hotel reservations or waiting until 14 days before the class to actually book your reservations. Courses are occasionally canceled or rescheduled due to low enrollment. We determine whether a course has enough participants 16 days prior to the course date. If we cancel or reschedule, we will email the participant and his or her billing contact no later than 14 days before the original class date.

The course coordinator will contact you with parking information. Handicapped parking is free at the meters around the downtown area.

Vending machines with Coca-Cola products and various snack items are available. There is also a refrigerator and microwave in our coffee bar area. Feel free to bring in your own drinks and food if you prefer.

You might want to bring a light sweater or jacket, as room temperatures vary.

To see answers to our Frequently Asked Questions, visit http://www.sao.texas.gov/training/faq.html.


Back to Course Schedule