The SYBASE ADVANCED TRANSACT-SQL CODING TECHNIQUES course provides the students with a comprehensive explanation of the manner by which to write effective and highly efficient code for the SYBASE relational database management system. The course begins by teaching advantageous coding practices, and additionally discusses debugging techniques, sorting, applying conditional logic to data, combining data from multiple sources, statistical manipulation and formatting and presentation techniques. The class will cover, through detailed lectures and corresponding lab assignments, the advanced aspects of programming techniques of Transact-SQL not covered in the standard Introduction to SYBASE class. Upon completion of the course, the student will have a detailed knowledge of all aspects of advanced SYBASE coding, and will be able to write very efficient SYBASE programs.
Sybase Training Objectives:
Upon successful completion of this course, participants will be able to employ advanced coding techniques to solve common business programming functions. The students will readily be able to code highly efficient SQL applications.
Sybase Training Prerequisites:
The student should have attended the Introduction to SYBASE and Transact_SQL Class, or the student should have obtained the equivalent level of knowledge.
Sybase Training Audience:
This course is recommended for applications programmers, systems programmers, database administrators, application developers and all other related personnel who require an in depth understanding of the advanced SYBASE Transact-SQL coding techniques.
Course duration:
5 days
The first day of the class will be devoted to strengthening the participants' ability to write detailed and effective SYBASE code. The next four days build upon this basic knowledge to provide in depth lectures and labs in order to explain all of the techniques to utilize in order to create the most effective code.
Sybase Training Course outline
Section 1 - Functions
Isql topics
Presentation
Padding
Signs
Column Width
Sorting
Decode
Dates
Strings
Arithmetic
Lab exercise
Section 2 - Locking
Concepts
Schemes
Isolation Levels
Researching
Blocking
Readpast
Lock Table
Lab Exercise
Section 3 - CASE Coding
Syntax
Select examples
Updates
Frequency Tables
Pivoting
Folding
Lab Exercise
Section 4- Cursors
Cursor processing
Read cursors
Update cursors
Coding examples
Resources
Cursor information
Lab Exercise
Section 5 - Joins, subqueries, unions
Inner joins
Outer joins
Self joins
Table lookup
Cartesian products
Merge joins
Subqueries
Correlated subqueries
Exception reporting
Unions
Lab Exercise
Section 6 - Group by, Ranking
Group by coding
Cumulative totals
Numbering rows
Missing data
Ranking
Lab Exercise
Section 7 - Stored Procedures
Creating stored procedures
Executing stored procedures
Preparing to write a procedure
Testing
Transaction Modes
Error processing
Status codes
Stored procedure template
Lab exercise
Section 8 - Search arguments and optimizations
Sargs
Indexes
Plan processing
Variable
Parameters
Efficient Coding Techniques