Scribd
Upload
7 views1 page

SQL Server 2008/2012 Database Tutorial

This practical aims to provide an overview of SQL Server 2008/2012 databases and Analysis Services. Students will create a sample star schema database using SQL Server Management Studio, design and process a cube by identifying measures and dimensions for the star schema based on a case study. Students will also generate an Excel pivot table report using the data cube and SQL Server 2008/2012. The document provides background on SQL Server and SQL Server Management Studio, explaining that SQL Server is a relational database management system used to store and retrieve data for other software applications, and that SQL Server Management Studio provides a graphical interface for managing SQL Server instances and databases.

Uploaded by

programmer
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views1 page

SQL Server 2008/2012 Database Tutorial

This practical aims to provide an overview of SQL Server 2008/2012 databases and Analysis Services. Students will create a sample star schema database using SQL Server Management Studio, design and process a cube by identifying measures and dimensions for the star schema based on a case study. Students will also generate an Excel pivot table report using the data cube and SQL Server 2008/2012. The document provides background on SQL Server and SQL Server Management Studio, explaining that SQL Server is a relational database management system used to store and retrieve data for other software applications, and that SQL Server Management Studio provides a graphical interface for managing SQL Server instances and databases.

Uploaded by

programmer
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

PRACTICAL 1

Aim:

Overview of SQL Server 2008/2012 Databases and Analysis Services. Create a


Sample Database Star Schema using SQL Server Management Studio. Design,
Create and Process cube by identifying measures and dimensions for Star Schema,
for an assigned system by replacing a dimension in the grid, filtering and drilldown
using cube browser. (Based on Case Study) and also generate Excel Pivot Table
report based on data cube using SQL Server 2008/2012.

Software/ Hardware: SQL Server 2008/12. SQL Server Management Studio,


Microsoft Excel.

Theory:

SQL Server:

Microsoft SQL Server is a relational database management system developed by


Microsoft. As a database server, it is a software product with the primary function of
storing and retrieving data as requested by other software applications—which may run
either on the same computer or on another computer across a network (including the
Internet).

The SQL Server Management Studio (SSMS) tutorial introduces you to the integrated
environment for managing your SQL Server infrastructure. SQL Server Management
Studio presents a graphical interface for configuring, monitoring, and administering
instances of SQL Server. It also allows you to deploy, monitor, and upgrade the data-
tier components used by your applications, such as databases. SQL Server
Management Studio also provides Transact-SQL, MDX, DMX, and XML language
editors for editing and debugging scripts.

You might also like