|
MCTS 70-433 Training Course TS: Microsoft SQL Server 2008, Database Development teaches students how to implement tables and views in SQL Server 2008, implement programming objects, work with query fundemendals, apply additional query techniques, work with additional SQL Server 2008 components, work with XML data and gather performance information. After completing this course, you will be able to write basic Transact-SQL queries for Microsoft SQL Server 2008.
When you pass Exam 70-433 TS: Microsoft SQL Server 2008, Database Development you complete the requirements for the following certification:
- Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Database Development
Microsoft Exam 70-433 also counts as credit toward the following certifications:
- MCITP: Database Developer 2008
This is the most effective way to earn your Microsoft Certified Technology Specialist (MCTS). Developers holding the Microsoft Certified Technology Specialist: SQL Server 2008, Database Developer certification have demonstrated the knowledge and skills necessary to work in environments in which SQL Server 2008 database development is central to their job roles.
As a Microsoft Certified Partner Training Course, it follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.
Instructor Introduction
Course Outline
Implementing Tables
Implementing Schemas
Creating Tables
Implementing Filestreams
Working Constraints
Partitioning Tables
Modifying Partitions
Module Review
TSQL Fundamentals
Retrieving Data
Modifying Data
Module Review
Advanced Querying Concepts
Built-In Functions
Handling Transactions and Errors
Advanced Query Techniques
Module Review
Specialized Data Types
XML
Spatial Types
Module Review
Creating Objects
Views
Stored Procedures
Functions
Triggers
CLR-Based Objects
Module Review
Service Broker
Service Broker Concepts
Implementing the Service Broker
Module Review
Managing SQL
Database Mail
External Tools
Tracking Data Changes
Module Review
Creating and Maintaining Indexes
Indexes
Specialized Indexes
Module Review
SQL Server Concurrency
Locks and Latches
Isolation Levels
Monitoring Locks
Module Review
Optimizing Performance
System Monitor
SQL Server Profiler
Database Engine Tuning Advisor
Module Review
Course Review
Exam Tips
70-433 Demo Scripts
|
