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 Administration (70-432): Part 1

Course Summary

Part 1 of 2 in the SQL Server 2008 Administration (70-432) series. This SQL Server 2008 Administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, replication, and optimize


  • +

    Course Syllabus

    ● Introduction to SQL Server 2008 Administration
        ◦ Introduction
        ◦ What's Covered in This Course
        ◦ The Environment
    ● Welcome to SQL Server 2008
        ◦ Introduction
        ◦ Solutions
        ◦ Data Engine
        ◦ Analysis and Integration Services
    ● Installing SQL Server 2008
        ◦ Introduction
        ◦ SQL Server 2008 Editions
        ◦ SQL Server 2008 Requirements
        ◦ Downloading SQL Software
        ◦ SQL Server Security 101
        ◦ SQL Server Installation Center Overview
        ◦ Launching SQL Server 2008 Management Studio
        ◦ What We Covered & Terminology
    ● Introduction to SQL Server 2008 Tools
        ◦ Introduction
        ◦ SQL Server Business Intelligence Development Studio Overview
        ◦ Analysis Services and Configuration Tools Overview
        ◦ Windows PowerShell 1.0 Overview
        ◦ SQL Server Management Studio Overview
        ◦ Query Interface Overview
        ◦ What We Covered & Terminology
    ● Creating SQL Server 2008 Databases
        ◦ Introduction
        ◦ Database Planning
        ◦ Creating Databases - Overview
        ◦ Creating Veronica's Veronicas Database - General Page
        ◦ Creating Veronica's Veronicas Database - Options Page
        ◦ Creating a New Table
        ◦ Database Diagrams
        ◦ Creating Database Diagrams
        ◦ Database Views
        ◦ Creating a New View
        ◦ Creating a Synonym
        ◦ Recommendations
        ◦ What We Covered & Terminology
    ● Configuring SQL Server 2008 Security
        ◦ Introduction
        ◦ SQL Server Security Landscape
        ◦ Physical Security
        ◦ Managing User Access
        ◦ Creating SQL Login and SQL User Account
        ◦ Testing SQL User Account
        ◦ Setting SQL User Permissions
        ◦ Server-Level Role vs. Database-Level Role
        ◦ Schemas Overview
        ◦ Protecting Your Data - Auditing SQL Server
        ◦ Configuring 'Surface Area'
        ◦ File Security and SQL Server Data Encryption
        ◦ SQL Server SA Login and Certificate-Based SQL Server Login
        ◦ Information_Schema and Sys
        ◦ Best Practices
        ◦ What We Covered and Terminology
    ● Implementing Disaster Recovery
        ◦ Introduction
        ◦ SQL Server Recovery Models
        ◦ Full Recovery Model
        ◦ Bulk Logged Recovery Model
        ◦ Simple Recovery Model
        ◦ Backup Types
        ◦ Full Database Backups
        ◦ Restoring a Database
        ◦ Full File Backups
        ◦ Recovery Requirements
        ◦ Maintenance Plan Wizard
        ◦ Best Practices
        ◦ What We Covered and Terminology
        

     


Course Fee:
USD 29

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