Toll Free: 1.877.290.9507 | Direct:708.689.0131

Administering Microsoft SQL Server 2012 Databases (MS-10775)

Administering Microsoft SQL Server 2012 Databases

Microsoft SQL Server 5-Day Training

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462.

All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Azure database in the cloud. Your instructor should be able to provide a current list of Azure enabled labs. 

Total Price: $-,---

Click to Show Course Pricing

Information about this course:

This course is offered as:

  • Classroom Instructor-led Boot Camp
  • Live Online Instructor-led Boot Camp
  • Mentored Self-Paced Online
  • Streaming-Only Self-Paced Online

Course Highlights
  • 93% Pass Rate
  • Hands-on training with latest technologies
  • Complex sims & exercises, gives you practical hands-on experience
award-winning-training
At Course Completion:
After Completing this course, students will be able to:
  • Plan  and install SQL Server.
  • Describes the system databases, the physical structure of databases and the most common configuration options related to them.
  • Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
  • Create SQL Server Backups.
  • Restore SQL Server databases.
  • Use the import/export wizards and explain how they relate to SSIS.
  • Work with SQL Server security models, logins and users.
  • Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
  • Work with permissions and the assignment of permissions.
  • Work with SQL Server Audit.
  • Work with SQL Server Agent, jobs and job history.
  • Implement SQL Server agent security, proxy accounts and credentials.
  • Configure database mail, alerts and notifications.
  • Create database maintenance plans.
  • Work with SQL Profiler and SQL Trace stored procedures.
  • Introduce DMVs and the configuration of data collection.
  • Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
  • Troubleshoot SQL Server databases.
Who Should Attend:
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

What's Included:

Only Intense School’s Boot Camp offers you the following benefits:

  • 5 full days of intense instruction with no outside distractions
  • Exam Vouchers for exams
  • Microsoft Press E-Reference Library, including all Training Kits, Exam References, and Rapid Review books
  • 2nd shot vouchers - in case you do not pass an exam
  • Pre-Class Prep Materials
  • In-person access to the top experts in the industry
  • Lunch and snacks provided on each day of class

FREE MICROSOFT TRAINING!

Redeem Microsoft SATV Training Vouchers HERE

Click here to get more information about this class!

Instantly View Course Syllabus and price

View Course Calendar

Unfortuantely, no public enrollment courses currently match your criteria. Contact Us Here to find out other options with this class.





Select the type of training that best fits your schedule and learning style!

Live, Online, Self-Paced, Classroom - contact us for details on each.

Self-Paced

Streaming Only

Base option for limited budgets

  • Easy Online Access
  • Expert Microsoft Instructor
  • Exam Review
  • Highest Quality Content - 90% Pass
  • Self-Paced Training
Self-Paced

Mentored Online

Most popular self-paced option.

  • Online & Offline Playback (DVD,mobile)
  • Expert Microsoft Instructor
  • Intense Proprietary Exam Prep
  • Highest Quality Content - 90% Pass
  • Hands-On Lab Exercises
  • Self-Paced Mentored Training
  • Mentor & Live Instructor Support
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Exercise Files
Classroom

Instructor-Led

Our top rated training experience

  • Live Classroom
  • Expert Microsoft Instructor
  • Intense Proprietary Exam Prep
  • Highest Quality Content - 90% Pass
  • Microsoft Certification Library
  • Hands-On Lab Exercises
  • Lunch, Snacks
  • Train In-Person at Training Facility
  • Exam Vouchers
  • 2nd Shot Exam Voucher
  • Pre-Shipment of Pre-Study Books
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Exercise Files
Classroom

Live Online

Live experience from home or work

  • Live Online Classroom
  • Expert Microsoft Instructor
  • Intense Proprietary Exam Prep
  • Highest Quality Content - 90% Pass
  • Microsoft Certification Library
  • Hands-On Lab Exercises
  • Exam Vouchers
  • 2nd Shot Exam Voucher
  • Pre-Shipment of Pre-Study Books
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Exercise Files

Course Outline

Module 1: Introduction to SQL Server 2012 and its Toolset
This module introduces the entire SQL Server platform and its major tools. It covers editions, versions, basics of network listeners, and concepts of services and service accounts.
Lessons

Lab : Introduction to SQL Server and its Toolset

After completing this module, students will be able to:

Module 2: Preparing Systems for SQL Server 2012
This module covers planning for an installation related to SQL Server I/O requirements, 32 bit vs 64 bit, memory configuration options and I/O subsystem pre-installation checks using SQLIOSim and SQLIO.
Lessons

Lab : Preparing Systems for SQL Server

After completing this module, students will be able to:

Module 3: Installing and Configuring SQL Server 2012
This module details installing and configuring SQL Server.
Lessons

Lab : Installing and Configuring SQL Server

After completing this module, students will be able to:

Module 4: Working with Databases
This module describes how data is stored in databases, how to create databases, and how to move databases either within a server or between servers.
Lessons

Lab : Working with Databases

After completing this module, students will be able to:

Module 5: Understanding SQL Server 2012 Recovery Models
This module describes the concept of the transaction log and SQL Server recovery models. It introduces the different backup strategies available with SQL Server.
Lessons

Lab : Understanding SQL Server Recovery Models

After completing this module, students will be able to:

Module 6: Backup of SQL Server 2012 Databases
This module describes SQL Server Backup and the backup types.
Lessons

Lab : Backup of SQL Server Databases

After completing this module, students will be able to:

Module 7: Restoring SQL Server 2012 Databases
This module describes the restoration of databases.
Lessons

Lab : Restoring SQL Server 2012 Databases

After completing this module, students will be able to:

Module 8: Importing and Exporting Data
This module covers the use of the import/export wizards and explains how they relate to SSIS. Also introduces BCP.
Lessons

Lab : Importing and Exporting Data

After completing this module, students will be able to:

Module 9: Authenticating and Authorizing Users
This module covers SQL Server security models, logins and users.
Lessons

Lab : Authenticating and Authorizing Users

After completing this module, students will be able to:

Module 10: Assigning Server and Database Roles
This module covers fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
Lessons

Lab : Assigning Server and Database Roles

After completing this module, students will be able to:

Module 11: Authorizing Users to Access Resources
This module covers permissions and the assignment of permissions.
Lessons

Lab : Authorizing Users to Access Resources

After completing this module, students will be able to:

Module 12: Auditing SQL Server Environments
This module covers SQL Server Audit.
Lessons

Lab : Auditing SQL Server Environments

After completing this module, students will be able to:

Module 13: Automating SQL Server 2012 Management
This module covers SQL Server Agent, jobs and job history.
Lessons

Lab : Automating SQL Server Management

After completing this module, students will be able to:

Module 14: Configuring Security for SQL Server Agent
This module covers SQL Server agent security, proxy accounts and credentials.
Lessons

Lab : Configuring Security for SQL Server Agent

After completing this module, students will be able to:

Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
This module covers the configuration of database mail, alerts and notifications.
Lessons

Lab : Monitoring SQL Agent Jobs with Alerts and Notifications

After completing this module, students will be able to:

Module 16: Performing Ongoing Database Maintenance
This module covers database maintenance plans.
Lessons

Lab : Performing Ongoing Database Maintenance

After completing this module, students will be able to:

Module 17: Tracing Access to SQL Server 2012
This module covers SQL Profiler and SQL Trace stored procedures.
Lessons

Lab : Tracing Access to SQL Server 2012

After completing this module, students will be able to:

Module 18: Monitoring SQL Server 2012
This module introduces DMVs and the configuration of data collection.
Lessons

Lab : Monitoring SQL Server 2012

After completing this module, students will be able to:

Module 19: Managing Multiple Servers
This module covers Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
Lessons

Lab : Managing Multiple Servers

After completing this module, students will be able to:

Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues
This module covers common issues that require troubleshooting and gives guidance on where to start looking for solutions.
Lessons

Lab : Troubleshooting Common Issues

After completing this module, students will be able to:

The class more than exceeded my expectations. The material was exactly what i needed to get my certifications and more. There was not one question the professor could not answer.

- George Embrey
IMC

He was very knowledgable in the course material and presented it in a very methodical way. The course materials were great and are resources we will use in the future.

- Ralph Polk
Brooke Army Medical Center (CTR)

The instructor did a great job, his guidance on the skills of passing the exams was most valuable.

- George Ballane
Unavailable

The instructor was able to not only answer all the questions we had in class and after hours he was able explain the technologies and real world reasons behind using technology A vs B. He adapted the class as needed for all students. I have only had one other instructor at his level in my 15 year career in IT.

- Doug Lloyd - MESA
University of Georgia

The instructor was very knowledgeable, and was able to explain complicated technologies in a way that was easy to comprehend. I was given everything I needed to learn and complete my course with confidence.

- Travis Drennan

My instructor is a freaking genius, however he really enjoys bringing the info and material to life so in a way you do catch a bit of genius by the end of the course.

- Samuel Angura
World Bank

Prerequisites?
Before attending this course, students must have:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design..
Certifications

...

States