Training Course:sql server 2005 - performance tuning and optimisationSchool/Trainer:ahana systems & solutions (p) ltd.
banglore, karnataka, india
Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: chidanandamurthy
Course Description:
'' mssql server 2005 performance tuning and optimisation
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:080-26675891
School Address/Venue(s):
ahana systems & solutions (p) ltd.
105/22, ist floor, 50 feet road
hanumanth nagar, near nirmala store bus stop
banashankari, bangalore ��?560050
Jobs & Resumes: banglore
Houses & Roommates: banglore
Search other schools for sql server 2005 - performance tuning and optimisation training resources.
Other training courses offered by ahana systems & solutions (p) ltd.:
SQL Server 2005
SQL Server 2005: Analysis Services
SQL Server 2005: Integration Services
SQL Server 2005: Reporting Services
sql server 2005: developer
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.
Facts:
We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day. |
|
| 
