Sybase Training

Summary:

This online training series 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 series 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.

This Sybase online training series provides 23 hours of self-paced courseware. This web-based training provides 1 year of unlimited access to all of the following lessons:

1 . Introduction to Sybase
2 . Using SQL Server
3 . System Administration
4 . User Administration
5 . Programming with T-SQL
6 . Querying Databases with T-SQL
7 . T-SQL Commands

Lesson Detail:

Introduction to Sybase
This course provides an overview to Sybase SQL Server, the client/server system model, and the tools and components of Sybase System 11.

Host versus Client/Server Systems
Sybase Introduction
SQL Server, Data Replication, and Open Architecture
System Management Tools and Servers

Using SQL Server
This course introduces users to SQL Server and how to use it to create, manage, and access database information.

SQL Server Overview
SQL Server Functions
SQL Server Features
T-SQL and Database Integrity
Triggers, Partitions, and Security
Using isql and Performing Queries
Viewing, Managing, and Creating Tables
Maintaining Databases

System Administration
This course provides an overview of the tasks and commands of a system administrator.

The Role of a System Administrator
Using System Procedures
Creating and Dropping Database Devices
Creating and Altering Databases
Managing Segments

User Administration
This course shows users how to manage user accounts and groups in Sybase.

Managing Server Logins
Managing User Access and Aliases
Managing Groups
Assigning and Managing Roles
Granting Permissions
Revoking and Modifying Permissions

Programming with T-SQL
This course introduces users to basic T-SQL commands and functions through the isql interface.

Using T-SQL and isql
Managing Tables
Defining Integrity Constraints
Creating Integrity Defaults and Rules
Using Views
Managing Indexes

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

Introduction to Queries
Using Functions in Queries
Manipulating Query Data
Ordering and Grouping Query Results
Combining Queries and View Queries

T-SQL Commands
This course explains how to join queries, create subqueries, and how to insert and modify data in Sybase.

Join Queries
Subqueries
Other Subquery Types
Inserting Data
Deleting and Modifying Data

Certification:
Sybase

Audience:
This online training series is for database administrators who want to learn about using and managing Sybase System 11.

Features:

Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
Exercises allow learners to practice in the actual application being studied.
A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
Search text enables learners to rapidly search all text within a course to easily retrieve information required.
Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
A skill assessment generates a customized learning path based on the results of a pre-test.
A glossary provides a reference for definitions of unfamiliar terms.
Bookmarking tracks the learner's progress in a course.
Exercises allow learners to practice in the actual application being studied.
A file containing the text of the exercises.
A glossary provides a reference for definitions of unfamiliar terms.
Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
A skill assessment generates a customized learning path based on the results of a pre-test.

Technical Requirements:

Internet connection
Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
Authorware and Macromedia Flash player recommended but not required.
JavaScript must be enabled.

What You Get:

You will receive Unlimited Access to all of the Sybase training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is a leader in providing online computer training tutorials and online education. We have customers use our online training courses in over 75 countries. StaffKit has been providing e-learning solutions for 10 years.

Web-Based Training Products:

Sybase Online Training Series

Only $59.95

You might also be interested in our Technical Package which includes all of the Sybase training courses listed above plus hundreds of hours of related online training courses