Skip to main content

Introduction to SQL

Date(s): Jul 15, 2024 - Jul 16, 2024
Time: 8:00AM - 4:30PM
Registration Fee: $299.00
Cancellation Date: Jul 08, 2024
Location: Barbara Jordan Building Room 2.041
City: Austin

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: ALL
Category: Information Technology

Course Objectives

  • 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.


Basic computer literacy and editing skills.

Database skills not required.


Chuck McCullough

Chuck founded McCullough & Associates in 1991 to deliver software development skills to software development organizations in large companies. Clients include: Verizon, Tektronix, HP/Compaq, Samsung, Northern Telecom, DSC, Frito Lay, EDS, JC Penney’s, Brinker, Fidelity, Federal Reserve Bank, Legent Systems, General Electric, Compaq/Tandem, Mayo Clinic, Caterpillar, CI/WorldCom, Southwest Central Services, Cybertek, BlueCross, SW Airlines, AMR, PepsiCo, and others.

Technology areas include: C, C++, .Net, Java, TSQL, Object Oriented Analysis & Design, MFC, COM/DCOM/ActiveX, CORBA, Smalltalk. Strong practitioner of best practices, such as test-driven, iterative, patter-rich object-oriented application development.

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.

A self-service vending area with beverages and snacks can be found on the first floor of our building next to the DPS office. 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