Sybase Training Overview:

The INTRODUCTION TO SYBASE AND THE TRANSACT-SQL PROGRAMMING FACILITIES course provides the students with a comprehensive explanation of all the capabilities of the Sybase relational database management system. The course begins by teaching basic structured query language facilities, and then presents greater detail of SQL coding techniques, and the numerous extensions to standard SQL that have been incorporated within the TRANSACT-SQL product. The class will cover, through detailed lecture and corresponding lab assignments, the programming aspects of Transact-SQL including; stored procedures, defaults, triggers, indexes, system functions, data control statements, Transact-SQL programming statements, and efficient transaction processing.

Upon completion of the course, the student will have a detailed knowledge of Sybase, Transact-SQL programming, and transaction management as well as being highly trained with the advanced SQL facilities that are available through the SYBASE product.

Sybase Training Objectives:

Upon successful completion of this course, participants will be able to create and process SYBASE tables and all related entities. The students will be able to efficiently access Transact-SQL data, and be capable of creating transactions, stored procedures, rules, defaults, functions and triggers. Students of this class will be able to use all the programming aspects available within Transact-SQL to successfully accomplish their required database accessing.

Sybase Training Prerequisites:

Having worked with another relational database management system will be of some advantage for a prospective student, but is not required. A background in programming will also be a useful prerequisite for this class.

Sybase Training Audience:

This course is recommended for applications programmers, systems programmers, database administrators, database designers and all other related personnel who require an in depth understanding of the SYBASE Transact-SQL facility.

Course duration:

5 days

The first day of the class will be devoted to strengthening the participants understanding of Structured Query Language facilities. The next four days build upon this basic knowledge to provide in depth lectures and labs in order to explain all of the functions of the Sybase relational database management system.

Sybase Training Course outline

Day One

Relational database concepts

Introductory SQL programming

Creating tables

System datatypes

Insert coding

Update coding

Delete coding

Coding a Select statement

• Syntax
• Distinct
• Order by