Course Tuning and Optimizing Queries Using Microsoft SQL Server

Duration (days): 2
Price (CZK): 9000

Tuning and Optimizing Queries Using Microsoft SQL Server topics:

• 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.

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs