SQL Server
8 out of 15 rated this helpful - Rate this topic

Tutorials for SQL Server 2012

SQL Server 2012 introduces many new technologies and features. Three new or significantly updated tutorials are available to help you get started quickly with .

There are plans to plans to provide additional tutorials in the future. Meanwhile, you can continue to learn from the SQL Server 2008 R2 tutorials. In some cases, you might find minor differences between the user interface in and SQL Server 2008 R2 and there might be subtle differences in tutorial prerequisites. If a tutorial uses one of the Adventure Works databases, you should download and use the version.

If you are using a server, you have the data providers installed. In order for the tutorials to work, you will either need the sample databases that work with those providers, or you need the SQL Server 2008 R2 data providers that work with the SQL Server 2008 R2 version of the sample databases.

SQL Server 2012 provides the following tutorials for features new or significantly updated in SQL Server 2012.

Tutorial

Description

Multidimensional Modeling (Adventure Works Tutorial)

This tutorial teaches you how to develop and deploy an Analysis Services project that enables the employees of Adventure Works Cycles to analyze various aspects of their business.

Tabular Modeling (Adventure Works Tutorial)

This tutorial teaches you how to create a SQL Server 2012 Analysis Services tabular model that enable sales and marketing teams to easily analyze internet sales data in the AdventureWorksDW2012 data warehouse. You will build the tabular model in SQL Server Data Tools.

You can set properties on a tabular model to enhance the Power View experience. For more information, see Tutorial: Configure Tabular Model Reporting Properties for Power View.

Tutorials and Demos for Power View

Create Power View reports and explore Power View features. View demos, videos, and tutorials that help you get started quickly with Power View and successfully build reports with interactive filters and visualizations such as bubble charts, tiles, and cards.

Tutorial: Using the hierarchyid Data Type

This tutorial is intended for users who are experienced with Transact-SQL, but are new to the hierarchyid data type. In this tutorial, you convert an existing table to a hierarchical structure, and you also create a new table to store and manage hierarchical data efficiently.

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ