Skip to main content

Introduction to SQL

Back to Course Schedule
Date(s): Feb 15, 2022 - Feb 16, 2022
Time: 8:00AM - 4:30PM
Registration Fee: $379.00
Cancellation Date: Feb 08, 2022
Location: Online

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





Prerequisites

No Prerequisites Required.


Instructors

Rick High

Rick has over 35 years of experience in the Information Technology industry. He has designed, developed and implemented mainframe and personal workstation software projects for many large organizations throughout the country. His ability to relate to the users, IS and managerial personnel is crucial to successful project implementation and customer satisfaction.


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.



Back to Course Schedule