| Title | Description | Duration | Outline |
|---|
|
Introduction To Sybase
|
Presents the basics of Sybase Adaptive Server
and its SQL programming language including
the use of stored procedures, cursors, and triggers.
Level: Introduction
|
3 Days
| |
|
Introduction To Sybase ASE 15
|
Learn to create tables and manipulate data,
tables and other database objects
using ANSI-standard SQL and Sybases Transact-SQL extensions,
and gain hands-on experience using Adaptive Server databases.
You will also learn the special features and functions of the Adaptive Server,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use good programming techniques
and develop strategies for writing efficient applications.
Level: Introduction
|
5 Days
| |
|
Introduction To Sybase Transact-SQL
|
Introduces Sybase Transact-SQL, the language used to interact with Sybase Adaptive Server.
Level: Introduction
|
1-2 Days
| |
|
Relational Database Design
|
This course is one common starting point for the entire database curriculum.
The objective of this course is to consider the logical design of relational
databases using a methodology known as semantic data modeling and related
practical techniques.
Level: Introduction
|
2 or 3 Days
| |
|
Structured Query Language (SQL) Using Sybase
|
Provides an introduction to all standard SQL statements and constructs.
Treatment of SQL is platform neutral, but will be delivered in the
Sybase environment. Coverage of Sybase ASE provides an introduction
to Transact-SQL, Transaction Managment, Stored Procedures, and Triggers.
Delivery format is a combination of Lectures and Labs.
Level: Introduction
|
2 Days
| |
|
Introduction to IBM DB2 for Sybase Developers
|
Provides the student that has prior SQL or Sybase ASE experience
with the necessary basic skills
and fundamental knowledge of IBM DB2 UDB.
It includes information on the overall architecture of DB2 UDB,
basic to advanced DB2 UDB SQL syntax,
creating and using SQL Stored Procedures,
and an overview of basic administrative tasks
including creation of databases, tables, views, indexes,
the extraction and insertion of data, security,
and backup and restore.
Level: Intermediate
|
3-4 Days
| |
|
Sybase System and Database Administration For ASE 15
|
Through a combination of lectures and hands-on labs,
you will identify the major tasks of Sybase system and database administration.
You will practice these tasks using your own Adaptive Servers (12.5)
in a safe and controlled environment.
Emphasis is given to resource management (memory, disk, and CPU)
with a goal of creating a reliable Adaptive Server environment.
The course also presents fundamental monitoring and troubleshooting methods,
as well as details about the servers locking schemes
and system and user-defined roles.
Level: Intermediate
|
5 Days
| |
|
Sybase Administrators Performance and Tuning for ASE 15
|
This course teaches database administrators
how to tune an Adaptive Server for optimal performance.
It explores Adaptive Server architecture in depth,
and includes sections on designing databases for performance,
managing Adaptive Server system resources (CPUs, disks, I/O),
choosing appropriate locking schemes, optimizer statistics,
SMP features, relevant data structures, and parallel processing.
Level: Advanced
|
5 Days
| |
|
Sybase Advanced Transact-SQL for ASE 15
|
In this course you will learn
valuable tips, techniques and topics
beyond what was encountered in the Introduction to ASE 12.5.1
course to help solve and prevent common problems.
This course also emphasizes good coding practices,
report formatting, advanced functions, characteristic functions,
applied case logic, and bcp (bulkcopy),
as well as generalized methods for solving specific information management problems.
Level: Advanced
|
4 Days
| |
