sybase online training course tutorials

See How It Works

This online course includes tutorials for:	Time Needed
Introduction to Sybase	3 hours
Using SQL Server	5 hours
System Administration	4 hours
User Administration	2 hours
Programming with T SQL	3 hours
Querying Databases with T SQL	3 hours
T SQL Commands	3 hours
Estimated time needed to complete entire course	23 hours

Receive your login ID to take the training courses online, as many times as you wish, for 1 year. Click here for group orders.

Benefits

Unlimited access for 1 year
Learn anytime, anywhere
You control the pace
Start & stop wherever you want
No books to read
No software needed
Value Packs include Free online tech support
Double guarantee

100% Money back guarantee
One time payment No monthly fee
Use the course index for review anytime
Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. Prices shown are per user.

What You will Learn

This online training course is designed to introduce database administrators to using and managing Sybase System 11. It covers an overview of Sybase SQL Server, the client/server system model, and the tools and components of Sybase System 11. It discusses using SQL Server to create, manage, and access database information, and the tasks and commands of a system administrator. Additional topics covered in this online training course include management of user accounts and groups, granting and revoking permissions, basic T SQL programming commands and functions, and using T SQL commands to create database queries, manipulate data, join queries, create subqueries, and insert and modify data.

Introduction to Sybase

Compare characteristics of host and client/server systems
Explain the function of key Sybase components, tools, and utilities

Identify features and advantages of the Sybase client/server system architecture
Describe how Sybase System 11 accommodates non Sybase applications

Using SQL Server

Explain the basic features of SQL Server
Describe the major functions of SQL and T SQL
Perform database queries with isql

Describe the security features and roles of SQL Server
Manage database tables
Update and maintain databases

System Administration

Explain the role of a system administrator
Use system procedures for database administration

Manage databases
Manage segments

User Administration

Create and manage user accounts
Control user access and aliases
Create and manage groups

Create and manage roles
Grant and revoke permissions

Programming with T SQL

Identify the basic features of T SQL and isql
Create, alter, and drop tables
Specify integrity constraints to protect databases

Create integrity rules and defaults
Create and manage views
Create and manage indexes

Querying Databases with T SQL

Create queries
Use functions in queries
Modify query results

Order and group query results
Use queries through views
Combine query results

Sybase Join over 1 million people who learn online, with these complete interactive computer training courses.

Sybase
Join over 1 million people who learn online, with these complete interactive computer training courses.