Main Office: | 800.631.0410 | |
---|---|---|
Sales Office: | 800.533.3893 |
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.
At the end of this course, students will be able to:
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.
Code | Course Title | Duration | Level | |
---|---|---|---|---|
SSIS16 |
SQL Server 2016 Integration Services (SSIS) |
5 Days |
I |
Details |
SSASBI |
Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions |
5 Days |
I |
Details |
SSASMDX |
SQL Server Analysis Services with MDX |
5 Days |
II |
Details |
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.