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 2012 Database Administration (70-462) Part 3

Course Summary

Part 3 of 3 in the SQL Server 2012 Database Administration (70-462) series. This SQL Server 2012 administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, basic high avail


  • +

    Course Syllabus

    ● Backup Basics
        ◦ Introduction
        ◦ Full Backups
        ◦ Log Backups
        ◦ Differential Backups
        ◦ Filegroup Backups
        ◦ System Backups
    ● Restore Basics
        ◦ Introduction
        ◦ Simple Full Restore
        ◦ Restore with Move
        ◦ Restore Under Different Name
        ◦ Restoring Logs
        ◦ Restore Differentials
    ● Indexes
        ◦ Introduction
        ◦ Clustered vs. Non-Clustered Indexes
        ◦ Index Fragmentation
        ◦ Detecting Fragmentation
        ◦ Fixing Fragmentation
    ● Basic Execution Plans
        ◦ Introduction
        ◦ Scan vs. Seek
        ◦ Bookmark Lookups
        ◦ Covering Indexes
        ◦ Set Statistics IO
    ● Query Tuning
        ◦ Query Tuning in Batch Mode
        ◦ Calculate Savings
    ● SQL Server Agent
        ◦ Creating Jobs
        ◦ Schedules
        ◦ Agent Properties
    ● Database Mail
        ◦ Introduction
        ◦ Turning on DBMail
        ◦ Profiles and Accounts
        ◦ Testing and Troubleshooting
    ● Importing and Exporting Data
        ◦ Introduction
        ◦ SSIS Wizard
        ◦ Bulk Insert
        ◦ Bulk Copy Program (BCP)
    ● High Availability Basics
        ◦ Introduction
        ◦ What is the Difference Between HA and DR?
        ◦ Log Shipping
        ◦ Replication
        ◦ Mirroring
        ◦ AlwaysOn Availability Groups
        ◦ Clustering
    ● PowerShell
        ◦ What is PowerShell?
        ◦ What are Cmdlets?
        ◦ Using PSDrive
        ◦ Variables and Shell Interaction
        ◦ PowerShell and SQL Server

     


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