Course
Schedule
ACT
AJAX
ASP
ASP_NET
Access DB
Acrobat
ActiveDir
C# .NET Prog.
CSS (HTML)
Cisco Routers
Cisco Week
ColdFusion
Crystal Reports
DHTML
DP Design
DigCameras
Dreamweaver
Excel
Exchange
FileMaker
Fireworks
Flash
FrontPage
HTML
Illustrator
InDesign
Introductory
JSP
Java
JavaScript
Linux
Macromedia
Networks
ObjectOProg.
Office2007
Oracle
Outlook
PDF
PHP
PageMaker
Perl
Photoshop
PowerPoint
Premiere
Prog. Concpts
Project
Publisher
QuarkXPress
QuickBooks
SQL
SQL Optimize
SQL Reporting
SQLServerAdm
Scanners
Security
Sharepoint
Support
TCP/IP
UNIX
VB.NET
Visio
Visual Basic 6
W2003 Policy
W2003 Server
Win XP Admin.
Win XP Intro.
Wireless Net.
Word
XML
|
Optimizing with SQL Server 2005 |
| ||
 | |||
|
Special Topics in SQL Server 2005: Optimization (Prerequisite: Advanced Applications of SQL or equivalent experience.) Learn how to improve the performance of large SQL Server applications, avoid design pitfalls that can degrade performance, and optimize queries and stored procedures. This course shows you what performance means in different types of applications and helps you recognize performance tradeoffs. Learn to fine-tune indexes, optimize queries and stored procedures, and understand query plans. Additional topics include the relationship between locking and performance, using the SQL Server Optimizer, and the relationship between database design and performance. Create user-defined functions that improve the capability of stored procedures, and discover how to solve performance and fine-tuning problems. Fee: $239 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| P7895 | Wed., Feb. 28 | West County | Andrew Schwartz |
|
| |||
