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
Where clause coding
- In / Like / Between
- Precedence
Primary and Foreign Keys
Join Operations
Demonstration Data Layout
Lab Exercise
Day Two
Database creation facilities
Database security features
Defining Tables
Examining table structures
Lab on table creations
Null processing
Table constraints
User defined datatypes
Index processing
Creating clustered and nonclustered indexes
Lab on creating indexes
Day Three
Outer joins
Ansi join processing
Aggregate Functions
Subqueries
Transact-SQL enhancements to standard SQL processing
Sybase functions
- String operations
- Data conversions
- Datetime processing
- Mathematical functions
Lab on functions
Order by statement
Group by statement
Having clause
Compute by processing
Compute processing
Lab on Order, Group and Compute
The select into command
Creating Temporary tables
SQL INSERT / UPDATE / DELETE statements
Lab exercise
Creating and using Views
Lab on Views
Day Four
Batch processing
Transact-SQL control of flow statements
- IF....ELSE
- BEGIN...END
- CASE
- IF EXISTS
- WHILE....
- GOTO
- RETURN
- WAITFOR
- PRINT
- RAISERROR
Lab on control of flow logic statements
Local variables
Global variables
Error processing
Dynamic statement execution
Lab on variables
Stored procedures
- Creating
- Executing
- Parameters
- Returning values
- Recompiling stored procedures
Lab on stored procedures
Day Five
Coding cursors for select processing
Coding update cursors
Transaction Processing
Begin Transaction
Save Transaction
Rollback Transaction
Commit Transaction
Lab on transactions
Referential Integrity
Creating Triggers
Sample Triggers
Trigger processing
Coding triggers
Examples of stored procedures and triggers
Lab on Triggers