Microsoft SQL Server 2008 Database MCTS 70-433 - Online Course

The Microsoft SQL Server 2008 Database Design MCTS 70-433 series prepares the student for Microsoft's MCTS SQL Server 2008 Database Development exam. The topics covered in this series include implementing and programming objects, using the CLR, implementing error handling and transactions, and working with DML and multiple-source queries. Practice exams are also included, which will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.

This series is for anyone who is preparing to take the MCTS 70-433: TS: Microsoft SQL Server 2008, Database Development exam. This online course contains 13 lessons and 3 practice exams and should take approximately 22 hours to complete.

Lesson 1: New Features in SQL Server 2008 (1.0) hour

New Features in SQL Server 2008 teaches you how to new feature overview, and reporting services. This course covers the new features in SQL Server 2008. There are quite a few enhancements to SQL Server, many of which will make the job of the DBA much easier. One of these, the new performance data management system, allows for database statistics and performance information to be automatically captured across an enterprise. Topics include New Features in SQL Server 2008.

Lesson 2: Implementing Objects (2.0) hours

Implementing Objects teaches you how to understand DDL and DML language elements, work with tables, constraints, and indexes, and create and manage views, stored procedures, functions, and triggers. This course covers the basics of creating database objects, including tables, indexes, constraints, views, stored procedures, functions, and triggers. Topics include Implementing Objects.

Lesson 3: Programming Objects (2.0) hours

Programming Objects teaches you how to implement functions, implement stored procedures, and implement triggers. This course covers the implementation of functions, stored procedures, and triggers. Topics include Programming Objects.

Lesson 4: Using the CLR (2.0) hours

Using the CLR teaches you how to work with CLR, managed code, and CLR integration, use the base class library, register CLR Assemblies for use with SQL Server, explain the purpose of permission sets, and implement SQL Server objects using managed code. This course covers using the CLR to implement functionality that can't be easily implemented through Transact-SQL. Topics include Using the CLR.

Lesson 5: Implementing Error Handling (2.0) hours

Implementing Error Handling teaches you how to explain how and why errors occur, manage and raise user-defined errors, and handle errors with TRY...CATCH blocks. This course covers handling, raising, and managing errors in the execution of code. Topics include Implementing Error Handling.

Lesson 6: Implementing Transactions (1.0) hour

Implementing Transactions teaches you how to describe the purpose of transactions, including ACID, explain the use of isolation levels, locking, and deadlocking, employ transaction traps, and troubleshoot transactions. This course covers transactions. Transactions are atomic units of work, isolated from each other within a database system. Data must be consistent both before and after a transaction is complete. Topics include Implementing Transactions.

Lesson 7: Working with DML Queries (1.0) hour

Working with DML Queries teaches you how to use the INSERT Statement, use the UPDATE Statement, use the DELETE Statement, and use the MERGE Statement. This course covers the core statements that comprise Data Manipulation Language -- INSERT, UPDATE, DELETE, and MERGE. Topics include Working with DML Queries.

Lesson 8: Using Advanced Functionality with DML (1.0) hour

Using Advanced Functionality with DML teaches you how to use @@IDENTITY and NEWID functions in DML statements, return data from DML operations with the OUTPUT clause, use the OUTPUT clause with the MERGE statement, and perform nonlogged DML operations. This course covers advanced DML functionality including the ability to return and manipulate data affected by the DML statement. Topics include Using Advanced Functionality with DML.

Lesson 9: Working with Multiple-Source Queries (1.0) hour

Working with Multiple-Source Queries teaches you how to use linked servers and four-part database names, employ the DTC, work with OpenQuery, OpenRowSet, and OpenDataSource, and use multiple sources with SSIS. This course covers connecting to multiple SQL Server instances through Linked Server and SQL Server Integration Services, known as SSIS. Topics include Working with Multiple-Source Queries.

Lesson 10: Demystifying Data Types (1.0) hour

Demystifying Data Types teaches you how to use the built-in data types, work with functions, employ computed columns, and describe the pros and cons of boxing and unboxing. This course covers the built-in data types of SQL Server 2008, as well as the use of functions, computed columns, and boxing and unboxing. Topics include Demystifying Data Types.

Lesson 11: Explaining Advanced Query Techniques (3.0) hours

Explaining Advanced Query Techniques teaches you how to implement Common Table Expression queries, apply ranking functions, control execution plans, manage internationalization, and create and alter tables. This course covers Common Table Expressions, ranking and partitioning, managing performance with the Query Governor and application pools, sparse columns, compression, and internationalization issues. Topics include Explaining Advanced Query Techniques.

Lesson 12: Explaining XML (1.0) hour

Explaining XML teaches you how to retrieve and transform XML data, use OPENXML, sp_xml_preparedocument, and sp_xml_removedocument, employ XQuery and XPath, work with XML indexes, and explain the purpose of the XML schema and well-formed XML. This course covers how XML is used in SQL Server, including retrieving and transforming XML data, using XQuery and XPath, and working with XML indexes, the XML schema, and well-formed XML. Topics include Explaining XML.

Lesson 13: Performance Tuning (1.0) hour

Performance Tuning teaches you how to work with query execution plans, trace with SQL Profiler, employ Database Tuning Advisor, and use Dynamic Management Views. This course covers identifying and resolving performance problems with tools like Query Optimizer, SQL Profiler, Database Tuning Advisor, and Dynamic Management Views. Topics include Performance Tuning.

3 Practice Exams

This course presents questions that will help you prepare for the Microsoft SQL Server 2008 Database Development MCTS 70-433 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.