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

OPEN
IN-HOUSE

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
Service-Kaffeekanne

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 Views
Data 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 Advisor
T-SQL Programming
Variables - Control Structure - Dynamic SQL - Transactions - Exceptions and T-SQL Error Handling - Cursors
Implementing 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 Procedures
Ensuring Data Integrity through Constraints and Triggers
Enforcing Data Integrity - Implementing Domain Integrity - Implementing Entity and Referential Integrity - Implementing DML Triggers
Security
SQL Server´s Security Concepts - Defining and Using Logins, Users and Rollen
Data Import/Export and Backup
Import Data using T-SQL – Backup and Recovery of Database and Data/Files

Instructor

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

Projects

He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Research

He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining.

Certificates

nMarco Skulschus is "Microsoft Certified Trainer" and passed the ComptiaCTT+ examination.