Introduction to SQL

Length: 1 Day
Prerequisites: None


Overview

SQL is the standard language in used by all major relational database vendors. This course provides an introduction to the version
of SQL, Transaction SQL used by Adaptive Server. It is intended for programmers, systems administrators, and database administrators.
The course provides and introduction to querying relational database, focuses on the SELECT statement, its syntax and
the use of joins.

Key Benefits:

• A Good One Day Overview for Managers
• This Class Eases The Student Into SQL
• A recommended Prerequisite to Most Introductory Courses on Sybase Adaptive Server &
  Microsoft SQL Server Databases



Outline


Chapter 1. Structured Query Language

•  Why SQL?
• The Relational Model and RDBMS, Queries and Results

Chapter 2. Subqueries

• Using Subqueries
• Statements Requiring Subqueries
• Using the Where and Having Clause

Chapter 3.  Union

• Combining Result Sets with SQL Union

Chapter 4. Selecting Rows with Where

• Where Conditions with Equals
• Between and Not Between
• In and Not In
• Like Wildcard Characters
• Null Values

Chapter 5. Joins

• Understanding The Join
• Recipe For Joining Tables
• Notes On Joining Tables
• Table Aliases
• Joining Several Tables
• Outer Joins

 

Chapter 6. Aggregate Functions

• Using Aggregate Functions
• Distinct and Count (*)
• Aggregates with Null
• Subtotaling with Group By
• Compute and Compute By

 Chapter 7.  The Select Statement

• Tables
• Rows and Columns
• Sending Queries
• Reading Results
• Using Distinct
• Controlling Headings with Column Aliases
• Formatting SQL Statements
• Order by

Chapter 8. Modifying Data with SQL

• Select Into
• Insert
• Update
• Delete

Back to Course Listing