Training Course:tuning and optimizing queries using microsoft sql server 2005 (Certificate)School/Trainer:New Horizons Singapore
Singapore, Singapore
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.
Please go to the school's official website for training price and schedule:
http://www.newhorizons.com/
Phone:+65 6822 8282
School Address:
298 Tiong Bahru Road
Level 18 Central Plaza
Singapore 168730
Jobs & Resumes: Singapore
Houses & Roommates: Singapore
Travel Agencies: Singapore
Search other schools for tuning and optimizing queries using microsoft sql server 2005 training resources.
Other training courses offered by New Horizons Singapore:
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:
If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed. |
|
| 
