SQL Server 2008 for Administration

Course ID

914000

Course Description

This instructor-led course provides you with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. You will learn to use SQL Server 2008 R2 product features and tools to install and configure a database, manage database files, and create and tune indexes. This course incorporates materials from the Official Microsoft Learning Product 6231: Maintaining a Microsoft SQL Server 2008 R2 Database.

Prerequisites


Audience

  • IT professionals who administer and maintain SQL Server databases
  • Individuals who develop applications that deliver content from SQL Server databases


    • Course Content

  • Plan, install, and configure SQL Server 2008 R2
  • Manage database files
  • Back up and restore databases
  • Manage security
  • Implement SQL Server 2008 R2 audits
  • Configure and assign permissions
  • Monitor data by using dynamic management views
  • Manage SQL Server 2008 R2 agent and jobs
  • Execute multi-server queries and configure a central management server
  • Deploy a data-tier-application
  • Troubleshoot common issues

    • For More Information

    For training inquiries, call 850-308-1376

    or email us at eramos@gbsi.com

    Course Details

    Duration - 5 days
    Price - $2995.00 USD


    (Discounts may apply. Call for more information.)

    Course Actions

    Schedule

    Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.