SQL Server 2012 Developer Training Kit BOM

SQL Server 2012 Developer Training Kit BOM

Overview

Important: Submit your ideas and feedback at http://bit.ly/sql2012kitfeedback!

This wiki provides a comprehensive list of all of the SQL Server 2012 Developer Training Kit Content.  Check back here regulary for new and/or updated content.  All content has been tested to work with the following technology releases:

  • SQL Server 2012 RTM
  • Visual Studio 2010 SP1
  • Office 2010 SP1
  • SharePoint 2010 SP1

If you prefer to download all the content at once, use the SQL Server 2012 Developer Training Kit.  Otherwise, you can download just the individual pieces of content you need using the content installer links below.  The content is organized into a sample agenda to help you plan your own [[SQL Server 2012 Update for Developers Training Workshop]].


Day 1: Introduction and Database Engine Topics

 

Module 1: Introduction to SQL Server 2012

 

 Start Stop  Description  Links
08:30 09:00 Breakfast   
09:00 09:45 Presentation: Introduction to SQL Server 2012
This presentation provides an overview of the key improvements in SQL Server 2012 from a developer perspective in the context of Microsoft's overall platform strategy.
SQL11UPD00-DECK-01
SQL11UPD00-REC-01
SQL11UPD00-TSCRIPT-01
09:45 10:00  Demo: A First Look at SQL Server Data Tools (Deprecated)
This demo provides a quick tour of the new SQL Server Data Tools. SSDT makes it easy to develop powerful database solutions that target both your on-premise environment and the cloud. (VM: KIWI).
SQL11UPD00-DEMO-01
SQL11UPD00-REC-02
09:45 10:00 Demo: A First Look at SQL Server 2012
SQL Server 2012 is the latest release of Microsoft's flagship data platform.  In this four part demo, we'll take an initial look at some of the most exciting new improvements in this important release, and demonstrate how SQL Server 2012 can help cloud optimize organizations of all sizes.  First, we'll show you how AlwaysOn support for readable secondary replicas improves resource utilization.  Next, we'll show you how Data Quality Services and the Windows Azure Marketplace can help ensure that all of your data is accurate and compliant.  Then, we'll show you how SQL Server Data Tools delivers a rich new modern developer experience for building database applications that target your on-premise environment or the cloud.  Finally, we'll show you how SQL Azure Data Sync can help ensure that key data sets are available where you need them and when you need them.
SQL11UPD00-DEMO-02
SQL11UPD00-REC-03
SQL11UPD00-TSCRIPT-03
SQL11UPD00-REC-04
SQL11UPD00-TSCRIPT-04
SQL11UPD00-REC-05
SQL11UPD00-TSCRIPT-05
SQL11UPD00-REC-06 
SQL11UPD00-TSCRIPT-06
10:00 10:15 Break  

 

Module 2: Introduction to SQL Server AlwaysOn

 

Start Stop Description Links
10:15 10:30 Presentation: Introducing High Availability and Disaster Recovery with SQL Server 2012 AlwaysOn
This presentation provides an overview of the new high availability and disaster recovery capabilities provided by SQL Server 2012 AlwaysOn, including Availability Groups, partial containment and contained users.
SQL11UPD01-DECK-01
SQL11UPD01-REC-01
SQL11UPD01-TSCRIPT-01
10:30 10:45 Demo: Configuring SQL Server 2012 AlwaysOn Availability Groups
This demonstration shows how to create a SQL Server 2012 AlwaysOn Availability Group and how to add an additional replica to an existing Availability Group using the SQL Server Management Studio Availability Group wizards.
SQL11UPD01-DEMO-01
SQL11UPD01-REC-02
SQL11UPD01-TSCRIPT-02
SQL11UPD01-REC-09
SQL11UPD01-TSCRIPT-09
10:45 11:00 Presentation: SQL Server 2012 AlwaysOn Availability Group Connectivity
This presentation covers application connectivity to AlwaysOn Availability Groups using Availability Group Listeners.
SQL11UPD01-DECK-02
SQL11UPD01-REC-03
SQL11UPD01-TSCRIPT-03
11:00 11:15 Demo: Configuring a SQL Server 2012 AlwaysOn Availability Group Listener
This demonstration shows how to configure an Availability Group Listener for a SQL Server 2012 AlwaysOn Availability Group. The Availability Group Listener provides the Virtual Network Name that enables the automated seamless failover capabilities to applications using the Availability Group databases, as well as the read-only routing capabilities for Read Only Secondaries.
SQL11UPD01-DEMO-02
SQL11UPD01-REC-04
SQL11UPD01-TSCRIPT-04
11:15 11:30 Presentation: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas
This presentation provides an overview of SQL Server 2012 AlwaysOn support for readable secondary replicas which can help maximize hardware utilization by servicing read-only workloads like backup and reporting.
SQL11UPD01-DECK-03
SQL11UPD01-REC-05
SQL11UPD01-TSCRIPT-05
11:30 11:45 Demo: Maximizing Hardware Utilization with SQL Server 2012 AlwaysOn Readable Secondary Replicas
This demonstration shows how to configure readable secondary replicas in an availability group to maximize hardware utilization by offloading read only workloads, and how to extend seamless failover capabilities to read only workloads using read only routing.
SQL11UPD01-DEMO-03
SQL11UPD01-REC-06
SQL11UPD01-TSCRIPT-06
11:45 11:55 Presentation: Introducing SQL Server 2012 AlwaysOn Failover Clustering
This presentation provides an overview of failover clustering improvements introduced in SQL Server 2012 AlwaysOn.
SQL11UPD01-DECK-04
SQL11UPD01-REC-07
SQL11UPD01-TSCRIPT-07
11:55 12:00 Demo: Configuring SQL Server 2012 AlwaysOn Failover Clustering
This demonstration shows how to configure the flexible failover policy for SQL Server 2012 AlwaysOn Failover Clustering.
SQL11UPD01-DEMO-04
SQL11UPD01-REC-08
SQL11UPD01-TSCRIPT-08
12:00 13:00 60 Minute Lunch  

 

Module 3: Exploring and Managing SQL Server 2012 Database Engine Improvements

 

Start Stop Description Links
13:00 13:15 Presentation: Introducing SQL Server 2012 Columnstore Indexes
Columnstore indexes provide an easy way to significantly improve data warehouse and decision support query performance against very large data sets.
SQL11UPD02-DECK-01
SQL11UPD02-REC-01
SQL11UPD02-TSCRIPT-01
13:15 13:30 Demo: Accelerating Data Warehouse Queries with SQL Server 2012 Columnstore Indexes
This demonstration shows how to implement Columnstore Indexes, establish the performance impact for a standard data warehouse query and lastly show how to modify rows for a table with a Columnstore Index using partitioning. (VM: KIWI)
SQL11UPD02-DEMO-01
SQL11UPD02-REC-02
SQL11UPD02-TSCRIPT-02
13:30 13:40 Presentation: Introducing SQL Server 2012 Table Partitioning Improvements
SQL Server 2012 offers several important improvements that related to table partitioning, including more partitions per table, improved online operations, better index build performance and new wizards.
SQL11UPD02-DECK-02
SQL11UPD02-REC-03
SQL11UPD02-TSCRIPT-03
13:40 13:45 Demo: SQL Server 2012 Table Partitioning Enhancements
This demo shows how to use the enhanced Partition Wizard to switch out and switch in a partition. We’ll demonstrate this enhanced UI against a table with more than 1,000 partitions (by example demonstrating this new capability as well). (VM: KIWI)
SQL11UPD02-DEMO-02
SQL11UPD02-REC-04
SQL11UPD02-TSCRIPT-04
13:45 13:55 Presentation: Introducing SQL Server 2012 Security and Auditing Improvements
In this presentation we'll cover SQL Server 2012 improvements that impact security and auditing, including new support for default schema for groups, user-defined server roles and various auditing improvements.
SQL11UPD02-DECK-03
SQL11UPD02-REC-05
SQL11UPD02-TSCRIPT-05
13:55 14:00 Demo: Customizing Server Roles in SQL Server 2012
This demo shows how to create a user-defined server role in Transact-SQL.  In five minutes we'll walk through how to create a role, add members, remove a member, grant permissions to the role and change the role name.  Along the way we'll validate the changes we've made using security catalog views. (VM: KIWI)
SQL11UPD02-DEMO-03
SQL11UPD02-REC-06
SQL11UPD02-TSCRIPT-06
14:00 14:10 Presentation: Introducing SQL Server 2012 Extended Events Enhancements
SQL Server extended events enable rich diagnostic troubleshooting capabilities, and SQL Server 2012 provides new tools and APIs for extended events.
SQL11UPD02-DECK-04
SQL11UPD02-REC-07
SQL11UPD02-TSCRIPT-07
14:10 14:15 Demo: SQL Server 2012 Extended Events Enhancements
This demonstration shows how to use the new Extended Events wizards and interfaces in SQL Server Management Studio.
SQL11UPD02-DEMO-04
SQL11UPD02-REC-08
SQL11UPD02-TSCRIPT-08
14:15 14:25 Presentation: Introducing the SQL Server 2012 Distributed Replay Utility
SQL Server 2012 introduces an important new utility called Distributed Replay that will change the way you benchmark and test your database workloads.
SQL11UPD02-DECK-05
SQL11UPD02-REC-09
SQL11UPD02-TSCRIPT-09
14:25 14:30 Demo: SQL Server 2012 Distributed Replay
This demonstration shows how to launch the Distributed Replay controller and client, pre-process a trace file workload, launch the workload and validate that it is running through SQL Server Profiler. (VM: KIWI)
SQL11UPD02-DEMO-05
SQL11UPD02-REC-10
SQL11UPD02-TSCRIPT-10
14:30  14:45 Break  

 

Module 4: SQL Server 2012 Database Server Programmability

 

Start Stop Description Links
14:45 14:55 Presentation: Introducing SQL Server 2012 Transact-SQL Improvements
SQL Server 2012 introduces several Transact-SQL improvements that impact developer productivity and support for key standards, including easier query results pagination and sequence generators.
SQL11UPD03-DECK-01
SQL11UPD03-REC-01
SQL11UPD03-TSCRIPT-01
14:55 15:00 Demo: Simplified Result Set Paging with SQL Server 2012
This demo shows how to replace code that was based on CTEs and ROW_NUMBER() to provide query pagination in earlier versions of SQL Server, to use the new OFFSET and FETCH clauses provided by SQL Server 2012.
SQL11UPD03-DEMO-01
SQL11UPD03-REC-02
SQL11UPD03-TSCRIPT-02
15:00 15:10 Presentation: Introducing SQL Server 2012 Spatial Improvements
Developers who exploit spatial data types in their applications will find some helpful improvements in SQL Server 2012, including support for new shapes and methods, full globe support and spatial index enhancements.
SQL11UPD03-DECK-02
SQL11UPD03-REC-03
SQL11UPD03-TSCRIPT-03
15:10 15:15 Demo: Implementing a 'Nearest Neighbor' Spatial Query with SQL Server 2012
This demo shows you the types of queries that received a significant performance improvement when working with spatial data types in SQL Server 2012.
SQL11UPD03-DEMO-02
SQL11UPD03-REC-04
SQL11UPD03-TSCRIPT-04
15:15 15:25 Presentation: Storing and Querying Documents with SQL Server 2012
SQL Server 2012 combines the high performance database blob storage capabilities of FILESTREAM with new SMB file sharing capabilities of FileTable to enable rich support for content as an integrated part of a database application. Once content is managed by SQL Server, exciting new search scenarios can be powered by full text search and statistical semantic search.
SQL11UPD03-DECK-03
SQL11UPD03-REC-05
SQL11UPD03-TSCRIPT-05
15:25 15:30 Demo: Accessing Documents With SQL Server 2012 FileTable
This demo shows how to create a FileTable and to view the metadata provided by the FileTable feature.
SQL11UPD03-DEMO-03
SQL11UPD03-REC-06
SQL11UPD03-TSCRIPT-06
15:30 15:40 Presentation: Introducing SQL Server 2012 Express Local Database Runtime
SQL Server 2012 Express Edition introduces a new deployment option called Local Database Runtime. LocalDb is a small shared component (not a service) that installs in five minutes or less that is ideal for applications or tools that need an embedded database that is API compatible with SQL Server.
SQL11UPD03-DECK-04
SQL11UPD03-REC-07
SQL11UPD03-TSCRIPT-07
15:40 15:45 Demo: Using SQL Server 2012 Express Local Database Runtime as an Embedded Database
This demo shows how a developer can redistribute the SQL Server 2012 Express Local Database Runtime with a custom application and use it as an embedded database.
SQL11UPD03-DEMO-04
SQL11UPD03-REC-08
SQL11UPD03-TSCRIPT-08
15:45 16:00 Break  
16:00 17:30 Hands-On Labs  

 


Day 2: Visual Studio, .NET and Business Intelligence Topics

 

Module 5: SQL Server 2012 Application Development

 

Start Stop Description Links
08:30 09:00 Breakfast
09:00  09:15 Presentation: Introducing SQL Server Data Tools for Visual Studio 2010
SQL Server Data Tools provides a modern development experience for building database applications, and makes it easy to target both your on-premise environment and the cloud.
SQL11UPD04-DECK-01
SQL11UPD04-REC-01
SQL11UPD04-TSCRIPT-01
09:15 09:30 Demo: Declarative Database Development with SQL Server 2012 Data Tools
This demo provides a first look at SQL Server Data Tools and connected development with tools like the SQL Server Object Explorer and Query Window which will alleviate the need for developers to install other tools like SQL Server Management Studio. It also shows how to create an offline database project based upon an existing database, make changes to it, and test it locally using the integrated Local Database Runtime (LocalDb).
SQL11UPD04-DEMO-01
SQL11UPD04-REC-02
SQL11UPD04-TSCRIPT-02
09:30 09:45 Presentation: Introducing Data-Tier Applications
Data-Tier Applications, or DAC FX, provides a set of API's, tools and services that dramatically simplify developing, deploying and versioning databases for both your on-premise environment and the cloud. This presentation will talk about what's new with DAC Fx including support for in-place upgrades, integration with SSDT, support for new objects and more.
SQL11UPD04-DECK-02
SQL11UPD04-REC-03
SQL11UPD04-TSCRIPT-03
09:45 10:00 Demo: Performing an In-Place Upgrade of a SQL Server 2012 Data-tier Application
The Data-Tier Application Framework (DAC Fx) is a powerful new way to deploy and upgrade database projects for both your on-premise and cloud applications. Prior releases of DAC Fx only supported side-by-side upgrades. SQL Server 2012 includes DAC Fx 3.0, which supports the ability to perform in-place upgrades.
SQL11UPD04-DEMO-02
SQL11UPD04-REC-04
SQL11UPD04-TSCRIPT-04
10:00 10:15 Break  
10:15 10:30 Presentation: What's New in .NET 4.0 and SQL Server 2012
Developers leveraging the ADO.NET Entity Framework as an ORM layer will find improved integration with SQL Server 2012 including support for more objects, improved support for stored procedures and improved performance.
SQL11UPD04-DECK-03
SQL11UPD04-REC-05
SQL11UPD04-TSCRIPT-05
10:30 10:45 Demo: Using ADO.NET Entity Framework Code-First Functionality
This demo shows how to create an ASP.NET MVC application that uses the model-first (also known as code-first) functionality provided by the ADO.NET Entity Framework.
SQL11UPD04-DEMO-03
SQL11UPD04-REC-06
SQL11UPD04-TSCRIPT-06
10:45 11:00 Presentation: Introducing StreamInsight 2.0
StreamInsight 2.0 is a set of APIs and services included with SQL Server 2012 that helps database developers address real-time data processing workloads, and makes it it easy to develop standing queries over continuous event-stream data that deliver real-time insight.
SQL11UPD04-DECK-04
SQL11UPD04-REC-07
SQL11UPD04-TSCRIPT-07
11:00 11:15 Demo: Developing Standing Queries over Observable .NET Classes with StreamInsight 2.0
StreamInsight makes it easy to build standing queries over event-stream data that are continuously evaluated. StreamInsight 2.0 introduces support for observable .NET classes as an event source, which dramatically simplifies the coding required to start querying many different types of event streams.
SQL11UPD04-DEMO-04
SQL11UPD04-REC-08
SQL11UPD04-TSCRIPT-08

 

Module 6: SQL Server 2012 Enterprise Information Management

 

Start Stop Description Links
11:15 11:30 Presentation: Introducing SQL Server 2012 Integration Services Improvements
SQL Server 2012 Integration Services introduces a host of new improvements of interest to developers and IT Professionals alike. Developers will appreciate a greatly improved package design experience, and IT Professionals will find a powerful new set of tools and services that will greatly simplify the deployment, management and monitoring of SSIS packages running on servers.
SQL11UPD05-DECK-01
SQL11UPD05-REC-01
SQL11UPD05-TSCRIPT-01
11:30 11:45 Demo: Developing and Monitoring a SQL Server 2012 Integration Services Solution
This demonstration explores the new features of SQL Server 2012 Integration Services (SSIS). Specifically it covers project conversion, parameters, project connection managers, deployment to the SSIS catalog, package execution and viewing the built-in reports.
SQL11UPD05-DEMO-01
SQL11UPD05-REC-02
SQL11UPD05-TSCRIPT-02
11:45 12:00 Presentation: Introducing SQL Server 2012 Master Data Services Improvements
SQL Server 2012 Master Data Services is a set of tools and services that can be used to integrate disparate information systems that share common data sets into a common master data management solution. This new release offers several key improvements centered around usability, robustness, security, scale, and performance.
SQL11UPD05-DECK-02
SQL11UPD05-REC-03
SQL11UPD05-TSCRIPT-03
12:00 13:00 Lunch  
13:00  13:15 Demo: Managing Data with SQL Server 2012 Master Data Services
This demonstration creates a new model and then uses the Master Data Services (MDS) Add-in for Excel to create and load two entities. Then in the Master Data Manager web application, the loaded members are explored. A new member is added, and an existing member is updated. Finally, a subscription view is created to facilitate retrieval of the entity members.
SQL11UPD05-DEMO-02
SQL11UPD05-REC-04
SQL11UPD05-TSCRIPT-04
13:15 13:30 Presentation: Introducing SQL Server 2012 Data Quality Services
SQL Server 2012 Data Quality Services is a new knowledge-driven data cleansing solution that makes it easy to correct and de-duplicate data. DQS makes it easy for domain experts to build and improve a data quality knowledge base over time and can be reused by other solutions like Integration Services and Master Data Services.
SQL11UPD05-DECK-03
SQL11UPD05-REC-05
SQL11UPD05-TSCRIPT-05
13:30 13:45 Demo: Deduplicating Data with SQL Server 2012 Data Quality Services
This demonstration identifies and loads unique (non-duplicate) resellers into the Reseller entity of a Master Data Services (MDS) model. It involves creating a Data Quality Services (DQS) knowledge base and matching policy, and then using this matching policy with the MDS Excel add-in.
SQL11UPD05-DEMO-03
SQL11UPD05-REC-06
SQL11UPD05-TSCRIPT-06

 

Module 7: SQL Server 2012 Business Intelligence

 

Start Stop Description Links
13:45 14:00 Presentation: Introducing SQL Server 2012 Analysis Services Improvements
SQL Server 2012 Analysis Services introduces an impressive array of improvements designed to expand the reach a broader user base. SSAS brings together the existing multi-dimensional model with the new tabular model pioneered by PowerPivot under a single unified platform – the BI Semantic Model.
SQL11UPD06-DECK-01
SQL11UPD06-REC-01
SQL11UPD06-TSCRIPT-01
14:00 14:15 Presentation: Exploring SQL Server 2012 Analysis Services Tabular Modeling
The SQL Server 2012 Analysis Services release embraces tabular model development. The tabular development approach, introduced with SQL Server 2008 R2 PowerPivot, is now available to the IT Professional, and extends beyond the features available in PowerPivot. PowerPivot has been enhanced with new model designer features and improved SharePoint integration, and Data Analysis Expressions (DAX) is available to both model development approaches, and has been enhanced.
SQL11UPD06-DECK-02
SQL11UPD06-REC-03
SQL11UPD06-TSCRIPT-03
14:15  14:40 Demo: Developing a SQL Server 2012 Analysis Services Tabular Project
This demonstration develops a basic tabular project in Visual Studio. The project will be enhanced in the following demonstration (SQL11UPD06-DEMO-02) by adding new Data Analysis Expressions (DAX) functionality.
SQL11UPD06-DEMO-01
SQL11UPD06-REC-02
SQL11UPD06-TSCRIPT-02
14:40 14:50 Demo: Exploring SQL Server 2012 Analysis Services DAX Improvements
This demonstration explores two topics related to Data Analysis Expressions (DAX) improvements in SQL Server 2012.
SQL11UPD06-DEMO-02
SQL11UPD06-REC-04
SQL11UPD06-TSCRIPT-04
14:50 15:05 Break  
15:05 15:20 Presentation: Introducing SQL Server 2012 Reporting Services Improvements
SQL Server 2012 Reporting Services has been upgraded with new features and capabilities, including an exciting new self-service visual design experience named Power View, increased end-user productivity with data alerts, and improved better integration with SharePoint.
SQL11UPD06-DECK-03
SQL11UPD06-REC-05
SQL11UPD06-TSCRIPT-05
15:20 15:30 Demo: Configuring Data Alerts with SQL Server 2012 Reporting Services
This demonstration creates a shared data source, uploads an existing report definition, and then relates the report’s data source to the newly created data source. Then it proceeds to create a new data alert. The data alert is tested to first send no notification. Then data is modified to ensure a notification is sent.
SQL11UPD06-DEMO-03
SQL11UPD06-REC-06
SQL11UPD06-TSCRIPT-06
15:30 15:45 Presentation: Exploring SQL Server 2012 Power View
SQL Server 2012 Reporting Services introduces Power View, an interactive data exploration, visualization, and presentation experience which provides intuitive self-service reporting for business users against data exposed through the BI Semantic Model.
SQL11UPD06-DECK-04
SQL11UPD06-REC-07
SQL11UPD06-TSCRIPT-07
15:45 16:00 Demo: Exploring Self-Service Reporting with SQL Server 2012 Power View
This demonstration uploads an Excel workbook to the SharePoint PowerPivot Gallery library, and then uses it to produce a Power View report.
SQL11UPD06-DEMO-04
SQL11UPD06-REC-08
SQL11UPD06-TSCRIPT-08
16:00 17:30 Hands-On Labs  

 


Hands-On Labs

This section provides a comprehensive list of Hands-On Labs included in the SQL Server 2012 Developer Training Kit Content organized by topic area.  See the SQL Server 2012 Developer Training Kit Virtual Machine wiki for information on the appropriate virtual machine (VM) build.

Topic: SQL Server 2012 Database Engine

 

Hands-On Lab VM Minutes Content
Working With SQL Server 2012 AlwaysOn Availability Groups
In this lab, you will learn to use the new Availability Group feature in SQL Server 2012 to provide a high availability and disaster recovery solution to an application with multiple databases. This lab will teach you how to create an Availability Group and how to configure a virtual name to allow the application to seamlessly failover. You will also learn how to monitor the Availability Group status using the new management views.
EMU 45 SQL11UPD01-HOL-01
Working With SQL Server 2012 Columnstore Indexes
This hands on lab will show you how to create, use and maintain SQL Server 2012 columnstore indexes.
KIWI 45 SQL11UPD02-HOL-01
Exploring Transact-SQL Improvements in SQL Server 2012
In this lab, you will learn to use three improved features in the new SQL Server 2012. These features include creating sequences and using them to insert new rows in any table, querying data through pages iteratively, and raising and catching exceptions using Throw/Catch statements.
KIWI 30 SQL11UPD03-HOL-01
MSDN V-Lab
Managing Rich Unstructured Data in SQL Server 2012
This lab will introduce you to several SQL Server 2012 improvements that make it easy to manage content as an integrated part of your solution, including FILESTREAM, FileTable, full text indexing and semantic search.
KIWI 30 SQL11UPD03-HOL-02
MSDN V-Lab

 

Topic: Visual Studio 2010 and .NET 4.0

 

Hands-On Lab VM Minutes Content
Build Your First Web Application with SQL Server 2012 and ASP.NET
This lab shows how to build a simple web application in ASP.NET that performs CRUD (Create, Read, Update and Delete) operations against a SQL Server 2012 database.  It also shows you how to work with images stored in the database.
KIWI 45 SQL11UPD00-HOL-01
MSDN V-Lab
Exploring SQL Server Data Tools for Visual Studio 2010
In this lab, you will learn how to develop database applications using SQL Server Data Tools (SSDT) for Visual Studio 2010. SSDT brings a powerful and modern development experience to applications targeting SQL Server or SQL Azure. The tools provide both connected and disconnected project models, and are designed to help to provide a one-stop-shop for developers by minimizing the number of external tools required to develop, test and debug applications.
KIWI 45 SQL11UPD04-HOL-01

 

Topic: SQL Server 2012 Enterprise Information Management

 

Hands-On Lab VM Minutes Content
Exploring SQL Server 2012 Integration Services
This hands on lab will introduce you to the improvements in SQL Server 2012 Integration Services including project connection managers, parameters, SSIS catalogs, server package execution and monitoring.
KIWI 30 SQL11UPD05-HOL-01
MSDN V-Lab
Exploring SQL Server 2012 Master Data Services
In this lab, you will create a Master Data Services model and entities to store a master list of geographic data. The entity and attribute creation will be achieved using the Master Data Services Add-in for Excel.
KIWI 30 SQL11UPD05-HOL-02
Exploring SQL Server 2012 Data Quality Services
In this lab, you will create a Data Quality Services knowledge base to cleanse US state codes and email addresses. You will then create a Data Quality Project to cleanse data in an Excel workbook. Next, you will update an Integration Services package to use the DQS Cleansing component to cleanse the data as part of an ETL process.
KIWI 30 SQL11UPD05-HOL-03

 

Topic: SQL Server 2012 Business Intelligence

 

Hands-On Lab VM Minutes Content
Developing a SQL Server 2012 Tabular BI Semantic Model with Visual Studio 2010
SQL Server 2012 introduces the concept of a BI Semantic Model, which is a common metadata layer used to drive multiple user experiences including scorecards, dashboards and reports.  BI Semantic Models can be developed in either Visual Studio or in Excel using the SQL Server 2012 PowerPivot add in.  In this lab, you will develop a Tabular BI Semantic Model based on the AdventureWorksDW2012 sample database. Specifically it will allow the sales analysis of the reseller sales against sales quota. You will work with the entire development lifecycle including the creation of the project, the importing of data from both Microsoft SQL Server and a data feed data source, the enhancement of the model, and the definition of measures and a Key Performance Indicator (KPI). Once you have explored and tested the model you will enhance it with perspectives, partitions and a security role. Finally you will deploy the project to a Tabular instance of Analysis Services.
KIWI 90 SQL11UPD06-HOL-01
Creating a SQL Server 2012 Tabular BI Semantic Model with PowerPivot  
SQL Server 2012 introduces the concept of a BI Semantic Model, which is a common metadata layer used to drive multiple user experiences including scorecards, dashboards and reports.  BI Semantic Models can be developed in either Visual Studio or in Excel using the SQL Server 2012 PowerPivot add in.  In this lab, you will create a PowerPivot workbook that will import data from a SQL Server database and an Excel file. The PowerPivot model will then be enriched with calculated columns, hierarchies, a Key Performance Indicator (KPI), and a perspective. The principal goal of this lab is to create a user-friendly interface to the model to support self-service reporting, analytics and monitoring for Excel PivotTables, PerformancePoint Services dashboards and Reporting Services reports. You will explore the PowerPivot Field List interface by producing a PivotTable report. The final report will look like the following.
KIWI 45 SQL11UPD06-HOL-02
Exploring Data Alerts with SQL Server 2012 Reporting Services
SQL Server 2012 Reporting Services data alerts are a data-driven alerting solution that informs you about changes in report data that are of interest to you, and at a relevant time. In this lab, you will define a data alert to notify you when salespeople do not achieve at least the 1% profitability target.
KIWI 15 SQL11UPD06-HOL-03
Optimizing a SQL Server 2012 Tabular BI Semantic Model for Power View
SQL Server 2012 introduces the concept of a BI Semantic Model, which is a common metadata layer used to drive multiple user experiences including scorecards, dashboards and reports.  BI Semantic Models can be developed in either Visual Studio or in Excel using the SQL Server 2012 PowerPivot add in.  In this lab, you will optimize a PowerPivot tabular BI Semantic model for Power View. This will involve unhiding columns used in hierarchies, defining reporting properties, and removing explicit measures.
KIWI 30 SQL11UPD06-HOL-04
Exploring SQL Server 2012 Power View
In this lab, you will explore SQL Server 2012 Reporting Services Power View. Power View is a Web browser-based report authoring tool targeted at everyone to enable them to create compelling, interactive and rich data visualizations based on Tabular BI Semantic Models. You will create a report based on a PowerPivot workbook published to a PowerPivot Gallery, and this report will consist of three different, yet related, interactive data exploration experiences. You will explore the model data using the tables, column and bar charts, and an animated scatter chart.
KIWI 30 SQL11UPD06-HOL-05
Creating Excel 2010 Reports Based on a SQL Server 2012 Tabular BI Semantic Model
In this lab, you will create a report in Excel 2010 based on a SQL Server 2012 tabular BI Semantic Model. You will then publish the workbook to SharePoint Server and then explore the report rendered by Excel Services in the Web browser.
KIWI 30 SQL11UPD06-HOL-06
Creating a SQL Server Reporting Services Report Based on a SQL Server 2012 Tabular BI Semantic Model
In this lab, you will author a report in Report Builder 3.0 using the Map Wizard. The map analytic data will be retrieved from the Sales Analysis tabular BI Semantic Model.
KIWI 30 SQL11UPD06-HOL-07
Creating a PerformancePoint Services 2010 Dashboard Based on a SQL Server 2012 Tabular BI Semantic Model
This hands on lab shows how to create a PerformancePoint Services 2010 dashboard based on a SQL Server 2012 Tabular BI Semantic Model.
KIWI 30 SQL11UPD06-HOL-08

 

Topic: Windows Azure and SQL Azure

 

Hands-On Lab VM Minutes Content
Migrating Databases to SQL Azure
In this lab, you will use the AdventureWorksLT2008 database and show how to move an existing on-premise database to SQL Azure including: modifying the DDL and moving data via BCP.
KIWI 30 MigratingDatabasestoSQLAzure
SQL Azure Data-tier Applications
In this lab, you will learn how to use Data-tier Applications to deploy and upgrade SQL Azure databases. Using the SQL Server Data Tools (SSDT) you will create new database projects to publish a database schema and upgrade it with new changes.
KIWI 30 SQLAzureDAC
Build Your First Report with SQL Azure Reporting (Deprecated)
This hands-on lab shows how to build a simple report, deploy it to SQL Azure Reporting, and access it from a Windows Azure ASP.NET application.
KIWI 30 IntroToSQLAzureReporting
SQL Azure Data Sync
In this lab, you will learn how to synchronize data between SQL Azure and on-premises SQL Server databases, using SQL Azure Data Sync.
KIWI 30 SQLAzureDataSync
SQL Azure Federations
SQL Azure Federations is an integrated capability of SQL Azure Database that dramatically simplifies database sharding implementations. In this hands-on Lab, you will learn how to create a database with federations and develop applications that interacts with federated tables using both ADO.NET and Entity Framework.
KIWI 30 SQLAzureFederations

 


Return to SQL Server 2012 Developer Training Kit Content
 

 

Sort by: Published Date | Most Recent | Most Useful
Comments
  • Thanks for sharing. This is very good SQL materials.

  • Hi Roger,

    I think there is something wrong with 'SQL11UPD02-DECK-02' link. Please check.

    Peter.

  • @ Peter (and everybody): Please post any issues or problems with the training kit content or wiki at bit.ly/sql2012kitfeedback so we can track it to resolution thx.

  • The web installer still references RC0 content and the dependency check still fails on SQL Server 2012 and SSDT as it’s still looking for RC0

  • @ Mr. Wharty (and everybody): Please post your comments and feedback on bit.ly/sql2012kitfeedback so we can track to resolution.

  • Good Stuff on SQL 2012

  • Recommending to be featured. Great article!

  • What does BOM stand for?

  • gracias por compartir

  • Richard Mueller edited Revision 151. Comment: Fix zero characters in <a name> tags in headings in HTML

Page 1 of 2 (18 items) 12