|SQL Server Foundations - On Demand|
Presented by Allan Hirt and Ben DeBow
Are you new to SQL Server? Looking to brush up your skills? Thrust into a SQL Server DBA role or been asked to administer some databases? Are you only familiar with another RDBMS or a Windows administrator? Is your company implementing a SQL Server-based application and you are familiar only with another vendor’s RDBMS? This two-day, six-part series is designed for you.
|SQL Server Reporting Services for Developers and Power Users - On Demand|
Presented by Craig Pelkie
In this 5-part technical training course, students will get an introduction to SQL Server Reporting Services (SSRS). This course will show you how to use the development tools effectively, how to present and enhance data in a report, and how to create dynamic reports. Each session includes hands-on labs!
|Mastering SQL Server Reporting Services Expressions - On Demand|
Presented by Paul Turley
It’s fairly easy to create basic reports with no programming and only fundamental technical skills if you keep things simple, but if you have to build highly-functional reports, you need to know how to write and use expressions. With some essential expression skills, you can take your report designs to the next level and give your business powerful reporting and analytic capabilities.
|Virtualization Performance Tips for Your Database - On Demand|
Presented by Denny Cherry
Database virtualization is a powerful tool for IT departments and can help prevent server sprawl and even save money. In this new training course, you will learn whether or not virtualization is right for your database and how to get the most from your virtualized SQL Servers.
|Deep Dive into Business Intelligence in Excel 2013's PowerPivot and Power View - On Demand|
Presented by Stacia Misner
Excel 2013 includes built-in self-service business intelligence functionality that allows you to delve deeper into your data. You can use Excel to start analyzing data as a simple data model, and then progressively add more data from a variety of data sources to enrich your analysis. Using the PowerPivot add-in, you can fine-tune the structure of the model to better support exploration and enrich the model with calculations and key performance indicators.
|Essential Skills for DBAs - On Demand|
Presented by Andrew Kelly
In this new online training course, you'll learn the skills you need to plan and maintain a SQL Server instance to scale and preform as demand increases.
|Truth, Art, and the Zen of SQL Server Performance Tuning - On Demand|
Presented by Ben DeBow
Some say performance tuning SQL Server is an art; others say it’s a science. It’s a bit of both of those, but also more. Many factors determine how well (or poor) SQL Server will perform, and it starts well before any application database is installed into an instance.
|Intro to BI Power Suite - On Demand|
Presented by Tyler Chessman
In this set of sessions, you'll learn about all the Power BI components, how to configure Power BI for Office 365, and how to integrate with both cloud and on premise systems. You'll also take a look at some of the upcoming Power BI features expected to release in late 2014.
|Jumping Into SSAS Multidimensional - On Demand|
Presented by Stacia Misner and Denny Lee
This three-part online training course will help you understand how best to work with multidimensional cubes, the structure that the SSAS Multidimensional server uses to support analytical queries.
|Conquering SQL Server Replication - On Demand|
Presented by Robert Davis
Are you new to replication or do you consider replication to be a challenging beast? Even highly experienced DBAs try to steer away from replication. However, if you work in an enterprise-level environment, replication is hard to avoid. It fills several needs in the areas of scalability and availability is often the right tool for the job—yet many are still hesitant to implement it. After this class, you’ll be ready and able to implement any form of replication with confidence that you are in control.