MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server 2008 Advanced Database Administration: Part 2

Course Summary

Part 2 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out


  • +

    Course Syllabus


    Course Fee:
    USD 29
    ● SQL Server 2008 Policy-Based Management
        ◦ Introduction
        ◦ Policy-Based Management Benefits
        ◦ Policy-Based Management Terms and Concepts
        ◦ Setting Up Naming Restrictions
        ◦ Controlling Feature State
        ◦ Security
        ◦ Adding a User to the Policy Administrator Role
        ◦ Recap and Other Things to Remember
        ◦ What We Covered
    ● SQL Server 2008 Data Encryption
        ◦ Introduction
        ◦ Encryption Background Information
        ◦ SQL Server 2008 Encryption Hierarchy
        ◦ Encryption Hierarchy Components
        ◦ Data Encryption vs. Transparent Data Encryption
        ◦ SQL Server 2008 Column Encryption
        ◦ Column Decryption
        ◦ Transparent Data Encryption
        ◦ Encryption Algorithms
        ◦ Vocabulary Review
        ◦ What We Covered
    ● SQL Server 2008 Backup and Recovery
        ◦ Introduction
        ◦ SQL Server 2008 Files
        ◦ SQL Server 2008 System Databases
        ◦ Creating a Basic Backup
        ◦ Database Recovery Models
        ◦ Backup Types
        ◦ Backup and Restore with TDE Enabled
        ◦ Using Snapshots in SQL Server 2008
        ◦ What We Covered
    ● SQL Server 2008 High Availability
        ◦ Introduction
        ◦ High Availability Options
        ◦ Failover Clustering
        ◦ Pros and Cons of Failover Clustering
        ◦ Database Mirroring
        ◦ Pros and Cons of Database Mirroring
        ◦ Log Shipping
        ◦ Replication
        ◦ Replication and Database Mirroring
        ◦ Selecting a High Availability Solution
        ◦ What We Covered
    ● SQL Server 2008 Failover Clustering
        ◦ Introduction
        ◦ Key Terms to Know
        ◦ Prerequisites
        ◦ Introduction to SQL Server 2008 Clustering Installation Process
        ◦ SQL Server 2008 Clustering Options
        ◦ What We Covered
    ● SQL Server 2008 Database Mirroring
        ◦ Introduction
        ◦ Mirroring Overview
        ◦ Operating Modes
        ◦ Mirroring Roles
        ◦ Mirroring Service Account
        ◦ Setting Up Server Engine Service Accounts
        ◦ Database Mirroring Sessions
        ◦ Creating Database Mirroring Endpoints
        ◦ Role Switching
        ◦ Configuring Endpoints and Starting Mirroring
        ◦ Recommendations and Restrictions
        ◦ What We Covered
    ● SQL Server 2008 Log Shipping
        ◦ Introduction
        ◦ Log Shipping Overview
        ◦ SQL Server 2008 Supported Editions
        ◦ Log Shipping Jobs
        ◦ Setting Up Log Shipping
        ◦ Log Shipping Failover
        ◦ Primary Server Tables
        ◦ Secondary Server Tables
        ◦ What We Covered
    ● SQL Server 2008 Replication
        ◦ Introduction
        ◦ The Need for Replication
        ◦ What is SQL Server Replication?
        ◦ Two Categories of Replication: Server to Server
        ◦ Replication Roles: Publisher, Distributor, and Subscriber
        ◦ Replication Agents
        ◦ Replication Configuration
        ◦ Adding Computers to the Domain
        ◦ Creating Domain Accounts
        ◦ Replication User Accounts
        ◦ Configuring the Firewall
        ◦ Installing SQL Server and Replication
        ◦ Configuring Distribution
        ◦ Creating the Publication
        ◦ Configuring the Subscriber
        ◦

    Course Type:

    Self-Study

    Course Status:

    Active

    Workload:

    1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top