Library 5 : Technical General

Sybase Series

Total Time: 28 hours

Sybase: Introduction to Sybase		4 hours	SYBC01
Sybase: Introduction to Sybase 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

Sybase: Using SQL Server		4 hours	SYBC02
Sybase: Using SQL Server 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

Sybase: System Administration		4 hours	SYBC03
Sybase: System Administration 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

Sybase: User Administration		4 hours	SYBC04
Sybase: User Administration 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

Sybase: Programming with T-SQL		4 hours	SYBC05
Sybase: Programming with T-SQL 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

Sybase: Querying Databases with T-SQL		4 hours	SYBC06
Sybase: Querying Databases with T-SQL 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

Sybase: T-SQL Commands		4 hours	SYBC07
Sybase: T-SQL Commands 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

Back

©2002 Purpletrain.Com Pte Ltd, Purpletrain.Com Logo and Informatics Holdings Ltd and the Informatics logo are registered trademarks of Informatics Holdings Ltd and Purpletrain.Com Pte Ltd. Informatics Holdings and Purpletrain.Com is a trademark herein used under license. All other brand names mentioned herein are used for identification purposes only and are trademarks of their respective owners.

This study guide and/or material is not sponsored by endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA™, CCDP™, CCNP™, CCIE™, CCSI™, the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc. in the United States and certain other countries. All other trademarks are trademarks of their respective owners.