Training Brochure
Bin Khaldoun Street, Sahara Complex Floor 5, Office #51 “A computer shall not waste your time or require
TABLE OF CONTENTS
High-Level Training Agenda _____________________________________________________________________________________________ 3 Module 1 – Introduction _________________________________________________________________________________________________ 3 Module 2 – Understanding the Virtual Server Environment _____________________________________________________________ 3 Module 3 – Installing SQL Server 2012 in a single-server virtual environment _________________________________________ 3 Module 4 – The SQL Server 2012 Management Studio _________________________________________________________________ 3 Module 5 – Creating the Contoso Clinic Database ______________________________________________________________________ 4 Module 6 – Maintaining the Contoso Clinic Database __________________________________________________________________ 4 Module 7 – Turning Data to useful information _________________________________________________________________________ 4 Here’s some idea about what you’ll learn during this training _______________________________________________________ 5 Effective installation and configuration of SQL Server __________________________________________________________________ 5 Effective Data Manipulation _____________________________________________________________________________________________ 5 End-to-end SQL Server Management ___________________________________________________________________________________ 6 Turning Data into Meaningful Information ______________________________________________________________________________ 6
HIGH-LEVEL TRAINING AGENDA
Module 1 – Introduction
This module is the introductory module to the course. Here’s what we’ll discuss during this module:
Course audience Housekeeping rules Your instructor
Our Case Study company: Contoso Clinic
Document Conventions
Module 2 – Understanding the Virtual Server Environment
In this module you’ll learn about: System requirements to run the Virtual Environment How to install the Virtual Environment
How to run the Virtual Environment
What’s included in the Virtual Environment
The Managed Service Accounts needed to install and configure SQL Server 2012.
Check your knowledge
Module 3 – Installing SQL Server 2012 in a single-server virtual environment
In this module you’ll learn: Step-by-step guide to installing and configuring SQL Server 2012 in a Single Server environment
Checking what has been installed.
Check your knowledge
Module 4 – The SQL Server 2012 Management Studio
In this module, you’ll learn: What are the uses of SQL Server 2012 Management Studio
Importing data into your new database
Managing Security
Check your knowledge
Module 5 – Creating the Contoso Clinic Database
In this module, you’ll learn: How to create a new database from scratch
Working with Schemas
How to import/export data from/to the Contoso Clinic Database
How to create Primary Keys, Foreign Keys and relationships between tables
How to work with Views, Stored Procedures and User-Defined Functions
Check your knowledge
Module 6 – Maintaining the Contoso Clinic Database
How to manage storage properly Using Transparent Encryption to protect the database
Managing Backups
Using Maintenance Plans
Check your knowledge
Module 7 – Turning Data to useful information
Advanced data import using Integration Services. Improving data quality using Data Quality Services. Creating pre-defined reports using Reporting Services. Business User Interactivity with reports.
Building a Statistical Analysis Model using Analysis Services.
HERE’S SOME IDEA ABOUT WHAT YOU’LL LEARN DURING THIS TRAINING
Effective installation and configuration of SQL Server
End-to-end SQL Server Management
Copyright Notice and Disclaimer
THIS STUDENT MANUAL IS THE INTELLECTUAL PROPERTY OF SHARPER SOFTWARE
(HTTP://WWW.SHARPERSOFTWARE.COM) AND IS LICENSED TO YOU FOR THE PURPOSES OF THIS TRAINING ONLY. IT
IS PROTECTED BY KUWAITI LAW NO. 63 FOR YEAR 1999 REGARDING INTELLENCTUAL PROPERTY RIGHTS. IT IS ILLEGAL TO MAKE COPIES OF THIS DOCUMENT OR THE ACCOMPANYING SOFTWARE, FULLY OR IN PART WITHOUT A WRITTEN PERMISSION FROM SHARPER SOFTWARE. FOR MORE INFORMATION ABOUT THIS LAW, PLEASE VISIT
http://www.wipo.int/wipolex/en/details.jsp?id=2784.
SHARPER SOFTWARE MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS DOCUMENT.
THE EXAMPLE COMPANIES, ORGANIZATIONS, PRODUCTS, DOMAIN NAMES, E-MAIL ADDRESSES, LOGOS, PEOPLE, PLACES, AND EVENTS DEPICTED HEREIN ARE COMPLETELY FICTITIOUS. NO ASSOCIATION WITH ANY REAL
COMPANY, ORGANIZATION, PRODUCT, DOMAIN NAME, E-MAIL ADDRESS, LOGO, PERSON, PLACE, OR EVENT IS INTENDED OR SHOULD BE INFERRED.
