Implementing a Microsoft SQL Server 2008 R2 Database

NederlandsDeze vijf-daagse, klassikale cursus biedt studenten de kennis en vaardigheden om een Microsoft SQL Server 2008 R2 database te implementeren. Deze cursus focust zich op het gebruik van SQL Server 2008 R2 producten en tools gerelateerd aan het implementeren van een database.=============
English This five-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server.

Doelgroep

This course is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database. To be successful in this course, the student should have knowledge of basic relational database concepts and writing T-SQL queries.

Voorkennis

Doel

Understand the product, its components, and basic configuration.
Work with the data types supported by SQL Server.
Design and implement tables and work with schemas.
Design and implement views and partitioned views.
Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
Identify the appropriate table structures and implement clustered indexes and heaps.
Describe and capture execution plans.
Design and implement non-clustered indexes, covering indexes, and included columns.
Design and implement stored procedures.
Implement table types, table valued parameters, and the MERGE statement.
Describe transactions, transaction isolation levels, and application design patterns for highly-concurrent applications.
Design and implement T-SQL error handling and structured exception handling.
Design and implement scalar and table-valued functions.
Design and implement constraints.
Design and implement triggers.
Describe and implement target use cases of SQL CLR integration.
Describe and implement XML data and schema in SQL Server.
Use FOR XML and XPath queries.
Describe and use spatial data types in SQL Server.
Implement and query full-text indexes.

Onderwerpen

De cursus Implementing a Microsoft SQL Server 2008 R2 Database behandelt de volgende onderwerpen:

Module 1: Introduction to SQL Server and its Toolset
This module introduces you to the entire SQL Server platform and its major tools. This module also covers editions, versions, basics of network listeners, and concepts of services and service accounts.

Introduction to SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server ServicesAfter completing this module, students will be able to:

Describe the SQL Server Platform.
Work with SQL Server Tools.
Configure SQL Server Services.
Module 2: Working with Data Types
This module describes the data types supported by SQL Server and how to work with them.

Using Data Types
Working with Character Data
Converting Data Types
Working with Specialized Data TypesAfter completing this module, students will be able to:

Work with data types.
Work with character data.
Convert between data types.
Use specialized data types.
Module 3: Designing and Implementing TablesThis module describes the design and implementation of tables.

Designing Tables
Working with Schemas
Creating and Altering TablesAfter completing this module, students will be able to:

Design tables.
Work with schemas.
Create and alter tables.
Module 4: Designing and Implementing Views
This module describes the design and implementation of views.

Introduction to Views
Creating and Managing Views
Performance Considerations for ViewsAfter completing this module, students will be able to:

Explain the role of views in database development.
Implement views.
Describe the performance related impacts of views.
Module 5: Planning for SQL Server Indexing
This module describes the concept of an index and discusses selectivity, density, and statistics. It covers appropriate data type choices and choices around composite index structures.

Core Indexing Concepts
Data Types and Indexes
Single Column and Composite IndexesAfter completing this module, students will be able to:

Explain core indexing concepts.
Describe the effectiveness of each data type common used in indexes.
Plan for single column and composite indexes.
Module 6: Implementing Table Structures in SQL Server
This module covers clustered indexes and heaps.

SQL Server Table Structures
Working with Clustered Indexes
Designing Effective Clustered IndexesAfter completing this module, students will be able to:

Explain how tables can be structured in SQL Server databases.
Work with clustered indexes.
Design effective clustered indexes
Module 7: Reading SQL Server Execution Plans This module introduces the concept of reading execution plans.

Execution Plan Core Concepts
Common Execution Plan Elements
Working with Execution PlansAfter completing this module, students will be able to:

Explain the core concepts related to the use of execution plans.
Describe the role of the most common execution plan elements.
Work with execution plans.
Module 8: Improving Performance through Nonclustered Indexes
This module explains nonclustered indexes, covering indexes and included columns.

Designing Effective Nonclustered Indexes
Implementing Nonclustered Indexes
Using the Database Engine Tuning AdvisorAfter completing this module, students will be able to:

Design effective nonclustered indexes.
Implement nonclustered indexes

Meer informatie?

Geïnteresseerd geraakt in deze opleiding
en wilt u weten wanneer er weer een sessie gepland wordt?

Vraag informatie aan

Lesmethode	Klassikaal
Cursusduur	5 dagen
Cursuscode	M6232
Locatie	Amsterdam-1	Drachten	Eindhoven	Groningen	Nieuwegein	Rotterdam	Zoetermeer	Zwolle	Op uw locatie?
Prijs	€ 3.453,85	€ 3.453,85	€ 3.453,85	€ 3.453,85	€ 3.453,85	€ 3.453,85	€ 3.453,85	€ 3.453,85	Vraag info aan
Actieprijs	€ 2.132,75	€ 2.132,75	€ 2.132,75	€ 2.132,75	€ 2.132,75	€ 2.132,75	€ 2.132,75	€ 2.132,75
Cursusdata (*)	18-06, 19-06, 20-06, 21-06 en 22-06.	10-09, 11-09, 12-09, 13-09 en 14-09.	15-10, 16-10, 17-10, 18-10 en 19-10.	20-08, 21-08, 22-08, 23-08 en 24-08.	04-06, 05-06, 06-06, 07-06 en 08-06. 08-10, 09-10, 10-10, 11-10 en 12-10.	10-09, 11-09, 12-09, 13-09 en 14-09.	09-07, 10-07, 11-07, 12-07 en 13-07.	20-08, 21-08, 22-08, 23-08 en 24-08.	Vraag info aan
Info van de leverancier	Info	Info	Info	Info	Info	Info	Info	Info	Vraag info aan

Ook partner worden van Pluspartner? Neem contact op met ons voor meer info.

Gerelateerde cursussen

In dezelfde cursusgroep bieden wij óók onderstaande opleidingen aan:

De cursus Implementing a Data Warehouse with Microsoft SQL Server 2012.
De cursus Implementing a Microsoft SQL Server 2008 Database (M6232).
De cursus Implementing and Maintaining Microsoft SQL Server 2008 Integration ....
De cursus Implementing and Maintaining Microsoft SQL Server 2008 Reporting Se....
De cursus Implementing and Maintaining Microsoft SQL Server2008 Analysis Serv....
De cursus Implementing Data Models and Reports with Microsoft SQL Server 2012.
De cursus Maintaining a Microsoft SQL Server 2008 Database (M6231).
De cursus Maintaining a Microsoft SQL Server 2008 R2 Database.
De cursus Updating Your SQL 2005 Skills to SQL Server 2008.
De cursus Writing Queries Using MS SQL Server 2008 Transact-SQL.

Alle vermelde prijzen zijn onder voorbehoud en exclusief BTW.

Share |