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, implementi
This Microsoft SQL Server 2008 Database MCTS 70-433 online training series provides over 22 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:
1 . Demystifying Data Types
2 . Explaining Advanced Query Techniques
3 . Explaining XML
4 . Implementing Error Handling
5 . Implementing Objects
6 . Implementing Transactions
7 . New Features in SQL Server 2008
8 . Performance Tuning
9 . Practice Exam 1
10 . Practice Exam 2
11 . Practice Exam 3
12 . Programming Objects
13 . Using Advanced Functionality with DML
14 . Using the CLR
15 . Working with DML Queries
16 . Working with Multiple-Source Queries
Lesson Detail:
Demystifying Data Types
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.
Explaining Advanced Query Techniques
This course covers Common Table Expressions, ranking and partitioning, managing performance with the Query Governor and application pools, sparse columns, compression, and internationalization issues.
Explaining 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.
Implementing Error Handling
This course covers handling, raising, and managing errors in the execution of code.
Implementing Objects
This course covers the basics of creating database objects, including tables, indexes, constraints, views, stored procedures, functions, and triggers.
Implementing 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.
New Features in SQL Server 2008
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 Tuning
This course covers identifying and resolving performance problems with tools like Query Optimizer, SQL Profiler, Database Tuning Advisor, and Dynamic Management Views.
Practice Exam 1
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
Practice Exam 2
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
Practice Exam 3
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
Programming Objects
This course covers the implementation of functions, stored procedures, and triggers.
Using Advanced Functionality with DML
This course covers advanced DML functionality including the ability to return and manipulate data affected by the DML statement.
Using the CLR
This course covers using the CLR to implement functionality that can't be easily implemented through Transact-SQL.
Working with DML Queries
This course covers the core statements that comprise Data Manipulation Language -- INSERT, UPDATE, DELETE, and MERGE.
Working with Multiple-Source Queries
This course covers connecting to multiple SQL Server instances through Linked Server and SQL Server Integration Services, known as SSIS.
Certification:
Microsoft SQL Server 2008 Database MCTS 70-433
Audience:
This series is for anyone who is preparing to take the MCTS 70-433: TS: Microsoft SQL Server 2008, Database Development exam.
Features:
What You Get:
You will receive Unlimited Access to all of the Microsoft SQL Server 2008 Database MCTS 70-433 training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.
Web-Based Training Products:
You might also be interested in our Microsoft Certifications Package which includes all of the Microsoft SQL Server 2008 Database MCTS 70-433 training courses listed above plus hundreds of hours of related online training courses