tuning and optimizing queries using microsoft sql server 2005 (Certificate)

New Horizons Computer Learning Centers of Pakistan
Karachi, Pakistan

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

Course Description:

'' this workshop provides database developers working in enterprise environments using microsoft sql servert 2005 the knowledge and skills to evaluate and improve queries and query response times.

who should attend:
this course is intended for current professional database developers who have three or more years of on-the-job experience developing sql server database solutions in an enterprise environment.

at course completion:
after completing 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.

prerequisite(s) or equivalent knowledge:
2780 maintaining a microsoft sql server 2005 database
2779 implementing a microsoft sql server 2005 database
2778 writing queries using microsoft sql server 2008 transact-sql

prerequisite comments:
have a microsoft certified technology specialist: microsoft sql server 2005 credential or equivalent experience


outline: top
lesson 1: measuring database performance
importance of benchmarking
key measures for query performance: sysmon
key measures for query performance: profiler
guidelines for identifying locking and blocking

top
lesson 2: optimizing physical database design
performance optimization model
schema optimization strategy: keys
schema optimization strategy: responsible denormalization
schema optimization strategy: generalization


lesson 3: optimizing queries for performance
performance optimization model: queries
what is query logical flow?
considerations for using subqueries
guidelines for building efficient queries


lesson 4: refactoring cursors into queries
performance optimization model: query-set-based solutions
five steps to building a
strategies for refactoring cursors


lesson 5: optimizing an indexing strategy
performance optimization model: indexes
considerations for using indexes
best uses of the clustered index
best practices for non-clustered index design
how to document an indexing strategy

top
lesson 6: managing concurrency
performance optimization model: locking and blocking
multimedia - "how to use efficient queries to reduce locking and blocking"
strategies to reduce locking and blocking
...''

Elements of this syllabus are subject to change.

Phone:+(92) 021-4382352-3-4

School Address:

49-C, Block 6, P.E.C.H.S, Shahra-e-Faisal, Karachi, Pakistan.


Jobs & Resumes: Karachi
Houses & Roommates: Karachi
Travel Agencies: Karachi

Search other schools for tuning and optimizing queries using microsoft sql server 2005 training resources.

Complete .NET Security
C# 3.0 Programming in the .NET Framework
SQL Server 2005
Updating Your Database Development Skills to Microsoft SQL Server 2005
writing queries using microsoft sql server 2008 transact-sql
Maintaining a Microsoft SQL Server 2005 Database
Implementing a Microsoft SQL Server 2005 Database
Designing Microsoft SQL Server 2005 Server-Side Solutions
Designing Microsoft SQL Server 2005 Databases
designing the data tier for microsoft sql server 2005
Designing Microsoft SQL Server 2005 Infrastructure and Services
Designing Security for Microsoft SQL Server 2005
Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005
SQL Server 2008
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

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.