Tutorials

SQL Server Tutorials

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (1)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

Tutorials

Tutorials help in learning new functionality in SQL Server. In SQL Server Books Online, tutorials have been integrated into the content that is associated with each component technology. For example, tutorials that describe how to design and implement Integration Services packages are under "Designing and Implementing Packages" in the Integration Services section of Books Online.

To help you quickly locate the various tutorial sections that are associated with each component technology, this topic lists the SQL Server tutorials that are currently available.

To open an interactive version of this topic

From the Start menu, point to All Programs, point to the Microsoft SQL Server program group, point to Documentation and Tutorials, point to Tutorials, and click SQL Server Tutorials.

Tutorials

Database Engine

Management tools tutorials:

Tutorial: SQL Server Management Studio

Tutorial: sqlcmd Utility

Tutorial: Database Engine Tuning Advisor

Tutorial: Administering Servers by Using Policy-Based Management

Tutorial: Evaluating Best Practices by Using Policy-Based Management

Database Engine tutorials:

Tutorial: Getting Started with the Database Engine

Tutorial: Writing Transact-SQL Statements

Tutorial: Using the hierarchyid Data Type

Analysis Services—Multidimensional Data

Designing and Implementing: Tutorials (Analysis Services - Multidimensional Data): Use the tutorials in this section to learn how to develop multidimensional data solutions.

Analysis Services—Data Mining

Tutorials: Designing and Implementing Data Mining Models: Use the tutorials in this section to learn how to develop data mining solutions.

Tutorials: Using DMX: Use the tutorials in this section to learn how to create queries against data mining models to predict trends, retrieve patterns in the data, and measure the accuracy of the mining models.

Integration Services

Designing and Implementing Packages Tutorials: Use the tutorials in this section to learn how to create packages in an Integration Services project and guide you through the use of the Integration Services tools.

Tutorial: Deploying Packages: Use this tutorial to learn how to use Integration Services tools to install packages and their dependencies to a different computer.

Replication

Designing and Implementing: Tutorials (Replication): Use the tutorials in this section to learn how to use SQL Server Management Studio to set up and run replication topologies.

Reporting Services

Tutorial: How to Locate and Start Reporting Services Tools: Use this tutorial to learn how to use the tools to configure a report server, manage report server content and operations, and create and publish reports and report models.

Tutorials (Reporting Services): Use the tutorials in this section to learn basic report design skills, one step at a time.

Designing Ad Hoc Reports: Tutorials: Use the tutorials in this section to learn necessary skill for creating reports based on models

Designing Report Models: Tutorials: Use the tutorials in this section to learn necessary skills for creating models that you can use in Report Builder or Report Model Query Designer.

Developer's Guide: Tutorials (Reporting Services): Use the tutorials in this section to learn about the many different ways to develop Reporting Services solutions.

Service Broker

Service Broker Tutorials: Use the tutorials in this section to learn how to create conversations to exchange messages between databases.

Other Resources

AdventureWorks Sample Databases

Help and Information

Getting SQL Server 2008 Assistance