Course 10775A
Administering Microsoft®
SQL Server® 2012
Databases
Welcome!
Thank you for taking our training. We’ve worked together with our Microsoft
Certified Partners for Learning Solutions and Microsoft IT Academies to bring
you a world-class learning experience, including:
Microsoft Certified Trainers + Instructors. Your instructor is a premier
technical and instructional expert who meets ongoing certification
requirements.
Customer Satisfaction Guarantee. Our Certified Partners for Learning
Solutions offer a satisfaction guarantee and we hold them accountable for it.
At the end of class, please complete an evaluation of your class experience.
We value your feedback!
Certification Exam Benefits. After training, consider taking a Microsoft
Certification exam. Independent research by IDC concluded that 75% of
managers believe certifications are important to team performance*. Ask your
instructor about
b available
l bl exam promotions and dddiscounts.
We wish you a great learning experience and ongoing career success!
* IDC, Value of Certification: Team Certification and Organizational Performance, November 2006
Introduction
• Name
• Company affiliation
• Title/function
• Job responsibility
• SQL Server experience
• Your expectations for the course
Course Material
Course Companion Content on the
Course Handbook http://www.microsoft.com/learning/compa
nionmoc Site
A succinct classroom learning ggguide Searchable,, easy-to-navigate
y g digital
g
that provides critical technical content with integrated premium
information to optimize your on-line resources designed to
in-class learning experience. supplement the Course Handbook.
Student Course files required
q for the
labs and demonstrations.
Module Content
Labs Supplemental Course Content
Module Reviews and Takeaways Student Course Files
Lab Answer Keys
http://www.microsoft.com/learning/
How to Use the Course Material
Course Companion Content on the
Course Handbook http://www.microsoft.com/learning/
companionmoc Site
• Use the handbook content as the • Use the Companion Content as your
primary resource for reference during extended learning resource on the
the class. job.
• Use the troubleshooting tips and best
practices
ti iin th
the MModule
d l Reviews
R i and
d
Takeaways section as on-the-job
references.
http://www.microsoft.com/learning/
Facilities
• Class hours
• Building hours
• Parking
• Restrooms
• Meals
• Phones
• Messages
• Smoking
• Recycling
Microsoft Learning
Course 10774A: Querying Microsoft
SQL Server 2012
Course 10775A: Administering Microsoft SQL
Server 2012 Databases
Course 10776A: Developing Microsoft SQL Server
2012 Databases
http://www.microsoft.com/learning/
About This Course
• Audience
• Course Prerequisites
• Course Objectives
Course Outline – Modules 1 - 10
• Module 1: Introduction to SQL Server 2012 and Its Toolset
• Module 2: Preparing Systems for SQL Server 2012
• Module 3: Installing and Configuring SQL Server 2012
• Module 4: Working with Databases
• Module 5: Understanding SQL Server 2012 Recovery
Models
• Module 6: Backup of SQL Server 2012 Databases
• Module 7: Restoring SQL Server 2012 Databases
• Module 8: Importing and Exporting Data
• Module 9: Authenticating and Authorizing Users
• Module 10: Assigning Server and Database Roles
Course Outline – Modules 11 - 20
• Module 11: Authorizing Users to Access Resources
• Module 12: Auditing SQL Server 2012 Environments
• Module 13: Automating SQL Server 2012 Management
• Module 14: Configuring Security for SQL Server Agent
• Module 15: Monitoring SQL Server 2012 with Alerts and
Notifications
• Module 16: Performing Ongoing Database Maintenance
• Module 17: Tracing Access to SQL Server 2012
• Module 18: Monitoring SQL Server 2012
• Module 19: Managing Multiple Servers
• Module 20: Troubleshooting Common SQL Server 2012
Administrative Issues
Course Outline – Appendix
• Core Concepts in SQL Server High Availability and Replication
• Provided for self study only
• N t covered
Not d in
i course labs
l b
Introduction to Adventure Works
Adventure Works
Bicycle Manufacturing Company
• In the labs throughout this course, you will work for
Adventure Works
• As you complete the labs, you will implement SQL Server
2012
Virtual Machine Environment
Virtual machine Used as:
10775A-MIA-SQL1 Virtual machine for Modules 01 - 20
Note: Before the lab in each module, you must
revert the virtual machines as per the
instructions in D:\10775A_Labs\Revert.txt
Demonstration: Using Microsoft Hyper-V Server
Help the students to familiarize with the Hyper-V Server
environment in which they will work to complete the
course’s labs.
In this demonstration, you will learn how to:
1. Connect to Hyper-V
yp Manager.
g
2. Connect to a virtual machine using the Virtual Machine
Remote Control Client.
3. Revert the virtual machines.
