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


 

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information