Back to Search Results

Training Course Summary:

In this course you will learn an array of valuable tips, techniques and topics beyond what was encountered in the Fast Track to Adaptive Server Enterprise 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. Among new topics covered are a focus on knowledge transference, extensive try-its, and excessive content control.

Pre-Requisites:

Fast Track to Adaptive Server Enterprise or equivalent experience.

Who Should Attend:

SQL Developers
DBA's responsible for system-wide performance

Training Course Overview/Content:

Formatting Results
Dates & Functions
Characteristic Functions
Case Logic Cursors
Joins & Subqueries
Working with Numbers
Locking
Stored Procedure Basics
Planning and Building Stored Procedures
SARGs
Optimization
Measuring Performance
Working with BCP