SQL Server Performance and Tuning for Data Warehouses
Duration: 5 Days
This course will provide students with a good understanding of SQL Server Architecture and Query Performance so that applications and their supporting data warehouse environment can be tuned for optimal performance. It will also help students understand how to size, plan, monitor and tune a SQL Server application for either a OLTP or OLAP environment. Everything from Operating System & SQL Server service tuning through to query and index tuning will be covered.
Topics Covered In This Course
Performance & Tuning
SQL Server Internals
SQL Server Architecture
Planning A SQL Server Database Application
System Performance & Tuning
Optimal Database Design
Tuning SQL Statements
Database Application Tuning
Tuning SQL Server Services & Tasks
Analysis Services Specifics
What You Can Expect
At the end of this course, students will be able to:
Who Should Take This Course
This course is designed for senior database analysts, developers or database administrators.
Students should have extensive experience with SQL Server 2005 or later and should have a knowledge level equivalent to that provided by the Data Warehouse overview and Dimensional Modeling.
Instructor led with 50% lecture and 50% lab.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]