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.