New SQL Server 2012 Labs and Presentations Available

  • Article

We just shipped a whole bunch of new content for the SQL Server 2012 Developer Training Kit and you can get it right now via the Web Installer Preview:

https://go.microsoft.com/?linkid=9785999

This update includes eleven new hands-on labs covering popular topics like Integration Services, the new BI Semantic Model and Power View.

Remember, if you are new to training kits in general, you don’t need to install all the dependencies up front. As a matter of fact, you can skip them all and just install the content if all you want to do is browse it.

Here’s a complete list of the content available in the training kit including what’s new or updated:

Discover SQL Server 2012

Updated Presentation: Introduction to SQL Server 2012 ( SQL11UPD00-DECK-01)

This presentation provides an overview of the key improvements in SQL Server 2012 from a developer perspective in the context of Microsoft's overall strategy for Platform-as-a-Service (PaaS).

Demo: A First Look at SQL Server Data Tools (SQL11UPD00-DEMO-03)

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.

Hands On Lab: Build Your First Web Application with SQL Server 2012 and ASP.NET ( SQL11UPD00-HOL-01)

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.

Hands On Lab: Exploring Transact-SQL Improvements in SQL Server 2012 ( SQL11UPD00-HOL-02)

In this Hands On Lab you will explore the Transact-SQL improvements in SQL Server 2012.

Hands On Lab: Managing Rich Unstructured Data in SQL Server 2012 ( SQL11UPD00-HOL-03 )

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.

SQL Server 2012 Enterprise Information Management

New Hands On Lab: Exploring SQL Server 2012 Integration Services ( SQL11UPD05-HOL-01 )

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.

New Hands On Lab: Exploring SQL Server 2012 Master Data Services ( SQL11UPD05-HOL-02 )

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.

New Hands On Lab: Exploring SQL Server Denali 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.

SQL Server 2012 Reporting and Analytics

New Hands On Lab: Developing a SQL Server 2012 Tabular BI Semantic Model with Visual Studio 2010 ( SQL11UPD06-HOL-01 )

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 AdventureWorksDWDenali 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.

New Hands On Lab: Creating a SQL Server 2012 Tabular BI Semantic Model with PowerPivot ( SQL11UPD06-HOL-02)

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.

New Presentation: What's New in SQL Server 2012 Reporting Services ( SQL11UPD06-DECK-03 )

This presentation provides a high-level overview of SQL Server 2012 Reporting Services improvements including data alerts, improved SharePoint 2010 integration, Power View and SQL Azure Reporting.

New Hands On Lab: Exploring Data Alerts with SQL Server 2012 Reporting Services ( SQL11UPD06-HOL-03 )

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.

New Hands On Lab: Optimizing a SQL Server 2012 Tabular BI Semantic Model for Power View ( SQL11UPD06-HOL-04 )

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.

New Hands On Lab: Exploring SQL Server 2012 Power View ( SQL11UPD06-HOL-05)

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.

New Hands On Lab: Creating Excel 2010 Reports Based on a SQL Server 2012 Tabular BI Semantic Model ( SQL11UPD06-HOL-06 )

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.

New Hands On Lab: Creating a SQL Server Reporting Services Report Based on a SQL Server 2012 Tabular BI Semantic Model ( SQL11UPD06-HOL-07 )

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.

New Hands On Lab: Creating a PerformancePoint Services 2010 Dashboard Based on a SQL Server 2012 Tabular BI Semantic Model ( SQL11UPD06-HOL-08 )

This hands on lab shows how to create a PerformancePoint Services 2010 dashboard based on a SQL Server 2012 Tabular BI Semantic Model.

Introduction to SQL Azure

Presentation: Introduction to SQL Azure ( SQL11UPD07-DECK-01 )

Provides a high level overview of SQL Azure from a developer perspective.

Presentation: Advanced SQL Azure ( SQL11UPD07-DECK-02 )

Provides a high level overview of advanced SQL Azure services including SQL Azure Reporting, SQL Azure DataSync and SQL Azure Federations.

Demo: Provisioning Logical Servers using Cmdlets ( SQLAzureProvisioningServers )

This demo shows how to provision SQL Azure Logical Servers using the Azure Cmdlets.

Hands On Lab: Migrating Databases to SQL Azure ( MigratingDatabasesToSQLAzure )

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.

Hands On Lab: SQL Azure Data-tier Applications ( SQLAzureDAC )

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.

Hands On Lab: Build Your First Report with SQL Azure Reporting ( SQLAzureReportingServices )

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.

Hands On Lab: SQL Azure Data Sync ( SQLAzureDataSync )

In this lab, you will learn how to synchronize data between SQL Azure and on-premises SQL Server databases, using SQL Azure Data Sync.

Hands On Lab: SQL Azure Federations ( SQLAzureFederations )

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.