Image of computer keyboard NC State University
NC State University - Computer Training Unit

MCTS Implementing and Maintaining SQL Server 2008 (70-432)

Description: This complete course will help you to specialize your technological knowledge for Microsoft SQL Server 2008. It will prepare you to take the Microsoft Certified Technology Specialist certification exam that will demonstrate an IT professional's in-depth, current skills in SQL Server 2008. The course will cover implementing and maintaining databases using specific instructions and specifications. You will gain thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and how to explore the user interface.

Suggested Prerequisites:  

  • Querying and processing SQL Server Data with SQL Statements
  • MCTS Implementing SQL 2008 Server or experience equivalent
 

Attend and You Will Learn
Lesson 1:
Introduction to SQL Server 2005
What is SQL Server



  • Database engine


  • Analysis Services


  • Reporting Services


  • Integration Services


  • Notification Services


  • .Net framework




A few implementation examples



  • Web applications


  • Windows forms application


  • High-Availability introduction




Review of relational data and ACID traits



Lesson 2:
Installing and Configuring SQL Server 2005
Selecting the correct edition

Determining infrastructure Requirements

Using Default, named, and Multiple Instances of SLQ Server 2005

Installing SQL 2005

Upgrading to SQL 2005
Lesson 3:
SQL Server Tools Introduction
Management Studio

Surface Area Configuration

SQL Server Profiler

SQL Server Books Online

SQL Configuration Manager

Business Intelligence Development Studio
Lesson 4:
Managing Databases and Filegroups
Configure log and data files

Specifying a Recovery Model
Lesson 5:
Working with Transact SQL
Querying Data

Formatting Result Sets

Modifying Data

Working with Transactions
Lesson 6:
Creating Tables, Constraints and User-Defined Types
Creating Tables

Implementing Constraints

Creating User-Defined Types
Lesson 7:
Creating Indexes
Understanding Index Structure

Creating Clustered Indexes

Creating Non-Clustered Indexes
Lesson 8:
Implementing Views
Creating a View

Modifying Data through Views

Creating an Indexed View
Lesson 9:
Creating Functions, Stored Procedures, and Triggers
Implementing Functions

Implementing Stored Procedures

Implementing Triggers
Lesson 10:
Creating Partitions
Creating a partition Function

Creating a Partition Scheme

Partitioning Tables and Indexes

Querying Partitions

Managing Partitions
Lesson 11:
Using Transact SQL to Manage Databases
Managing Index Fragmentation

Managing Statistics

Shrinking Files

Using DBCC CHECKDB
Lesson 12:
Managing XML Data
Working with XML Structures

Retrieving XML Data by Using SL Server-Side Technologies

Retrieving XML Data by Using SLQ Server Middle-Tier Technologies

Modifying XML Data

Converting Between XML Data and Relational Data
Lesson 13:
Working with HTTP Endpoints
Understanding HTTP Endpoint Security

Creating a Secure Endpoint

Lesson 14:
Using Managed Code in SQL Server 2005
CLR Integration

Using Assemblies

Enforcing Security

Lesson 15:
Working with Service Broker
Exploring the Service Broker Architecture

Creating Message Types and Contracts

Creating Queues and Services

Creating Conversations

Sending and Receiving Messages
Lesson 16:
Review Managing Databases
Configure log and data files

Specifying a Recovery Model
Lesson 17:
Backing Up, Restoring, and Moving a Database
Backing up a database

Restoring a Database

Moving a Database
Lesson 18:
Managing Database Snapshots
Creating a Database Snapshot

Reverting a Database from a Database Snapshot
Lesson 19:
Automating Administrative Tasks
Create a SQL Server Agent Job

Creating a Maintenance Plan

Using DTUTIL

Configuring Operators

Configuring Alerts

Configuring Database Mail
Lesson 20:
Managing SQL Server Security
Using the Surface Area Configuration Tool and SAC

Configuring Server Security Principals

Configuring Database Securables

Configuring Encryption

Configuring Linked Servers
Lesson 21:
SQL Server High Availability Technologies: Clustering
Introduction to Clustering

Clustering requirements

Clustering Features

Clustering Limitations

GEO Clusters
Lesson 22:
SQL Server High Availability Technologies: Database Mirroring
Understanding Database Mirroring Roles

Preparing Databases for Database Mirroring

Establishing Endpoints

Understanding Operating Modes

Failing over a Database Mirror

Removing Database Mirroring
Lesson 23:
SQL Server High Availability Technologies: Log Shipping
Preparing to Log Ship

Configuring Log Shipping Options

Configuring Log Shipping Mode

Configuring Monitoring
Lesson 24:
SQL Server High Availability Technologies: Replication
Understanding Replication Types

Setting Up Replication

Configuring Replication Security

Configuring Conflict Detection for Merge Replication

Monitoring Replication
Lesson 25:
Monitoring SQL Server
Working with SQL Profiler

Working with System Monitor

Using DTA

Using Dynamic Management Views and Monitoring Data

Correlating Performance and Monitoring Data

Resolving Blocking and Deadlocks

Resolving Database Errors

Using DAC
Lesson 26:
Transferring Data
Preparing to Work with Flat Files

Running BCP

Performing a Bulk Insert Task

Importing Bulk XML Data

Introduction to SSIS

Using the SSIS Import/ Export Wizard
Lesson 27:
Creating Full-Text catalogs
Creating a Full-Text Catalog

Creating a Full-Text index

Populating a Full-Text Index

Querying Data by Using a Full-Text Index

For available dates, Click Here.

Upcoming Events

919.515.8163 - NC State University - 1101 Gorman Street - Campus Box 7401 - Raleigh, NC 27695
Computer Training Unit is a unit of McKimmon Center for Extension & Continuing Education
Copyright © 2008 - North Carolina State University - All Rights Reserved - Policy Disclaimer

Valid XHTML 1.0 Strict Valid CSS