Training Course:sql server 2005 - performance tuning and optimisationSchool/Trainer:ahana systems and solutions pvt ltd
bangalore, india
Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: chidanandamurthy
Course Description:
'' sql server 2005 - performance tuning and optimisation
measuring database performance
* importance of benchmarking
* key measures for query performance: sysmon
* key measures for query performance: profiler
* guidelines for identifying locking and blocking
optimizing physical database design
* performance optimization model
* schema optimization strategy: keys
* schema optimization strategy: responsible denormalization
* schema optimization strategy: generalization
optimizing queries for performance
* performance optimization model: queries
* what is query logical flow?
* considerations for using subqueries
* guidelines for building efficient queries
refactoring h?s into queries
* performance optimization model: query-set-based solutions
* five steps to building a h?
* strategies for refactoring h?s
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
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.ahana.co.in
http://www.ahana.co.in
Phone:91 80-26675891
School Address/Venue(s):
105/22, ist floor, 50 feet road
hanumanth nagar, near nirmala store bus stop
banashankari, bangalore �560050
Jobs & Resumes: bangalore
Houses & Roommates: bangalore
Travel Agencies: bangalore
Search other schools for sql server 2005 - performance tuning and optimisation training resources.
Other training courses offered by ahana systems and solutions pvt ltd:
oracle 10g database administration
oracle 10g rac
Oracle DataGaurd
Oracle 11i Application DBA
SQL Server 2005
SQL Server 2005: Analysis Services
SQL Server 2005: Integration Services
sql server 2005: reporting services
sql server 2005: developer
Perl Programming
BASH Shell Scripting and UNIX utilities
VMWARE ESX Administration
Linux System Administration (Based on RedHat)
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:
Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback. |
|
| 
