You are here

Microsoft 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Primary tabs

Resell This Course

Request A Demo

About Our Platform

About Our Courses

When you pass this exam, you earn credit towards the following certifications: MCITP Database Developer, SQL Server 2008.

Module 1: Overview

  • Module Overview
  • Table Design
  • Data Integrity
  • Data Types and Using a Filestream
  • Indexing
  • Module Review

Module 2: Physical Design

  • Module Overview
  • Server Design
  • Physical Table Design
  • Partitioned Tables
  • Module Review

Module 3: Database Services

  • Module Overview
  • SQL Agent
  • Service Broker
  • Full Text Search
  • Module review

Module 4: Security

  • Module Overview
  • Authentication
  • Authorization
  • Module Review

Module 5: Creating Objects

  • Module Overview
  • Views
  • Stored Procedures
  • Functions and triggers
  • Error Handling
  • CLR Based Objects
  • Module Review

Module 6: SQL Server Concurrency

  • Module Overview
  • Locks and Latches
  • Isolation Levels
  • Monitoring Locks and Managing Transactions
  • Module Review

Module 7: XML

  • Module Overview
  • XML

 

Add New Discussion