You are here

Microsoft 70-433 TS: SQL Server 2008, Database Development

Primary tabs

Resell This Course

Request A Demo

About Our Platform

About Our Courses

When you pass Exam 70-433 TS: Microsoft SQL Server 2008, Database Developmentyou 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

iCollege offers you 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...read more

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

Add New Discussion