Scribd Logo
Upload

Welcome to Scribd!

  • 283 views

    20462C 00

    Uploaded by

    dfrr2000

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    20462C 00

    Uploaded by

    dfrr2000
    283 views12 pages

    Original Title

    20462C_00.pptx

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    283 views12 pages

    20462C 00

    Uploaded by

    dfrr2000

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 12

    Microsoft Official Course

    20462C
    Administering Microsoft SQL
    Server Databases
    Welcome!
    Thank you for joining us today.
    Weve worked together with todays experience. We value your
    Microsoft Learning Partners and feedback!
    Microsoft IT Academies to bring you
    Certification Benefits. After training,
    a world-class learning experience,
    consider pursuing a Microsoft
    including:
    Certification, to help distinguish your
    Microsoft Certified Trainers + technical expertise and experience.
    Instructors. Your instructor is a Ask your instructor about available
    premier technical and instructional exam promotions and discounts.
    expert who meets ongoing
    We wish you a great learning
    certification requirements.
    experience and ongoing career
    Customer Satisfaction Guarantee. success!
    Our Partners offer a satisfaction
    guarantee and we hold them
    accountable for it. At the end of class,
    please complete an evaluation of
    Hello

    Instructor: <Instructor Name>


    <Title or other credentials, e.g. Microsoft
    Certified Trainer>
    <Affiliation/Company>
    <A few words about my technical and
    professional experience>
    Facilities

    Class hours
    Building hours
    Parking
    Restrooms
    Meals
    Phones
    Messages
    Smoking
    Recycling
    About This Course

    Audience
    Course Prerequisites
    Course Objectives
    What You Can Expect
    Your Course Materials
    Designed to optimize your classroom learning experience.
    And support you back on the job.

    Microsoft Official Course Handbook


    Organized by Modules
    Includes Labs + Lab Answer Keys
    Module Reviews + Takeaways
    great for on-the-job reference
    Course Outline
    Module 1: Introduction to SQL Server 2014 Database
    Administration
    Module 2: Installing and Configuring SQL Server 2014
    Module 3: Working with Databases and Storage
    Module 4: Planning and Implementing a Backup Strategy
    Module 5: Restoring SQL Server 2014 Databases
    Module 6: Importing and Exporting Data
    Module 7: Monitoring SQL Server 2014
    Module 8: Tracing SQL Server Activity
    Module 9: Managing SQL Server Security
    Module 10: Auditing Data Access and Encrypting Data
    Module 11: Performing Ongoing Database Maintenance
    Module 12: Automating SQL Server 2014 Management
    Module 13: Monitoring SQL Server 2014 with Notifications and
    Alerts
    Related Courses

    20461: Querying Microsoft SQL Server


    20463: Implementing a Data Warehouse with Microsoft
    SQL Server
    20464: Developing Microsoft SQL Server Databases
    20465: Designing a Data Solution with Microsoft SQL
    Server
    20466: Implementing Data Models and Reports with
    Microsoft SQL Server
    20467: Designing Self-Service Business Intelligence and
    Big Data Solutions

    See the full line of Microsoft Training and Certification resources at:
    http://www.microsoft.com/learning/
    Microsoft Certification Program

    Get trained. Get certified.


    Get ahead.
    Microsoft Certifications demonstrate you
    have the skills to design, deploy, and
    optimize the latest technology solutions.

    Ask your Microsoft Learning Partner how you


    can prepare for certification.

    Also see:
    http://www.microsoft.com/learning/
    certification
    Preparing for the Labs

    Your lab activities will be centered around Adventure Works


    Cycles, a fictitious manufacturer and seller of cycles and related
    products.

    To complete the labs, you will work in a virtual


    machine (VM) environment.
    Virtual Machine Environment

    Virtual Machine Name: Use as:

    20462C-MIA-DC Domain controller

    20462C-MIA-SQL Database server

    MSL-TMG1 (optional) Internet gateway

    MIA-DC

    MIA-SQL
    ADVENTUREWORKS.MSFT MSL-TMG1
    Demonstration: Using Hyper-V Manager
    In this demonstration, you will learn how to:
    Open Hyper-V Manager
    Navigate the various sections/panes within Hyper-V Manager
    Virtual Machines, Snapshots, and Actions: Server-specific and VM-
    specific
    Identify the VMs used in the labs for this course
    Take a Snapshot and Apply a Snapshot
    Connect to a VM
    Start and log on to a VM
    Switch between full screen and window modes
    Revert to the previous Snapshot
    Shut down a VM
    When to use Shut Down or Turn off
    Close Hyper-V Manager

    You might also like