Transcript 50401A-ENU_Powerpnt_00

Welcome to the course:
Designing and Optimizing Database Solutions with
Microsoft® SQL Server® 2008
Introduction
• Name
• Company affiliation
• Title/function
• Job responsibility
• Database development experience with SQL Server 2005 and SQL
Server 2008
• Application development experience with ADO.NET
• Experience in managing Windows Server 2008
• Experience in Microsoft SQL Server
• Your expectations for the course
Course Material
Course Handbook
• A succinct classroom learning guide that provides critical technical information to
optimize your in-class learning experience.
• Content-rich online resources for additional information designed to supplement the
Course Handbook.
• Detailed labs designed to make you think and apply your knowledge and skills learned
in a module.
• Concise module reviews and takeaways to summarize and recall learning.
Lab Answer Keys
• In depth lab answer keys that provide solutions for the labs.
Note: The course maps to the Exam 70-451 -PRO: Microsoft SQL Server 2008, Designing
and Optimizing Database Solutions course.
Facilities
• Class hours
• Building hours
• Parking
• Restrooms
• Meals
• Phones
• Messages
• Smoking
• Recycling
About This Course
• Audience
• Course Prerequisites
• Course Objectives
Course Outline
• Module 1: Designing a Conceptual Database Model
• Module 2: Designing a Logical Database Model
• Module 3: Designing a Physical Database Model
• Module 4: Designing Databases for Optimal Performance
• Module 5: Designing Security for SQL Server 2008
• Module 6: Designing a Strategy for Database Access
• Module 7: Designing Queries for Optimal Performance
• Module 8: Designing a Transaction and Concurrency Strategy
• Module 9: Designing an XML Strategy
• Module 10: Designing SQL Server 2008 Components
Introduction to QuantamCorp
QuantamCorp
cycle manufacturing company
• In the labs throughout this course, you will work for QuantamCorp
• As you complete the labs, you will perform the necessary tasks to
redesign the database infrastructure, implement a secure backup
and restore process, and recommend standards that the
organization should follow for implementing database applications
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 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 by using the Virtual Machine Remote
Control Client.
4. Shut down a virtual machine without saving any changes.