SQL Level 1

 Email this information to yourself or a friend

 Remind me of this course at a later date

Official Program Description

This course will introduce you to SQL (Structured Query Language), the standard language for requesting, modifying, and maintaining information in a relational database. You will learn the basics of SQL, such as the syntax (or rules) of using SQL and how to use SQL for database queries to answer business questions. You also will learn how to retrieve, group, filter, and summarize data; including information from multiple tables in a database.

Who Should Attend

This course is designed for business analysts, information specialists, and applicationdevelopers who need to write SQL data manipulation statements. You will learn ANSI/ISO standard SQL, with examples in SQL Server, Oracle, DB2 luw and z/os, MySQL, and Access, with emphasis on SQL Server and Oracle.


  • Experience using the editor in which the class is taught: TSO/ISPF in an IBM mainframe environment, any version of Microsoft Windows, or other editor
  • Experience with any programming or query language
  • Basic knowledge of databases

Attend and You Will Learn


  • Relational database concepts
  • Overview of SQL:  syntax, using editors
  • Getting acquainted with the course database

SELECT statements

  • Selecting columns and expressions, using aliases
  • Selecting from various objects, including tables and views
  • Using a Where clause to narrow the search:  comparisons
    including Between, In and Like
  • Sorting data with the Order By clause

Functions and Expressions

  • Functions for handling nulls, character strings, numbers
    and date/time values
  • Miscellaneous operators, including arithmetic and
  • Case logic, using simple and searched variations


  • Brief overview of transactions, commit, rollback, locking,
    column constraints, referential integrity, identity keys
  • Inserting rows
  • Updating and merging rows
  • Deleting


  • Inner joins:  traditional and ISO standard
  • Outer joins
  • Self-joins

Subqueries and Unions

  • Subqueries as alternatives to certain joins, using In and
  • Using Not In and Not Exists to find the difference of two
    sets of rows
  • Set operators, including Union, Union All, Intersect and


  • Aggregate functions, including Count, Max, Min, Sum, Avg
  • Using the Group By clause to summarize data
  • Filtering groups with the Having clause

 Applying SQL to Real-World Problems

  • Techniques for understanding and solving the problem: 
    re-wording, diagramming, using other people, using a
    systematic approach to writing SQL queries
  • Final group lab
  • Additional exercises for continued learningSQL Basics - 9/9/12 Page 3
    Hardware and software 


  SQL Level 1
CTU-SQLL1-C - 028
  2016 - TTS - Sep - Dec 2015   Status:  Available
In-Class:   Tue, Wed, Thu 9:00AM - 4:30PM
15 Dec 2015 to 17 Dec 2015
Class Schedule: 3 Sessions
Contact Hours: 18.0
Course Fee(s):
Gov't & Non-Profit Registration Fee non-credit    $999.00
Registration Fee non-credit    $1,099.00
Potential Discount(s):
  1.80 CEUs
Location:   On Campus