Sybase Training

Summary:

This 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 Serve

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

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

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

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

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

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

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

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

Certification:
Sybase

Audience:
This 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:

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 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

Web-Based Training Products:

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