Course Overview

Key Features

  • 6 Hrs of HQ e-learning content
  • 70 High Quality Lectures
  • Topics on Database Mirroring & Failover Clustering
  • Covers Partition Planning & Event Forwarding
  • Downloadable Work Files
  • Course Completion Certificate

Training Options

Self-Paced Learning

$ 49

  • Lifetime access to high-quality self-paced e-learning content curated by industry experts
  • 24x7 learner assistance and support

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Course Content

  • Microsoft® SQL Server 2008 Administration

    Preview
    • Module 01 - Introduction

      28:28Preview
      • 1.1 Welcome
        01:46
      • 1.2 Course Overview
        03:25
      • 1.3 SQL Server Basics
        07:06
      • 1.4 Getting Hands On
        04:23
      • 1.5 Microsoft SQL Certifications
        05:41
      • 1.6 SQL Server Editions
        06:07
    • Module 02 - Installing SQL Server 2008

      01:03:44Preview
      • 2.1 Hardware Requirements
        04:05
      • 2.2 SQL Server Instances
        04:46
      • 2.3 SQL Server Components
        04:21
      • 2.4 Collation Choices
        03:38
      • 2.5 Service Accounts
        05:41
      • 2.6 Creating Service Accounts
        02:39
      • 2.7 Installing SQL Server 2008 pt. 1
        06:13
      • 2.8 Installing SQL Server 2008 pt. 2
        05:00
      • 2.9 Installing SQL Server 2008 pt. 3
        04:59
      • 2.10 Upgrading SQL Server 2008
        03:16
      • 2.11 SQL Server Configuration Manager
        04:00
      • 2.12 SQL Server Authentication Modes
        05:00
      • 2.13 Changing Authentication Modes
        04:02
      • 2.14 SQL Server Management Studio
        06:04
    • Module 03 - SQL Server 2008 Databases

      01:16:12Preview
      • 3.1 File Types
        03:40
      • 3.2 Transaction Log
        05:55
      • 3.3 System Databases
        06:18
      • 3.4 File Placement
        04:39
      • 3.5 Creating a Database
        06:16
      • 3.6 Autogrowth
        05:53
      • 3.7 Database Options
        05:25
      • 3.8 Sizing the Transaction Log
        03:53
      • 3.9 Schemas
        06:21
      • 3.10 Default Schema
        05:46
      • 3.11 Creating a Schema
        06:11
      • 3.12 Moving Data Files
        05:50
      • 3.13 Installing Sample Databases pt. 1
        06:17
      • 3.14 Installing Sample Databases pt. 2
        03:48
    • Module 04 - Maintaining SQL Server

      30:25Preview
      • 4.1 Hiding System Objects
        04:20
      • 4.2 SQL Server Agent
        05:50
      • 4.3 Creating a Maintenance Plan
        06:35
      • 4.4 Understanding Operators
        02:10
      • 4.5 Understanding Jobs
        05:33
      • 4.6 Understanding Alerts
        05:57
    • Module 05 - Server Management

      34:40Preview
      • 5.1 SQL Server Options
        06:26
      • 5.2 Registering Servers
        03:59
      • 5.3 Server Configuration
        05:04
      • 5.4 Activity Monitor
        03:31
      • 5.5 Database Mail pt. 1
        03:53
      • 5.6 Database Mail pt. 2
        06:39
      • 5.7 Database Mail pt. 3
        05:08
    • Module 06 - Maintaining The Database

      40:53Preview
      • 6.1 Maintaining the Database
        04:13
      • 6.2 Database Backup pt. 1
        05:34
      • 6.3 Database Backup pt. 2
        06:02
      • 6.4 Backup Compression
        05:52
      • 6.5 Backup Devices
        05:58
      • 6.6 Managing the Transaction Log
        06:32
      • 6.7 Restoring the Database
        06:42
    • Module 07 - Monitoring And Troubleshooting

      22:23
      • 7.1 Dedicated Administrator Connection
        04:59
      • 7.2 SQL Profiler pt. 1
        05:04
      • 7.3 SQL Profiler pt. 2
        05:38
      • 7.4 Log File Viewer
        04:13
      • 7.5 Event Forwarding
        02:29
    • Module 08 - Optimizing Performance

      26:22Preview
      • 8.1 Using Filegroups
        04:36
      • 8.2 Partitions
        06:19
      • 8.3 Partition Planning
        05:01
      • 8.4 Database Tuning Advisor pt. 1
        06:03
      • 8.5 Database Tuning Advisor pt. 2
        04:23
    • Module 09 - High Availability

      19:26Preview
      • 9.1 High Availability Options
        06:21
      • 9.2 Failover Clustering
        02:38
      • 9.3 Database Mirroring
        05:30
      • 9.4 Log Shipping
        04:57
    • Module 10 - Conclusion

      04:40
      • 10.1 Course Wrap Up
        04:40
    • Module 11 - Credits

      02:50
      • 11.1 About the Author
        02:50

Why Online Bootcamp

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

FAQs

  • How do I enroll for the online training?

    You can enroll for the online training through our website. You can make online payment using any of the following options:
    • Visa debit/credit card
    • American Express and Diners Club cards
    • Master Card
    • PayPal
    Once the online payment is done, you will automatically receive payment receipt, via email.

  • What will I get along with this training?

    In this training, you will have access to online e-learning.

  • Do you provide money back guarantee for the training programs?

    Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

  • Can I cancel my enrollment? Do I get a refund?

    Yes! You can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more, please go through our Refund Policy.

  • Where and how can I access the e-learning content? Are there any limitations?

    Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

  • I am not able to access the online course. Whom should I contact for a solution?

    Please raise a request via our Help and Support portal to have your issue resolved.

  • How do I track the hours already spent on the course?

    You can track the number of hours spent on the course by accessing your LMS home.

  • Can I extend the access period?

    Yes, you can extend the access period by paying an additional fee. Please raise a request via our Help and Support portal.

  • Do you provide any group discounts for online training programs?

    Yes, we offer group discounts for our online training programs. Get in touch with us over the Drop us a Query/Request a Callback/Live Chat channels to find out more about our group discount packages.

  • How does Simplilearn assure that the material and the training delivered are effective?

    Simplilearn follows a Global Learning Framework which has been proven to deliver results and has been perfected by our training experience.

  • Do you provide any course completion certificate?

    Yes! We offer course completion certificate after you successfully complete the training program.

  • I want to know more about the training program. Whom do I contact?

    Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.