Scribd Logo
Upload

Welcome to Scribd!

  • 59 views

    Microsoft Official Course: Querying Data With Transact-SQL

    Uploaded by

    Mohamed Zakarya

    Copyright:

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

    Microsoft Official Course: Querying Data With Transact-SQL

    Uploaded by

    Mohamed Zakarya
    59 views13 pages

    Original Title

    20761C_00

    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
    59 views13 pages

    Microsoft Official Course: Querying Data With Transact-SQL

    Uploaded by

    Mohamed Zakarya

    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 13

    Microsoft Official Course

    20761C
    Querying Data with Transact-SQL
    Welcome!
    Thank you for joining us today.
    We’ve worked together with today’s 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>
    Student Introductions

    • Name
    • Company affiliation
    • Title/function
    • Job responsibility
    • Business Intelligence experience
    • Your expectations for the course
    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 Microsoft SQL Server 2016"


    • Module 2, “Introduction to T-SQL Querying"
    • Module 3, “Writing SELECT Queries"
    • Module 4, “Querying Multiple Tables"
    • Module 5, “Sorting and Filtering Data"
    • Module 6, “Working with SQL Server 2016 Data Types"
    • Module 7, “Using DML to Modify Data"
    • Module 8, “Using Built-In Functions"
    Course Outline

    • Module 9, “Grouping and Aggregating Data"


    • Module 10, “Using Subqueries"
    • Module 11, “Using Table Expressions"
    • Module 12, “Using Set Operators“ – “Optional”
    • Module 13, “Using Windows Ranking, Offset, and Aggregate
    • Functions“ – “Optional”
    • Module 14, “Pivoting and Grouping Sets"
    • Module 15, “Executing Stored Procedures"
    • Module 16, “Programming with T-SQL“ – “Optional”
    • Module 17, “Implementing Error Handling”
    • Module 18, “Implementing Transactions”
    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:

    20761C-MIA-DC Domain controller

    20761C-MIA-SQL Database and BI server

    MSL-TMG1 Internet gateway

    MIA-DC

    Internet

    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