MOC 6232 - Implementing a Microsoft SQL Server 2008 Database

Details
ID | 2757644 |
Duration | 3.0 days |
Methods | Lecture with examples and exercises. |
Prerequisites | Bases MS SQL Server |
Target group | DBAs, database developers |
Overview
This 3-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server. In this course, students learn the skills and best practices on how to use SQL Server product features and tools related to implementing a database server. 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. After completing this course, students will be able to: a) Understand the product, its components, and basic configuration, b) Work with the data types supported by SQL Server, c) Design and implement tables and work with schemas / Design and implement views and partitioned views, f) 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, g) Describe and capture execution plans, h) Describe transactions, transaction isolation levels, or i) Design and implement scalar and table-valued functions, stored procedures, triggers.
Dates
Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.
Learn with customized examples and content—precisely tailored to your requirements.
Your benefits at a glance
- Flexible preferred date
- Customized content
- Intensive exchange
- High practical relevance

Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
Services
- Lunch / catering
- Help with hotel / travel
- Comelio certificate
- Flexible: free cancellation up to one day before

Content
Designing and Implementing Databases, Tables/Views and Files
Introduction to SQL Server Platform - Working with SQL Server Tools - Configuring SQL Server Services - Data Types: Using Data Types, Converting Data Types - Tables: Designing Tables, Working with Schemas, Creating and Altering Tables - Views: Introduction to Views, Creating and Managing Views, Performance Considerations for ViewsData Manipulation and Optimiziation/Tuning
Inserting, Updating, and Deleting Data - Execution Plan Core Concepts - Common Execution Plan Elements - Designing Effective (Non-)Clustered Indexes - Using the Database Engine Tuning AdvisorT-SQL Programming
Variables - Control Structure - Dynamic SQL - Transactions - Exceptions and T-SQL Error Handling - CursorsImplementing Procedures and Functions
User-Defined Functions: Designing and Implementing Scalar Functions, Designing and Implementing Table-valued Functions - Introduction to Stored Procedures - Working With Stored Procedures - Implementing Parameterized Stored ProceduresEnsuring Data Integrity through Constraints and Triggers
Enforcing Data Integrity - Implementing Domain Integrity - Implementing Entity and Referential Integrity - Implementing DML TriggersSecurity
SQL Server´s Security Concepts - Defining and Using Logins, Users and RollenData Import/Export and Backup
Import Data using T-SQL – Backup and Recovery of Database and Data/FilesInstructor
Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.Publications
- MS SQL Server - XML und SOAP-Webservices (Comelio Medien)
978-3-939701-03-3 - MS SQL Server - T-SQL Programmierung und Abfragen (Comelio Medien)
978-3-939701-02-6 - SQL und relationale Datenbanken (Comelio Medien)
978-3-939701-52-1 - Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen (Comelio Medien)
978-3-939701-23-1 - System und Systematik von Fragebögen (Comelio Medien)
978-3-939701-26-2 - MS SQL Server - XML und SOAP-Webservices (Comelio Medien)
978-3-939701-03-3 - MS SQL Server - T-SQL Programmierung und Abfragen (Comelio Medien)
978-3-939701-02-6 - SQL und relationale Datenbanken (Comelio Medien)
978-3-939701-52-1 - Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen (Comelio Medien)
978-3-939701-23-1 - System und Systematik von Fragebögen (Comelio Medien)
978-3-939701-26-2