Scribd Logo
Upload

Welcome to Scribd!

  • 66 views

    Course 2778A: Writing Queries Using Microsoft® SQL Server® 2008 Transact-SQL

    Uploaded by

    Luis Gonzalez Alarcon
    Your instructor is a premier technical and instructional expert who meets ongoing certification requirements. After training, consider taking a Microsoft Certification exam. Independent research by IDC concluded that 75% of managers believe certifications are important to team performance.

    Copyright:

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

    Course 2778A: Writing Queries Using Microsoft® SQL Server® 2008 Transact-SQL

    Uploaded by

    Luis Gonzalez Alarcon
    66 views14 pages
    Your instructor is a premier technical and instructional expert who meets ongoing certification requirements. After training, consider taking a Microsoft Certification exam. Independent research by IDC concluded that 75% of managers believe certifications are important to team performance.

    Original Title

    2778A_00

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Your instructor is a premier technical and instructional expert who meets ongoing certification requirements. After training, consider taking a Microsoft Certification exam. Independent research by IDC concluded that 75% of managers believe certifications are important to team performance.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    66 views14 pages

    Course 2778A: Writing Queries Using Microsoft® SQL Server® 2008 Transact-SQL

    Uploaded by

    Luis Gonzalez Alarcon
    Your instructor is a premier technical and instructional expert who meets ongoing certification requirements. After training, consider taking a Microsoft Certification exam. Independent research by IDC concluded that 75% of managers believe certifications are important to team performance.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    You are on page 1of 14

    Course 2778A

    Writing Queries Using


    Microsoft SQL Server
    2008 Transact-SQL
    Welcome!
    Thank you for taking our training. Weve worked together with our Microsoft
    Certified Partners for Learning Solutions and Microsoft IT Academies to bring
    you a world-class learning experience, including:

    Microsoft Certified Trainers + Instructors. Your instructor is a premier
    technical and instructional expert who meets ongoing certification
    requirements.

    Customer Satisfaction Guarantee. Our Certified Partners for Learning
    Solutions offer a satisfaction guarantee and we hold them accountable for it.
    At the end of class, please complete an evaluation of todays experience. We
    value your feedback!

    Certification Exam Benefits. After training, consider taking a Microsoft
    Certification exam. Independent research by IDC concluded that 75% of
    managers believe certifications are important to team performance*. Ask your
    instructor about available exam promotions and discounts.

    We wish you a great learning experience and ongoing career success!


    * IDC, Value of Certification: Team Certification and Organizational Performance, November 2006
    Introduction
    Name
    Company affiliation
    Title/function
    Job responsibility
    SQL Server experience
    Your expectations for the course
    Course Companion CD
    Course Material
    http://www.microsoft.com/learning/



    Lessons
    Labs
    Module Reviews and Takeaways
    Lab Answers



    A succinct classroom learning guide
    that provides critical technical
    information to optimize your
    in-class learning experience.

    Online Resources
    Student Course Files

    Searchable, easy-to-navigate digital
    content with integrated premium
    on-line resources designed to
    supplement the Course Handbook.
    Course Handbook
    How to Use the Course Material
    http://www.microsoft.com/learning/
    Use the handbook content as the
    primary resource for reference during
    the class.
    Use the troubleshooting tips and best
    practices in the Module Reviews and
    Takeaways section as on-the-job
    references.
    During the class, refer to the
    Companion CD while performing labs
    or as suggested by the instructor.
    Use the CD as your extended learning
    resource on the job.
    Course Handbook Course Companion CD
    Facilities
    Class hours
    Building hours
    Parking
    Restrooms
    Meals
    Phones
    Messages
    Smoking
    Recycling
    Microsoft Learning
    http://www.microsoft.com/learning/
    Course 2778A: Writing Queries Using Microsoft
    SQL Server 2008 Transact-SQL
    Course 6231A: Maintaining a Microsoft SQL
    Server 2008 Database
    Course 6232A: Implementing a Microsoft SQL
    Server 2008 Database
    Microsoft Certification Program
    Exam number
    and title
    Core exam for the
    following track
    70-433: Microsoft SQL
    Server 2008, Database
    Development
    Microsoft Certified IT
    Professional: Database
    Administrator
    http://www.microsoft.com/learning/
    About This Course
    Audience
    Course Prerequisites
    Course Objectives
    Course Outline
    Module 1: Getting Started with Databases and Transact-
    SQL in SQL Server 2008
    Module 2: Querying and Filtering Data
    Module 3: Grouping and Summarizing Data
    Module 4: Joining Data from Multiple Tables
    Module 5: Working with Subqueries
    Module 6: Modifying Data in Tables
    Module 7: Querying Metadata, XML, and Full-Text Indexes
    Module 8: Using Programming Objects for Data Retrieval
    Module 9: Using Advanced Techniques
    Introduction to Adventure Works
    In the labs throughout this course, you will work for
    Adventure Works.
    As you complete the labs, you will develop queries using
    Transact-SQL.

    Adventure Works
    Bicycle Manufacturing Company
    Setup
    Virtual machine Used as:
    2778A-NY-SQL-01 SQL Server for Adventure Works
    Demonstration: Using Microsoft Virtual Server
    2005 R2 with SP1
    Help the students to familiarize with the Virtual Server
    environment in which they will work to complete the
    courses labs
    In this demonstration, you will learn how to:
    1. Connect to the Virtual Server Administration Web site.
    2. Configure the virtual machine settings by using the
    Virtual Server Administration Web site.
    3. Connect to a virtual machine using the Virtual Machine
    Remote Control Client.
    4. Shut down a virtual machine without saving any changes.

    Demonstration: Using MSL Lab Launcher and
    Virtual Server
    The MSL Lab Launcher provides a single console through
    which all virtual machines in this course can be launched
    and accessed. All virtual machines will launch at a
    preconfigured date which allows us to by pass the need for
    activation.
    In this demonstration, you will learn how to:

    Open the Lab launcher
    Launch virtual machines
    Logon and Interact with the virtual machines
    How to shut down a virtual machine
    How to Reset a virtual machine

    You might also like