SQL Server Performance and Tuning

The objective of this course is to provide senior database analysts, developers or database administrators with a good understanding of SQL Server Architecture and Query Performance so that applications and their supporting environment can be tuned for optimal performance. The course will provide delegates with the knowledge required to size, plan, monitor, tune and troubleshoot a SQL Server application for either a OLTP live environment or a OLAP data warehousing environment. Everything from Operating System and SQL Server service tuning through to query and index tuning will be covered. It is a hands on course with performance and analysis tools being put to use throughout. Delegates will learn how to capture and analyse performance data to enable troubleshooting of performance problems using tools such as Performance Monitor, SQL Profiler, Extended Events and Dynamic Management Views. They will learn how to interpret query execution plans to determine where the cause of bottlenecks lies and how to tune the queries for best performance. Covers SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014.

Introducing SQL Reporting Services (SSRS)

Reporting Services Installation & Architecture

Overview of Configuring SharePoint Integration

Basic Report Design

Report Layout & Formatting

Designing Data Access

Advanced Report Design

Chart Reports

Content Management

Native Mode Server Administration

Integrating Reports Into Custom Applications

Using Embedded & Referenced Code



Programming courses

Sql courses

Database courses