Advanced SQL Programming and Optimization for Sybase SQL Server

PT2277
Summary
In this course, students will learn how SQL Server processes queries, including topics on optimization, index selection and other query-tuning-related topics. They will also learn to identify problematic statements and queries in application designs and before they are created on the server. Students will test different methods for fixing these statements and queries and discover how to estimate query performance, then use those estimates to identify query implementation issues. After completing this course, the student will be able to solve advanced SQL problems efficiently.
Prerequisites
Students should understand SQL syntax including SELECT, INSERT, UPDATE, DELETE. The Introduction to SQL for Sybase class is a recommended prerequisite.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for Programmers, System Administrators and Database Administrators.
Topics
  • Fundamentals of Query Processing
  • SQL Statement Processing
  • Join Processing & Optimization
  • Union Queries
  • Subquery Processing and Optimization
  • Views & Performance
  • Specific SQL Problems
  • Query Troubleshooting Tools & Approaches
  • Single-Table Optimization
  • Optimizing Stored Procedures
  • Presentation of Class Participants' Problem Queries
  • Cursors
  • Update Performance
  • Datatypes

Related Scheduled Courses