Advanced SQL and Optimization for Sybase

    

Summary:
Attendees will learn how Adaptive Server processes queries. This class covers how to identify problematic statements and queries in an application design before they are implemented saving time and money. Students will estimate query performance on paper, and use those estimates to identify implementation issues with queries.

Duration:
4 Days/Lecture & Lab

Audience:
This course is designed for DBAs, System Administrators, and Client Application Developers.

Topics:

• Fundamentals of Query Processing
• Updates
• Union Queries
• BLOBs
• Multi-Table Queries
• Single-Table Optimization
• Subqueries
• Stored Procedures
• Views
• Query Troubleshooting Tools and Approaches
• Specific SQL Problems, Solutions, & Issues
• Cursors
• SQL Statement Processing
• NULL
• Datatype Conversion and Conflicts
• Join Processing

Prerequisites:
Students need to know the following SQL syntax: SELECT, INSERT, UPDATE, DELETE. It is recommended that students take an Introduction to Adaptive Server course.

Last Update: February 11, 2012