This five-day 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
Before attending this course, students must have:
Working knowledge of Transact-SQL (ability to write Transact-SQL queries) or Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.
Working knowledge of relational databases (database design skills).
Core Windows Server skills.
Basic programming language.
Lesmethode
U volgt deze training in onze Open Master Class. Door een groepsgrootte van gemiddeld 6 en maximaal 8 cursisten, bent u verzekerd van een individuele en maatgerichte training. U werkt in uw eigen tempo en beschikt over een gecertificeerde en ervaren docent die u gedurende uw training persoonlijk begeleidt en al uw vragen omtrent de lesstof beantwoordt. Uiteraard profiteert u ook bij deze training van onze 100% Kwaliteitsgarantie.
Duur
5 dagen
Tarief excl. BTW
€ 2.240,00 per deelnemer
Het tarief voor deze training is inclusief studiemateriaal, certificaat, koffie/thee en een uitgebreide lunch.
Trainingstijden
Onze trainingen vinden plaats van 9.30 tot 12.15 en van 13.15 tot 16.30 uur.
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.
Lessons
Introduction to SQL Server Platform
Working with SQL Server Tools
Configuring 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.
Lessons
Using Data Types
Working with Character Data
Converting Data Types
Working with Specialized Data Types
Module 3: Designing and Implementing Tables This module describes the design and implementation of tables.
Lessons
Designing Tables
Working with Schemas
Creating and Altering Tables
Module 4: Designing and Implementing Views This module describes the design and implementation of views.
Lessons
Introduction to Views
Creating and Managing Views
Performance Considerations for 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.
Lessons
Core Indexing Concepts
Data Types and Indexes
Single Column and Composite Indexes
Module 6: Implementing Table Structures in SQL Server This module covers clustered indexes and heaps.
Lessons
SQL Server Table Structures
Working with Clustered Indexes
Designing Effective Clustered Indexes
Module 7: Reading SQL Server Execution Plans This module introduces the concept of reading execution plans. Lessons:
Execution Plan Core Concepts
Common Execution Plan Elements
Working with Execution Plans
Module 8: Improving Performance through Nonclustered Indexes This module explains nonclustered indexes, covering indexes and included columns.
Lessons:
Designing Effective Nonclustered Indexes
Implementing Nonclustered Indexes
Using the Database Engine Tuning Advisor
Module 9: Designing and Implementing Stored Procedures This module describes the design and implementation of stored procedures.
Lessons:
Introduction to Stored Procedures
Working With Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context
Module 10: Merging Data and Passing Tables This module covers table types, table valued parameters and the MERGE statement as used in stored procedures.
Lessons:
Using the MERGE Statement
Implementing Table Types
Using Table Types as Parameters
Module 11: Creating Highly Concurrent SQL Server Applications This module covers transactions, isolation levels, and designing for concurrency.
Lessons:
Introduction to Transactions
Introduction to Locks
Management of Locking
Transaction Isolation Levels
Module 12: Handling Errors in T-SQL Code This module describes structured exception handling and gives solid examples of its use within the design of stored procedures.
Lessons:
Designing T-SQL Error Handling
Implementing T-SQL Error Handling
Implementing Structured Exception Handling
Module 13: Designing and Implementing User-Defined Functions This module describes the design and implementation of functions, both scalar and table-valued.
Lessons:
Designing and Implementing Scalar Functions
Designing and Implementing Table-valued Functions
Implementation Considerations for Functions
Alternatives To Functions
Module 14: Ensuring Data Integrity through Constraints This module describes the design and implementation of constraints.
Lessons:
Enforcing Data Integrity
Implementing Domain Integrity
Implementing Entity and Referential Integrity
Module 15: Responding to Data Manipulation via Triggers This module describes the design and implementation of triggers.
Lessons:
Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts
Module 16: Implementing Managed Code in SQL Server This module describes the implementation of and target use-cases for SQL CLR integration.
Lessons:
Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration
Module 17: Storing XML Data in SQL Server This module covers the XML data type, schema collections, typed and untyped columns and appropriate use cases for XML in SQL Server.
Lessons:
Introduction to XML and XML Schemas
Storing XML Data and Schemas in SQL Server
Implementing the XML Data Type
Module 18: Querying XML Data in SQL Server This module covers the basics of FOR XML and XPath Queries.
Lessons:
Using the T-SQL FOR XML Statement
Getting Started with XQuery
Shredding XML
Module 19: Working with SQL Server Spatial Data This module describes spatial data and how this data can be implemented within SQL Server.
Lessons:
Introduction to Spatial Data
Working with SQL Server Spatial Data Types
Using Spatial Data in Applications
Module 20: Working with Full-Text Indexes and Queries This module covers full text indexes and queries.
Niet alle gegevens zijn juist of volledig
Controleer het formulier en probeer het nogmaals.
Op deze pagina kunt u alle bij deze training behorende informatie eenvoudig en overzichtelijk printen. Daarnaast bieden wij u de mogelijkheid om direct een persoonlijke webofferte te genereren (optie 2). Maar natuurlijk sturen wij u ook graag een maatwerk- of persoonlijke offerte toe!
Optie 1: Trainingsinhoud printen.
Print
:
Optie 2: Genereer nu direct een Webofferte (PDF document).
Niet alle verplichte opties zijn geselecterd
Controleer het formulier en probeer het nogmaals.
Maak een keuze uit onderstaande opties en geef het aantal deelnemers op voor de training Implementing a Microsoft SQL Server 2008 Database (MS6232). Op de volgende pagina kunt u vervolgens per deelnemer de naam- en contactgegevens opgeven.
Inschrijven
Login op MIJN Master it met uw e-mailadres en wachtwoord.
