Education Online - Career Education --- e-learning for Everyone.

 

Synopsis
Sybase: Querying Databases with T-SQL shows users how to create database queries and to manipulate the data received through queries.

Audience
This course is for database administrators who want to learn about using and managing Sybase System 11.

Time
3 hours

Product Code: SYBC06
After completing Sybase: Querying Databases with T-SQL the user should be able to:

Create queries
Use functions in queries
Modify query results
Order and group query results
Use queries through views
Combine query results

Introduction to Queries
Creating queries
Querying data using conditions

Using Functions in Queries
System functions
String manipulation functions
Date functions
Mathematical functions

Manipulating Query Data
Conversion functions
Summarizing data

Ordering and Grouping Query Results
Ordering results
Grouping results
Computing results

Combining Queries and View Queries
Combining query results
Querying through views

This course has the following features:

Exercises that allow users to practice in SQL Server
A file containing the text of the exercises
Simulations that allow users to practice course skills even if they don't have access to Sybase SQL Server
A glossary
A Skill Assessment


 
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.