Upon completion of this course, the participant will be able to:
> Implement cleaner and more efficient code
> Format reports as desired
> Properly handle and screen on date/time data
> Use characteristic functions for conditional programming
> Use case logic for cleaner conditional code
> Avoid common cursor problems
> Build faster joins
> Use subqueries when appropriate
> Handle common numeric and statistical requirements
> Identify and code around common locking problems
> Design better stored procedures
> Take greater advantage of index-based access
> Use the optimizer for improved performance
> Properly monitor code performance
> Make full use of bcp for importing and exporting data