|
SQL Azure
|
|
|
Introduction to SQL Azure
|
Explore the basic elements of a Windows Azure service by creating a GuestBook application that demonstrates many features including web and worker roles, blob storage, table storage, and queues.
|
|
SQL Azure Reporting
|
Learn how to build Reports on SQL Azure
|
|
Migrating to SQL Azure
|
Perform several migration techniques to upload data and migrate existing databases from SQL Server to a SQL Azure Database.
|
|
SQL Server Reporting Services
|
|
|
Authoring Reports using Bing Maps Integration with Report Builder 3.0
|
Build SharePoint 2010 integrated reports with MAP functionality using Report Builder 3.0.
|
|
Developing and Consuming Report Libraries in SQL Server 2008 R2 Reporting Services
|
Create and use component libraries in SQL Server 2008 R2 Reporting Services.
|
|
Using Sparklines, Databars and Indicators in Report Builder 3.0
|
Experience new visualization techniques using Sparklines, Databars and Indicators.
|
|
Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
|
This Hands On Lab explores improvements in spatial data visualization in SQL Server 2008 R2 Reporting Services.
|
|
PowerPivot
|
|
|
Introduction to PowerPivot
|
Perform several exercises to achieve a better understanding of PowerPivot functionality add-on to Office 2010 and how to successfully work with self-servicing BI solutions.
|
|
Creating Excel 2010 PowerPivot Reports
|
Create reports using Excel 2010 PivotTable and PivotChart features with data from PowerPivot.
|
|
Defining DAX Calculations with Excel 2010 PowerPivot
|
Use data analysis expressions (DAX) to create calculated columns and multi-dimensional calculations using Excel 2010 PowerPivot.
|
|
Managing Excel 2010 PowerPivot Solutions in SharePoint 2010
|
Manage Excel 2010 PowerPivot solutions that have been deployed to a SharePoint 2010 server.
|
|
BareMetal
|
|
|
BareMetal - Business Intelligence - Part 1
|
BareMetal is all about building out your own demo and lab infrastructure from scratch.
As part of BareMetal part 1, you will install a BI Platform using SQL Server 2008 R2 from the ground up.
This includes configuring a Domain Controller, setting up clustering, and providing instances of SQL Server as part of the installation process.
You will learn how to install SQL Server using scripting, install SharePoint 2010, and install PowerPivot, PerformancePoint Services and Office 2010.
|
|
BareMetal - Business Intelligence - Part 2
|
Integrate SQL Server with SharePoint 2010; configure Reporting Services and PowerPivot, as well as configuring a BI Dashboard.
|
|
BareMetal - Business Intelligence - Part 3
|
Based on the previous parts you will consume a BI Platform, by creating Reports using Reporting Services, PerformancePoint, and PowerPivot.
You will also work with data from SQL Azure, and migrate databases to SQL Azure.
|
|
SharePoint
|
|
|
Developing KPI's and scorecards with SharePoint 2010 PerformancePoint services
|
Learn how to create scorecards and dashboards using PerformancePoint Services in SharePoint 2010
|
|
Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
|
This Hands On Lab covers how to develop reports and scorecards with SharePoint 2010 PerformancePoint Services.
|
|
SQL Server code name Denali
|
|
|
SQL Server Denali - Introduction to SSIS (the Advanced lab will also be available)
|
Perform several exercises to achieve a better understanding of SQL Server Integration Services (SSIS) in SQL Server Denali. Perform lookups as well as implementing data caching and data profiling.
|
|
SQL Server Denali - Always On - Implementing High Availability
|
Learn how to implement High Availability in SQL Server Denali based on different scenarios, including scripting and automated installations.
|
|
SQL Server Denali - Deploying Data Tier Applications
|
Perform several exercises to implement a Data-Tier application and perform upgrades and redeploy the application.
|
|
Using SQL Server Developer Tools, Codename "Juneau" to develop your SQL Server Denali Database
|
In SQL Server’s “Denali” release, SQL Server Developer Tools, Codename "Juneau" transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development and maintenance/update. Try this HOL and learn how you can use SSDT’s TSQL design capabilities to build, debug, maintain and refactor databases whether working with a database project or directly with an online database instance. SSDT also makes it easy for a database developer to work hand-in-glove with Entity Framework projects, and this HOL illustrates that feature too.
|
|
SQL Server Denali - Distributed Replay Utility
|
Microsoft SQL Server Distributed Replay Utility helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning.
Unlike SQL Server Profiler, the Distributed Replay Utility is not limited to replaying the workload from a single computer.
With the Distributed Replay Utility, you can replay a workload from multiple computers and better simulate a mission-critical workload.
In this hands-on-lab you will run several exercises to understand Distributed Replay Utility.
|
|
SQL Server Denali - Implementing Transparent Data Encryption (TDE)
|
By the end of this lab you will be able to successfully implement a secure database environment using Transparent Data Encryption.
|
|
SQL Server Denali - Multi Server Management
|
Perform several exercises to centrally manage multiple instances of SQL Server 2008 R2. Learn to configure a Central Management Server infrastructure and evaluate policies and execute queries against the multiple servers. You will also learn how to manage multiple instances from a Central Management Server.
|
|
SQL Server Denali - Working with Contained Databases
|
Learn how to implement Contained Databases in SQL Server Denali
|
|
SQL Server Denali - Implementing Policy Based Management
|
Learn how to Implement Policy Based Management in SQL Server Denali, and identify new product features.
|
|
SQL Server 2008 R2
|
|
|
SQL Server 2008 R2 - Always On - Database Mirroring
|
Learn how to implement Database Mirroring in SQL Server 2008 R2.
|
|
SQL Server 2008 R2 - Always On - Peer to Peer Replication
|
Implement Peer to Peer replication in SQL Server 2008 R2.
|
|
Upgrading to SQL Server 2008 R2 from SQL Server 2000/2005
|
Identify key-components and steps to perform a successful upgrade and migration, as well as identify pre-post tasks needed to upgrade your database platform.
This 2 piece lab allows you to pick the upgrade strategy that is the most suitable for your needs(upgrade from either SQL 2005 or SQL Server 2005)
|
|
Microsoft Assessment and planning (MAP) 5.5 Toolkit: Heterogeneous database discovery for migration to SQL Server 2008 R2
|
Are your customers looking for solutions to help plan and optimize their database resources and investments? Are they considering a move to SQL Server 2008 R2 to meet ever-increasing demands on managing their data? Now with the heterogeneous database discovery, MAP 5.5 helps you accelerate migration to SQL Server with network inventory reporting. Using MAP ‘s proposals and reports, you can make informed decisions to better utilize hardware & database resources, reduce administrative costs, and streamline your SQL Server software licensing needs.
|
|
Dynamics CRM
|
|
|
Self-guided tour of Dynamics CRM 2011 New User
|
Explore Dynamics CRM 2011. This lab is intended for users new to Dynamics CRM. You will get an overview of new features such as visualizations and the Ribbon and a basic understanding of Dynamics CRM 2011. This lab is an overview. Many of these topics are covered in greater detail later in the course.
|
|
Self-guided tour of what’s new in Dynamics CRM 2011
|
Explore what is new in Dynamics CRM 2011. This lab is an overview and many of these topics are covered in detail later in the course or will build on these skills and knowledge.
|
|
Solution Packaging
|
Explore the new Solution capabilities in Dynamics CRM 2011. You will use the solution editor to package, install and uninstall solutions. You will also use the built-in tools to identify and take advantage of the dependency tracking framework.
|
|
Dynamics CRM 2011 Building Data Charts, Dashboards & Reports
|
Explore the new data charting, dashboard and reporting capabilities in Dynamics CRM 2011. You will see how to add charts and drilldowns including date time charts to visualize operational data. You will learn how multiple visualizations can be rolled-up into dashboards that are either system wide or user specific. Using the extensibility capabilities, you will customize the built-in visualizations. You will learn how to report on this data too.
|
|
Creating Plug-ins for Dynamics CRM 2011
|
In this lab you will use CRM 2011 Plug-ins to perform an action on the create and update events of records. You also use the new transaction feature in Plug-ins to group operations on multiple entities and to roll back these operations as a group on failure.
|
|
User Experience Extensibility
|
Dynamics CRM 2011 provides a robust default user experience for both the built-in and custom components configured for a solution. This default user experience can then be further tailored to specific solution requirements using the extensibility hooks provided by Dynamics CRM 2011. Many of these customizations can be done using the form and view editors and do not require code. For example, layout on forms, columns on views and even sub grids to display related data inline on a form can all be created using web based editors and do not require code. As needs become more complex, developers can use JScript to handle form events to provide a more interactive experience based on the users interaction with the data. Dynamics CRM 2011 now includes support for web resources that can be placed onto forms. Web Resources can have many different content types including HTML, images and Silverlight. Silverlight controls added to forms run inline and have full access to interact with the form. Silverlight can be used to provide an even richer user experience when included as part of a form. Finally, navigation is a key part of the user experience guiding the user to the solution features using intuitive paths. Dynamics CRM 2011 has adopted ribbon navigation consistent with what Microsoft Office users are accustomed to. The ribbon in Dynamics CRM 2011 offers extensive customization capabilities and can be tailored to specific solution requirements. In this lab you will begin to explore the user experience related extensibility of Dynamics CRM 2011.
|
|
Accessing Microsoft Dynamics CRM 2011 using WCF
|
Dynamics CRM 2011 introduces a new WCF interface for working with data, services and metadata. This new API is streamlined to improve performance while still providing a productive developer experience. Prior versions of CRM had a separate interface for working with the platform metadata; this is now consolidated into the new WCF service. You can work with the new WCF API using both early and late bound data types.
|
|
Building Workflows with Dynamics CRM 2011
|
In this lab you'll explore the new workflow capabilities in Dynamics CRM 2011 that are made possible by the use of Windows Workflow Foundation 4(WF4). You will learn how the Web Based workflow designer can be used to design workflows and how these workflows can be exported as XAML for modification by a developer. Because XAML provides a declarative definition of each workflow it is possible to open these XAML representations of a CRM 2011 workflow using the workflow designer inside Visual Studio 2010. You will open and edit a CRM 2011 workflow in Visual Studio before updating it back into CRM 2011 and then executing that workflow. By editing the workflow directly in Visual Studio you will be able to take advantage of some of the new WF4 activities that are not supported in the web based designer.
|
|
Building Dialogs with Dynamics CRM 2011
|
In this lab you'll explore new ways to interact with the user by the creation of dialogs. You will create a dialog that will interact with the user and make process decisions based on the user’s feedback.
|
