Sybase Series
Total Time: 28 hours

---

Sybase: Introduction to Sybase Time: 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 Time: 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 Time: 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

Available November 1999

Sybase: User Administration Time: 4 hours SYBC04 Sybase: User Administration shows users how to manage user accounts and groups in Sybase. Managing Logins Managing User Access and Aliases Managing Groups Assigning and Managing Roles Granting Permissions Revoking and Modifying Permissions Sybase: Programming with T-SQL Time: 4 hours SYBC05 Sybase: Programming with T-SQL introduces users to basic commands and functions in T-SQL and isql. 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 Time: 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 Time: 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

---