Sybase: Using SQL Server

Synopsis
Sybase: Using SQL Server introduces users to SQL Server and how to use it to create manage and access database information.

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

Time
5 hours

Product Code: SYBC02

After completing Sybase: Using SQL Server the user should be able to:

Explain the basic features of SQL Server

Describe the major functions of SQL and T-SQL

Describe the security features and roles of SQL Server

Perform database queries with isql

Manage database tables

Update and maintain databases

SQL Server Overview
Introduction to the SQL Server

SQL Server architecture

Task management

SQL Server Functions
Multiple-user connections

Housekeeping

Query optimizer

Recovery services

SQL Server Features
Database components

Database and table types

Logging and caching

T-SQL and Database Integrity
T-SQL features

Enforcing data integrity

Maintaining referential integrity

Triggers Partitions and Security
Triggers

Locking

Partitions

Security

Using isql and Performing Queries
Getting started

Database querying

Viewing Managing and Creating Tables
Using views

Creating and maintaining tables

Maintaining Databases
Updating database tables

Ensuring data integrity

Referential integrity

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.