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. To get the most out of this cour


  • +

    Course Syllabus

    ● SQL Server 2008 Resource Governor
        ◦ Introduction
        ◦ Activity Monitor
        ◦ Trace Flags
        ◦ SQL Server 2008 Reports
        ◦ Job Activity Monitor
        ◦ SQL Server 2008 Logs
        ◦ Dynamic Management Views and Functions
        ◦ Using Dynamic Management Views
        ◦ SQL Server Audits
        ◦ Dedicated Administrator Connection (DAC)
        ◦ What We Covered
    ● Monitoring SQL Server 2008
        ◦ Introduction
        ◦ SQL Server Profiler
        ◦ Database Engine Tuning Advisor
        ◦ Using the SQL Server Profiler and Database Engine Tuning Advisor
        ◦ Query Analysis and Execution Plans
        ◦ Using Execution Plans for Query Analysis
        ◦ Other Performance Tuning Tools
        ◦ What We Covered
    ● SQL Server 2008 Performance Tuning
        ◦ Introduction
        ◦ Managing Resource Utilization
        ◦ Grouping Server Resources and Classification
        ◦ Classifier Functions
        ◦ Creating a Classifier Function
        ◦ Security for Resource Governor
        ◦ Resource Pools
        ◦ Creating a Resource Pool
        ◦ Creating the Resource Pool and Workload Group
        ◦ Vocabulary Review
        ◦ What We Covered
    ● SQL Server 2008 PowerShell
        ◦ Introduction
        ◦ Introduction to PowerShell
        ◦ Running PowerShell 1.0 with SQL Server 2008
        ◦ Launching PowerShell
        ◦ Execution Policy Setting
        ◦ Using Execution Policy Cmdlets
        ◦ The SQL Server PowerShell Virtual Drive SQLSERVER
        ◦ Foundational PowerShell Commands
        ◦ SQL Server Specific Cmdlets
        ◦ What We Covered
    ● SQL Server 2008 Integration Services
        ◦ Introduction
        ◦ Introduction to Integration Services (SSIS)
        ◦ Installation and Configuration
        ◦ SSIS Service Account and Firewall
        ◦ Modifying MsDtsSrvr.ini.xml and the Windows Registry
        ◦ SSIS Configuration File
        ◦ Running an Integration Services Package
        ◦ Using the 'Integration Services' (Import/Export) Wizard
        ◦ Rerunning a Package Via SSMS
        ◦ Other Methods of Running a Package
        ◦ What We Covered
    ● Preparing for Your MCITP: 70-450 Certification Exam
        ◦ Introduction
        ◦ Three SQL Server 2008 Certification Levels
        ◦ Three SQL Server 2008 Certification Tracks
        ◦ Microsoft Certified IT Professional (MCITP)
        ◦ MCITP 2005 Upgrade Exams
        ◦ Microsoft Certified Master (MCM)
        ◦ SQL Server 2008 Certifications
        ◦ Preparing for Your 70-450 Certification Exam
        ◦ What We Covered
    ● Next Steps
        ◦ Course Recap
        ◦ Steps for Follow Up
        ◦ We'd Like Your Opinion

     


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