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 3

Course Summary

Part 3 of 3 in the SQL Server 2008 Advanced Database Administration series will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security.

  • +

    Course Syllabus

    SQL Server 2008 Resource Governor
    - 1h 3m

    —Introduction 2m 35s
    —Activity Monitor 8m 4s
    —Trace Flags 3m 39s
    —SQL Server 2008 Reports 5m 46s
    —Job Activity Monitor 2m 46s
    —SQL Server 2008 Logs 3m 43s
    —Dynamic Management Views and Functions 6m 31s
    —Using Dynamic Management Views 9m 41s
    —SQL Server Audits 8m 56s
    —Dedicated Administrator Connection (DAC) 9m 30s
    —What We Covered 2m 1s
    Monitoring SQL Server 2008
    - 28m 11s

    —Introduction 1m 9s
    —SQL Server Profiler 2m 50s
    —Database Engine Tuning Advisor 3m 23s
    —Using the SQL Server Profiler and Database Engine Tuning Advisor 11m 11s
    —Query Analysis and Execution Plans 1m 1s
    —Using Execution Plans for Query Analysis 5m 45s
    —Other Performance Tuning Tools 0m 41s
    —What We Covered 2m 11s
    SQL Server 2008 Performance Tuning
    - 21m 44s
    SQL Server 2008 PowerShell
    - 27m 38s
    SQL Server 2008 Integration Services
    - 32m 32s
    Preparing for Your MCITP: 70-450 Certification Exam
    - 8m 57s
    Next Steps
    - 3m 43s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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