Microsoft SQL Server 2008 Database MCTS 70-433: New Features in SQL Server 2008
Description
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.
Objectives
- New feature overview
- Reporting services
Microsoft SQL Server 2008 Database MCTS 70-433: Implementing Objects
Description
This course covers the basics of creating database objects, including tables, indexes, constraints, views, stored procedures, functions, and triggers.
Objectives
- Understand DDL and DML language elements
- Work with tables, constraints, and indexes
- Create and manage views, stored procedures, functions, and triggers
Microsoft SQL Server 2008 Database MCTS 70-433: Programming Objects
Description
This course covers the implementation of functions, stored procedures, and triggers.
Objectives
- Implement functions
- Implement stored procedures
- Implement triggers
Microsoft SQL Server 2008 Database MCTS 70-433: Using the CLR
Description
This course covers using the CLR to implement functionality that can't be easily implemented through Transact-SQL.
Objectives
- 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
- Implement SQL Server objects using managed code
Microsoft SQL Server 2008 Database MCTS 70-433: Implementing Error Handling
Description
This course covers handling, raising, and managing errors in the execution of code.
Objectives
- Explain how and why errors occur
- Manage and raise user-defined errors
- Handle errors with TRY...CATCH blocks
Microsoft SQL Server 2008 Database MCTS 70-433: Implementing Transactions
Description
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.
Objectives
- Describe the purpose of transactions, including ACID
- Explain the use of isolation levels, locking, and deadlocking
- Employ transaction traps
- Troubleshoot transactions
Microsoft SQL Server 2008 Database MCTS 70-433: Working with DML Queries
Description
This course covers the core statements that comprise Data Manipulation Language -- INSERT, UPDATE, DELETE, and MERGE.
Objectives
- Use the INSERT Statement
- Use the UPDATE Statement
- Use the DELETE Statement
- Use the MERGE Statement
Microsoft SQL Server 2008 Database MCTS 70-433: Using Advanced Functionality with DML
Description
This course covers advanced DML functionality including the ability to return and manipulate data affected by the DML statement.
Objectives
- 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
- Perform nonlogged DML operations
Microsoft SQL Server 2008 Database MCTS 70-433: Working with Multiple-Source Queries
Description
This course covers connecting to multiple SQL Server instances through Linked Server and SQL Server Integration Services, known as SSIS.
Objectives
- Use linked servers and four-part database names
- Employ the DTC
- Work with OpenQuery, OpenRowSet, and OpenDataSource
- Use multiple sources with SSIS
Microsoft SQL Server 2008 Database MCTS 70-433: Demystifying Data Types
Description
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.
Objectives
- Use the built-in data types
- Work with functions
- Employ computed columns
- Describe the pros and cons of boxing and unboxing
Microsoft SQL Server 2008 Database MCTS 70-433: Explaining Advanced Query Techniques
Description
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.
Objectives
- Implement Common Table Expression queries
- Apply ranking functions
- Control execution plans
- Manage internationalization
- Create and alter tables
Microsoft SQL Server 2008 Database MCTS 70-433:12 Explaining XML
Description
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.
Objectives
- Retrieve and transform XML data
- Use OPENXML, sp_xml_preparedocument, and sp_xml_removedocument
- Employ XQuery and XPath
- Work with XML indexes
- Explain the purpose of the XML schema and well-formed XML
Microsoft SQL Server 2008 Database MCTS 70-433: Performance Tuning
Description
This course covers identifying and resolving performance problems with tools like Query Optimizer, SQL Profiler, Database Tuning Advisor, and Dynamic Management Views.
Objectives
- Work with query execution plans
- Trace with SQL Profiler
- Employ Database Tuning Advisor
- Use Dynamic Management Views
Microsoft SQL Server 2008 Database MCTS 70-433: Practice Exam 1
Description
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.
Objectives
Microsoft SQL Server 2008 Database MCTS 70-433: Practice Exam 2
Description
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.
Objectives
Microsoft SQL Server 2008 Database MCTS 70-433: Practice Exam 3
Description
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.
Objectives