1	Preparing for Exam 70-431 SQL Server 2005 Implementation and Maintenance Rick Dobson Author/Trainer CAB, Inc.
2	About the Presenter Rick is an MCP who authored seven books along with numerous articles and DVD sets. Two of his recent publications are:
3	What We Will Cover Focus and audience for the 70-431 exam Summary of six major exam topics, with Live demonstration of a graphical technique Identification of URLs for drilling deeper on selected topics Transact-SQL code sample reviews and demos A sample test question review to show exam question format and style Overview of additional learning resources Coupon offer for discounts on test preparation materials from PrepLogic
4	70-431 Focus and Audience Major focus is on Microsoft^® SQL Server™ 2005 database implementation and maintenance topics Target audience for the exam SQL Server database administrators, database developers, and business intelligence developers Other developers, system administrators, and IT professionals who want to certify their SQL Server 2005 expertise Passing the exam makes you a Microsoft Certified Technical Specialist in SQL Server 2005
5	Six Major Exam Topics Installing and Configuring SQL Server 2005 Implementing High Availability and Disaster Recovery Supporting Data Consumers (such as queries) Maintaining Databases Monitoring and Troubleshooting SQL Server Performance Creating and Implementing Database Objects Details: www.microsoft.com/learning/exams/70-431.asp
6	Installing and Configuring
7	Linking an Excel File You do not need to install Microsoft^® Office Excel^® to link an Excel file, but you do have to assign a named range.
8	Demonstration One SSMS setup of Excel Linked Server SSMS setup for SS Linked Server
9	High Availability and Disaster Recovery
10	Supporting Data Consumers Traditional topics Ad hoc and recurring queries Manipulate relational data Manage replication Import and export data from a file New topics Manage XML data Implement an HTTP endpoint Implement Service Broker components
11	Selected URLs for New Data Consumer Topics xml data type http://msdn2.microsoft.com/en-us/library/ms189887.aspx HTTP endpoint http://msdn2.microsoft.com/en-us/library/ms181591.aspx Service Broker http://msdn2.microsoft.com/en-us/library/ms166043.aspx
12	Maintaining Databases
13	Backing Up/Moving a Database
14	Demonstration Two Create and Apply Transaction Logs
15	Monitor/Troubleshoot Performance SQL Server Profiler Database Engine Tuning Advisor Blocks and Deadlocks Database server errors SQL Server Agent job history Using Dynamic Management Views (DMVs)
16	Sample Question for Deadlocks
17	Creating and Implementing Database Objects Implement a table, constraints, and indexes Implement a view Implement triggers Implement functions Implement stored procedures Create user-defined types Implement full-text search Implement partitions
18	Parameters and Return Status Values in a Stored Procedure
19	Inputting and Retrieving Return Status Values
20	Additional Resources MSDN site: http://msdn.microsoft.com Free Microsoft E-Learning Series for database administrators, developers, and business intelligence developers: www.microsoftelearning.com/sqlserver2005/ Commercial resources with coverage of exam topics and sample test questions; use your favorite search engine to find these
21	Special Coupon Offers PrepLogic offers a discount coupon for 70-431 exam preparation The coupon is for an exam preparation guide Coupon expiration date is November 14, 2006 PrepLogic will soon offer 70-431 practice exams You can request the coupon number by leaving a comment at www.programmingmsaccess.com/mygb.htm You can redeem the coupon at the PrepLogic site: www.preplogic.com
22	Session Summary 70-431 exam helps database administrators and developers to: Ramp up the SQL Server 2005 learning curve Reinforce their basic database skills The exam targets six main areas The MSDN site is an excellent free resource for researching topics that can be covered on the exam PrepLogic is offering discount coupons for 70-431 prep materials through my Web site
23	Questions and Answers Submit text questions using the “Ask” button. Don’t forget to fill out the survey. For upcoming and previously live webcasts: www.microsoft.com/webcasts Got webcast content ideas? Contact us at: http://go.microsoft.com/fwlink/?LinkId=41781 Today's webcast was presented using Microsoft^® Office Live Meeting. Get a free 14-day trial by visiting: www.microsoft.com/presentlive
24