SQL Level 1
CTU-SQLL1-C

 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.

Prerequisites

  • 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

Introduction

  • 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
    concatenation
  • Case logic, using simple and searched variations

Updating

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

Joins

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

Subqueries and Unions

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

Summarization

  • 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 



Sections

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