Tuning and Optimizing Queries using Microsoft SQL Server 2005

ICI Systems, Inc.
Washington, District of Columbia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve queries and query response times. The workshop focuses on systematic identification and optimization of database factors that impact query performance.

Upon successful completion of this course, students will be able to:

Normalize databases.
Design a normalized database.
Optimize a database design by denormalizing.
Optimize data storage.
Manage concurrency
Manage concurrency by selecting the appropriate transaction isolation level.
Select a locking granularity level.
Optimize and tune queries for performance.
Optimize an indexing strategy.
Decide when cursors are appropriate.
Identify and resolve performance-limiting problems.
...''

Phone:202 887 0510

School Address:

ICI Systems, Inc.
1150 17th Street, NW, Suite 100
Washington, DC 20036


Jobs & Resumes: Washington
Houses & Roommates: Washington

IBM Lotus Domino 7 Application Development
Microsoft SQL Server 2005
Microsoft Exchange Server 2007
Sharepoint Portal Server 2003: Administration & Configuration
Sharepoint Services 2003: Administration & Configuration
Windows XP
Windows Vista
Windows Vista Application and Tools
MCSAs and MCSEs to Windows Server 2003
Microsoft Systems Management Server 2003
Implementing Microsoft Office SharePoint Server 2007
Access 2003
Excel 2003
Outlook 2003
PowerPoint 2003
Project 2003
E-Commerce Profitability: Online Merchandising Using Office FrontPage 2003
IIS 6.0
BizTalk Server 2004

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.