Voorheen Eduhub

2779: Implementing a Microsoft SQL Server 2005 Database

Niveau:
MBO+
Kosten:
€ 2.090,-   Prijsinformatie
Totale lesduur:
5 dagen
Max. deelnemers:
8
Logo Master it Training
Gratis brochure aanvragen

Tip: Ontvang gratis en vrijblijvend meer informatie over programma, startdatum, locatie, prijzen en inschrijving:

Overzicht

Ervaring met deze cursus?

Heeft u de cursus 2779: Implementing a Microsoft SQL Server 2005 Database bij Master it Training gevolgd? Help anderen door uw ervaring te delen op Springest!

Springest doneert €1,- aan Stichting Edukans als dank voor jouw ervaring

Deel je ervaring
 
Tijdstip:
Overdag
Looptijd:
dagen
Afronding:
Certificaat
Soort locatie:
Open inschrijving
Regio('s):
Eindhoven, Utrecht, Rotterdam, Amsterdam
Prijsinformatie:
 
Het tarief is incl. studiemateriaal en lunch, excl. BTW
Gratis brochure aanvragen

Beschrijving

This five-day course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

Doelgroep

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Voorkennis

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

In addition, it is recommended, but not required, that students have completed:

  • Course MS2778; Writing Queries Using Microsoft SQL Server Transact-SQL.
  • Course MS2780; Maintaining a Microsoft SQL Server 2005 Database.

Inhoud

Module 1: Creating Databases and Database Files This module explains how to create databases, filegroups, schemas, and database snapshots.

Lessons

  • Creating Databases
  • Creating Filegroups
  • Creating Schemas
  • Creating Database Snapshots
Module 2: Creating Data Types and Tables This module explains how to create data types and tables. It also describes how to create partitioned tables.

Lessons

  • Creating Data Types
  • Creating Tables
  • Creating Partitioned Tables
Module 3: Using XML This module explains how to use the FOR XML clause and the OPENXML function. It also describes how to use the xml data type and its methods.

Lessons

  • Retrieving XML by Using FOR XML
  • Shredding XML by Using OPENXML
  • Introducing XQuery
  • Using the xml Data Type
Module 4: Creating and Tuning Indexes This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.

Lessons

  • Planning Indexes
  • Creating Indexes
  • Optimizing Indexes
  • Creating XML Indexes
Module 5: Implementing Data Integrity by Using Constraints This module explains how to implement constraints and provides an overview of data integrity.

Lessons

  • Data Integrity Overview
  • Implementing Constraints
Module 6: Implementing Data Integrity by Using Triggers and XML Schemas This module explains how to implement triggers and XML schemas.

Lessons

  • Implementing Triggers
  • Implementing XML Schemas
Module 7: Implementing Views This module explains how to create views.

Lessons

  • Introduction to Views
  • Creating and Managing Views
  • Optimizing Performance by Using Views
Module 8: Implementing Stored Procedures This module explains how to create stored procedures and functions. It also describes execution plans, plan caching, and query compilation.

Lessons

  • Implementing Stored Procedures
  • Creating Parameterized Stored Procedures
  • Working With Execution Plans
  • Handling Errors
Module 9: Implementing Functions This module explains how to create functions. It also describes how to control the execution context.

Lessons

  • Creating and Using Functions
  • Working with Functions
  • Controlling Execution Context
Module 10: Implementing Managed Code in the Database This module explains how to implement managed database objects.

Lessons

  • Introduction to the SQL Server Common Language Runtime
  • Importing and Configuring Assemblies
  • Creating Managed Database Objects
Module 11: Managing Transactions and Locks This module explains how to use transactions and the SQL Server locking mechanisms to meet the performance and data integrity requirements of your applications.

Lessons

  • Overview of Transactions and Locks
  • Managing Transactions
  • Understanding SQL Server Locking Architecture
  • Managing Locks
Module 12: Using Service Broker This module explains how to build a messaging-based solution with Service Broker.

Lessons

  • Service Broker Overview
  • Creating Service Broker Objects
  • Sending and Receiving Messages
Module 13: Using Notification Services (Optional)
This module explains how to develop applications that generate and send timely messages to subscribers.

Lessons

  • Introduction to Notification Services
  • Developing Notification Services Solutions

TIP: op alle trainingen van Master it Training ontvangt u een 100% Kwaliteitsgarantie!

Ervaringen

Er zijn nog geen ervaringen. Deel je ervaring en help zo anderen kiezen. Als dank doneert Springest €1,- aan Stichting Edukans.

Ervaring delen

Deel je ervaring

Je helpt hiermee anderen kiezen. Als dank doneert Springest €1,- aan Stichting Edukans.

Zelf deelgenomen?

E-mail Gebruik een andere validatiemethode Slechts ter voorkoming van misbruik. We delen niks namens jou op je netwerk en delen gegevens nooit met derden.
(optioneel)
(optioneel)

Ja, stuur mij gratis en vrijblijvend meer informatie:

Springest stuurt uw aanvraag direct naar de juiste persoon bij Master it Training. U ontvangt dan via e-mail of post meer informatie over de cursus. We gaan uiteraard vertrouwelijk om met uw gegevens.

(optioneel)
(optioneel)
(optioneel)

Meer trainingen in dit onderwerp:

Vergelijk 27.086 trainingen en opleidingen in Microsoft SQL Server

Nieuwsbrief ontvangen?

Abonneer u op onze nieuwsbrief en ontvang maandelijks een update over persoonlijke ontwikkeling en carrièretips. Lees alle nieuwsbrieven

Volg ons op: Facebook Twitter LinkedIn

Bekijk trainingen per categorie

Springest nieuwsbrief

Over Springest

Andere landen

Nederland
© 2008 – 2012 Springest
Help