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 2

Course Summary

Part 2 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

    ● Performance
        ◦ Introduction
        ◦ SQL Profiler/SQL Trace (T-SQL)
        ◦ Windows System Monitor
        ◦ Activity Monitor
        ◦ Transact-SQL
        ◦ Windows Logs
        ◦ Default Trace
        ◦ Dynamic Management Views
        ◦ Monitoring Tools Comparison
        ◦ What We Covered and Terminology
    ● Automating Administrative Tasks
        ◦ Introduction
        ◦ SQL Server Agent
        ◦ Configuring SQL Server Agent
        ◦ Key Fixed Database Roles
        ◦ Creating and Running Jobs
        ◦ Subsystem
        ◦ Proxy
        ◦ Security Guidelines
    ● High Availability
        ◦ Introduction
        ◦ SQL Server Failover Clustering
        ◦ SQL Server Database Mirroring
        ◦ SQL Server Log Shipping
        ◦ SQL Server Replication
        ◦ What We Covered and Terminology
    ● Replication
        ◦ Introduction
        ◦ What's the Problem to Solve?
        ◦ SQL Server Replication Concepts
        ◦ SQL Server Roles
        ◦ Creating Replication Admin Account
        ◦ Changing Firewall Settings
        ◦ Giving Replication Admin Access to the SQL Server
        ◦ Adding Replication Accounts to Database
        ◦ Creating Publication
        ◦ Creating Push Subscription
        ◦ Best Practices
    ● Resource Governor
        ◦ Introduction
        ◦ Troubleshooting SQL Server
        ◦ Resource Governor and Resource Pools
        ◦ Creating a Resource Pool
        ◦ Workload Groups
        ◦ Creating a Workload Group
        ◦ Classification
        ◦ Creating a Classifier Function
        ◦ What We Covered and Terminology
    ● Performing Data Management Tasks
        ◦ Importing and Exporting
        ◦ Permissions for Importing and Exporting
        ◦ Maintaining Indexes
        ◦ Clustered vs. Nonclustered
        ◦ Creating Indexes
        ◦ Full-Text Indexing
        ◦ What We Covered and Terminology
    ● Data Compression
        ◦ Introduction
        ◦ Row Compression and Page Compression
        ◦ Data Partitions
        ◦ Table Compression via T-SQL
        ◦ Compressing Backups
        ◦ What We Covered and Terminology
    ● SQL Server 2008 Common Commands
        ◦ Introduction
        ◦ Database Console Commands (DBCC)
        ◦ Running DBCC CHECKTABLE and DBCC CHECKDB Commands
        ◦ Setting Server Configuration Options
        ◦ sp_configure clr enabled Command
        ◦ sp_configure c2 audit mode Command
        ◦ sp_configure fill factor Command
        ◦ Final Thoughts on sp_configure
    ● Database Mail
        ◦ The Players and SMTP
        ◦ Installing and Configuring SMTP
        ◦ Database Mail Profiles and Accounts
        ◦ Configuring Database Mail
        ◦ What We Covered and Terminology
    ● SQL Server 2008 Certification 101
        ◦ Introduction
    ● Running SQL Server 2008 in Hyper-V
        ◦ Why Would You Want to Do SQL VM?
        ◦ Multiple Instances vs. Virtualization
        ◦ Hardware Considerations
        ◦ Creating a New Virtual Machine
        ◦ What We Covered

     


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