MS SQL Server 2008: Implementing a Database (6232A)

Formation MS SQL Server - MS SQL Server 2008: Implementing a Database (6232A) in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.

2400.-/d

ID : 548

Goal : After completing this training,students will be able to create, manage and optimize tables, fields, index, databases, triggers, and views.

Audience : This training is intended for IT Professionals who administer and maintain SQL Server databases.

Prerequisites : Before attending this training, students must have working knowledge of Transact-SQL and of of Relational databases.

Goals :

- Introduction

- Creating Databases and Database Files

- Creating Databases

- Creating Filegroups

- Creating Schemas

- Creating Database Snapshots

- Creating Data Types and Tables

- Creating Data Types

- Creating Tables

- Creating Partitioned Tables

- Creating and Tuning Indexes

- Planning Indexes

- Creating Indexes

- Optimizing Indexes

- Implementing Data Integrity by Using Constraints and Triggers

- Data Integrity Overview

- Implementing Constraints

- Implementing Triggers

- Using XML

- Using the XML Data Type

- ...

Pedagogical method : Training based on MS slides and exercises

Suggested duration for presentiel training (days) : 5

Suggested duration for on-line training (days) : 6

Daily price in face-to-face : 2400 CHF

Daily price in remote : 1152 CHF

Daily price in remote for students : contact us (only if student card!)

Daily price in remote (with recording) : 12000 CHF

Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).

Tags : ms sql server 2008: implementing a database (6232a), ms 6232, ms 6232a, MS 6232.

Contents