CBT Nuggets: Exam Microsoft SQLServer 2008 Database Developm

CBT Nuggets: Exam Microsoft SQLServer 2008 Database Development | 600MB
Genre: elearning

Every database administrator dreams about zero downtime. With SQL Server 2008 that dream can be yours. SQL?s self-management features

eliminate much of your database busy work, giving you the time you need to keep your databases secure and running smoothly.

Get the most from SQL Server 2008 while you?re becoming become a database star. Regardless of whether you?re brand new to SQL or already

experienced with SQL Server 2005, this video series delivers the training you need. Database expert Julie Johnson thoroughly prepares you

for database administration by carefully walking you through SQL Server 2008's powerful features and capabilities.

SQL Server 2008's storage capabilities cover many different data types ? including XML, email, files and documents ? as well as a wide

variety of search, query and analysis functions. Really cool features include:
# Variable parameters

# MERGE statement

# Change data capture

# Full-text search integration

By the time you?ve finished Julie?s training you?ll be managing database tables, views, procedures, functions, and other objects. In no

time, you?ll be:
# Monitoring database performance

# Manipulating and inspecting XML

# Sending mail from T-SQL

# Implementing asynchronous messaging

# Integrating with .NET

# Harnessing Windows PowerShell

# Tracking data changes

Julie?s training maps to Microsoft MCTS certification exam 70-433 while it readies you for your on-the-job database tasks. Following her

step-by-step instruction gives you the database skills and solid exam prep you need to advance your career.

By the time you?re done you?ll understand the following topics about Microsoft 70-433: SQL Server 2008, Database Development:

* SQL Server Tables

* SQL Server Views

* Selecting and Changing Data

* SQL Server 2008 Indexes

* Partitioned Tables and Indexes (free video!)

* Procedures and Functions

* Advanced SQL

* Triggers

* XML Basics

* Advanced XML

* SQL Server 2008 Database Mail

* SQL Server Performance

* SQL Server 2008 Service Broker

* SQL Server .NET Integration



-- Mon Sep 06, 2010 9:05 am --





Exam-Pack 70-443: Database Infrastructure Design contains:

- Series Intro
- Capacity Planning
- Server-Level Security
- Database-Level Security
- Encryption
- Object Security
- Planning Your Database (free video!)
- Designing Tables
- Files and Filegroup Management
- Designing Indexes
- Highly Available Solutions
- Database Mirroring
- Replication
- Archiving, Backup, and Recovery
- Consolidating Databases