Microsoft SQL Server 2008, Implementation and Maintenance

  • Overview

    This instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database. After completing this course, students will be able to deploy a data-tier-application.

    Course Objectives

    • Understand SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
    • Plan, install and configure SQL Server 2008 R2
    • Backup and restore databases
    • Use BCP and BULK INSERT to import data
    • Assign, configure fixed database roles and create and assign user defined database roles
    • Configure and assign permissions and manage security
    • Implement SQL Server 2008 R2 Audits
    • Manage SQL Server 2008 R2 Agent and Jobs
    • Configure and maintain database mails, alerts and notifications
    • Monitor data by using Dynamic Management Views
    • Execute multi-server queries and configure a central management server

    Course Content / Exam(s)

    Schedule for Microsoft SQL Server 2008, Implementation and Maintenance Boot Camp Training
    Course# Course Contents Exam# Regular Track (days)
    6231B Maintaining a Microsoft SQL Server 2008 R2 Database 70-432 * 6
    Balance Days Microsoft SQL Server 2008 Training Course, Certification Exam (70-432) for Implementation and Maintenance for day of arrival, exam(s) and practice 3
    Total duration 9

    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.
    • Completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.
    Recommended Courses and Certification:
  • Students Reviews
    Sulaiman Al-Nassri  Koenig IT Training Student

    I am Sulaiman Al-Nassri from Oman, I work as a Web Developer at my organization Oman Medical Specialty Board (OMSB). I’m here in India with my friend Sultan studying at Koenig Solutions. This is my...

    Read MoreSulaiman Al-Nassri Oman
    Ramkrishna Paul  Koenig IT Training Student

    Hi, I’m Ramkrishna Paul from Bangladesh. As I am IT professional & have handled hundreds of organizational computers in Active Directory environment, I was searching a tool with which I can manage...

    Read MoreRamkrishna Paul Bangladesh
    Rajkumar Vallabhu  Koenig IT Training Student

    In one word it was fabulous and awesome experience and I haven’t got any single point where I can say this was not good. There was a warm welcome from the Cab driver who drove me to the Koenig Inn...

    Read MoreRajkumar Vallabhu India
    Asef Azimy  Koenig IT Training Student

    Studying in Koenig was as a result of the discussion between my IT officer Mr. Dan and Me; he promoted me to take action. There are training institutes in Afghanistan also but I decided to pursue my...

    Read MoreAsef Azimy Afghanistan
    Jason P Carlton  Koenig IT Training Student

    The staff at Koenig Solutions has been nothing but professionalism and a helpfulness that goes beyond the norm.  I am especially pleased that I choose Dehradun as the location for my Microsoft...

    Read MoreJason P Carlton United States
    View All Testimonials
  • Schedule & Prices
  • Enquire Now