Course Information
Introduction to SQL
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.
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 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.