Transcript Course 2778A

Course 2778A
Writing Queries Using
Microsoft® SQL Server®
2008 Transact-SQL
Welcome!
Thank you for taking our training. We’ve 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 today’s 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 Material
Course Companion CD
Course Handbook
A succinct classroom learning guide
that provides critical technical
information to optimize your
in-class learning experience.
Searchable, easy-to-navigate digital
content with integrated premium
on-line resources designed to
supplement the Course Handbook.
Online Resources
Student Course Files
Lessons
Labs
Module Reviews and Takeaways
Lab Answers
http://www.microsoft.com/learning/
How to Use the Course Material
Course Handbook
• Use the handbook content as the
Course Companion CD
• During the class, refer to the
primary resource for reference during
the class.
Companion CD while performing labs
or as suggested by the instructor.
• Use the troubleshooting tips and best
• Use the CD as your extended learning
practices in the Module Reviews and
Takeaways section as on-the-job
references.
http://www.microsoft.com/learning/
resource on the job.
Facilities
• Class hours
• Building hours
• Parking
• Restrooms
• Meals
• Phones
• Messages
• Smoking
• Recycling
Microsoft 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
http://www.microsoft.com/learning/
Microsoft Certification Program
Exam number
and title
Core exam for the
following track
70-433: Microsoft® SQL Microsoft Certified IT
Server® 2008, Database Professional: Database
Development
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
• Module 2: Querying and Filtering Data
• Module 3: Grouping and Summarizing Data
• Module 4: Joining Data from Multiple Tables
• Module 5: Working with Sub Queries
• 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
Monday
Start
End
Module
8:00
8:30
Introduction
8:30
9:30
Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008
9:30
9:45
Break
9:45
10:45
Lab: Getting Started with Databases and Transact-SQL in SQL Server 2008
10:45
11:45
Module 2: Querying and Filtering Data
11:45
1:00
Lunch
1:00
2:00
Lab: Querying and Filtering Data
2:00
2:15
Break
2:15
3:15
Module 3: Grouping and Summarizing Data
3:15
4:00
Lab: Grouping and Summarizing Data
Wednesday
Start
End
Module
8:00
8:30
Introduction
8:30
9:30
Module 4: Joining Data from Multiple Tables
9:30
9:45
Break
9:45
10:45
Lab: Joining Data from Multiple Tables
10:45
11:45
Module 5: Working with Sub Queries
11:45
1:00
Lunch
1:00
2:00
Lab: Working with Sub Queries
2:00
2:15
Break
2:15
3:15
Module 6: Modifying Data in Tables
3:15
4:00
Lab: Modifying Data in Tables
Thursday
Start
End
Module
8:00
8:30
Introduction
8:30
9:30
Module 7: Querying Metadata, XML and Full-Text Indexes
9:30
9:45
Break
9:45
10:45
Lab: Querying Metadata, XML and Full-Text Indexes
10:45
11:45
Module 8: Using Programming Objects for Data Retrieval
11:45
1:00
Lunch
1:00
2:00
Lab: Using Programming Objects for Data Retrieval
2:00
2:15
Break
2:15
3:15
Module 9: Using Advanced Query Techniques
3:15
4:00
Lab: Using Advanced Query Techniques
Introduction to Adventure Works
Adventure Works
Bicycle Manufacturing Company
• In the labs throughout this course, you will work for
Adventure Works.
• As you complete the labs, you will develop queries using
Transact-SQL.
Setup
Virtual machine
2778A-NY-SQL-01
Used as:
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
course’s 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 bypass 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