SUMMARY:   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. 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. 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. DURATION:   This course is presented as a 5 day class. The first day of the class will be devoted to strengthening the participants understanding of Structured Query Language (SQL)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. APPROACH:   Instructor-Led, Hands-on. Students will be presented with numerous in class lab assignments, that will be supervised by the course instructor, as a means to reinforce the topics presented in the lecture sections of the class. 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. COURSE CONTENT:   Relational Database Concepts Introductory SQL Programming Database Creation Facilities Defining Tables System Datatypes User Defined Datatypes Creating Rules Creating Defaults Modifying Tables Primary, Foreign and Common Key Processing Creating Indexes Review of Standard SQL Statements Joins / Subqueries Aggregate Functions Transact-SQL Enhancements to Standard SQL Processing String Operations Data Conversions Datetime Processing Mathematical Functions Control Break Processing - COMPUTE Order By and Group By Commands The Select Into Command Creating Temporary Tables SQL INSERT / UPDATE / DELETE Statements Database Access Facilities Creating and Using Views Batch processing Local Variable Global Variable Transact-SQL Control of Flow Statements IF....ELSE BEGIN...END CASE WHILE.... GOTO RETURN WAITFOR PRINT RAISERROR Stored Procedures Creating Executing Parameters Returning Values Recompiling Stored Procedures Referential Integrity Creating Triggers Sample Triggers Transaction Processing Begin Transaction Save Transaction Rollback Transaction Commit Transaction   MT/07