Introduction
to SQL
Length: 1 Day
Prerequisites:
None
OverviewSQL 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:
Learn The Language of SQL, learn how to write SQL queries.
This course also provides a solid background for the next
class either "Introduction to Sybase" or
Introduction
to "Microsoft SQL Server."
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
- Subtotalling 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
