Sybase: T-SQL Commands

Synopsis
Sybase: T-SQL Commands explains how to join queries create subqueries and how to insert and modify data in Sybase.

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

Time
3 hours

Product Code: SYBC07

After completing Sybase: T-SQL Commands the user should be able to:

Create join queries

Use subqueries

Insert data in databases

Modify and delete data

Join Queries
Inner joins

Outer joins

Self joins

Subqueries
What are subqueries?

Quantified predicate subqueries

Other Subquery Types
Returning dependent values

Testing for existence

Subqueries vs. join queries

Inserting Data
Inserting into specific columns

Inserting rows from another table

Inserting rows from the same table

Inserting into an identity column

Restricting data

Deleting and Modifying Data
Deleting data

Updating data

Manipulating data 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

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.