Loading Course Schedule...
PT0710
Summary
In this course you will learn an array of valuable tips, techniques and topics beyond what was encountered in the Introduction to ASE 15.7 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.
Prerequisites
Before taking this course, students should take ProTech's Introduction to ASE 15.7 or equivalent experience
Duration
3 Days/Lecture & Lab
Audience
This course is designed for SQL Developers and DBA's responsible for system-wide performance.
Topics
Introduction to Good Code::Formatting::Dates and Times::Debugging Syntax and Efficiency::Function Techniques::Case Logic::Cross Tabulations::Advanced Joins::Subqueries::Temporary Tables::Derived Tables::Scrollable Cursor Techniques::Locking::Transaction Batches::Numeric and Statistical Processing::Key Assignment::Stored Procedure Improvements::Extended Procedures::Bulk Copy