Course Locations
Anaheim, CA
Atlanta, GA
Austin, TX
Baltimore, MD
Burbank, CA
Calgary, AB
Charleston, SC
Charlotte, NC
Chicago, IL
Columbia, MD
Columbus, OH
Dallas-Ft Worth, TX
Denver, CO
Detroit, MI
Edison, NJ
El Paso, TX
Framingham, MA
Houston, TX
Kansas City, MO
Los Angeles, CA
Minneapolis, MN
New York, NY
Oakbrook, IL
Ottawa, ON
Pittsburgh, PA
Toronto, ON
Virtual Classroom
Popular Courses
Project Management, IT Service Management, .NET, SAS, Rexx, ASP, JavaScript, HTML, XML, ColdFusion, Visual Basic, COBOL, Assembler, Java, J2EE, Java Wireless, WebSphere, WebLogic, UNIX, LINUX, AIX, Solaris, z/OS, OS/390, CICS, IMS, VSAM, Easytrieve, AS/400, Oracle, BusinessObjects, SQL, DB2, Crystal Reports
Browse Courses
 |
 |
 |
 |
 |
 | Request in your area. |
 | Add course to watch list. |
 | View full course outline. |
 | Need more information? |
Course Schedule: | |
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: May 19, 2013
