| Length:
1 Day |
|
Prerequisites:
None |
Key
Benefits:
- A
Good One Day Overview for Managers
Eases the Student Into SQL
A
Recommended Prerequisite to Most Introductory
Courses on Adaptive Server
|
Other
Features:
-
Easy to Couple This Course with the Intermediate
Course in the Same Week
Lab Work Book and Reference Guide
Courseware written by Highly Acclaimed Authors
Instructors with Real-World Experience
|
|
Overview:
SQL is
the standard language in use 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, system
administrators, and database administrators. The course
provides an introduction to querying relational
databases, focusing primarily on the SELECT statement,
its syntax, and the use of joins. |
Topics
Covered:
- Structured
Query Language
Why SQL? The Relational Model and RDBMS, Queries and
Results
Subqueries
Using Subqueries, Statements Requiring Subqueries,
Using The Where and Having Clause
Union
Combining Result Sets With SQL Union
Selecting Rows
With Where
Where Conditions With Equals, Between and Not
Between, In and Not In, Like Wildcard Characters,
Null Values
Joins
Understanding The Join, Recipe For Joining Tables,
Notes On Joining Tables, Table Aliases, Joining
Several Tables, Outer Joins
Aggregates
Functions
Using
Aggregate Functions, Distinct And Count(*).,
Aggregates With Null. Subtotaling With Group By,
Compute and Compute By
The Select
Statement
Tables, Rows and Columns, Sending Queries, Reading
Results. Using Distinct, Controlling Headings With
Column Aliases,
Formatting SQL Statements, Order by
- Modifying Data
With SQL
Select Into, Insert, Update, Delete
|
|
|
|
