MOC 10776 Developing Databases for Microsoft SQL Server 2012

Das Seminar "MOC 10776 Developing Databases for Microsoft SQL Server 2012" ist seitens des Herstellers nicht mehr verfügbar, bzw. abgekündigt. Wir können Ihnen diese Schulung in Form eines Workshops in Ihrem Unternehmen oder in unserem Schulungszentrum anbieten.

Seminarinformationen

Seminar - Ziel

This 5-day course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course.
This course (10776AB) utilizes pre-release software in the virtual machine for the labs.


Hinweise:

Teilnehmer - Zielgruppe

IT Professionals who want to become skilled on SQL Server Denali product features and technologies for implementing a database

Kurs - Voraussetzungen

Seminardauer

  • 5 Tage
  • 09:00 Uhr bis 17:00 Uhr

Schulungsunterlagen

  • nach Absprache

Seminar-Inhalt / Agenda

Introduction to SQL Server 2012 and its Toolset

  • Introduction to the SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services


Working with Data Types

  • Using Data Types
  • Working with Character Data
  • Converting Data Types
  • Specialized Data Types


Designing and Implementing Tables

  • Designing Tables
  • Working with Schemas
  • Creating and Altering Tables


Ensuring Data Integrity through Constraints

  • Enforcing Data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity


Planning for SQL Server 2012 Indexing

  • Core Indexing Concepts
  • Data Types and Indexes
  • Single Column and Composite Indexes



Implementing Table Structures in SQL Server 2012

  • SQL Server Table Structures
  • Working with Clustered Indexes
  • Designing Effective Clustered Indexes


Reading SQL Server 2012 Execution Plans

  • Execution Plan Core Concepts
  • Common Execution Plan Elements
  • Working with Execution Plans


Improving Performance through Nonclustered Indexes

  • Designing Effective Nonclustered Indexes
  • Implementing Nonclustered Indexes
  • Using the Database Engine Tuning Advisor


Designing and Implementing Views

  • Introduction to Views
  • Creating and Managing Views
  • Performance Considerations for Views


Designing and Implementing Stored Procedures

  • Introduction to Stored Procedures
  • Working With Stored Procedures
  • Implementing Parameterized Stored Procedures
  • Controlling Execution Context


Merging Data and Passing Tables

  • Using the MERGE Statement
  • Implementing Table Types
  • Using TABLE Types As Parameters


Designing and Implementing User-Defined Functions

  • Overview of Functions
  • Designing and Implementing Scalar Functions
  • Designing and Implementing Table-Valued Functions
  • Implementation Considerations for Functions
  • Alternatives to Functions


Creating Highly Concurrent SQL Server 2012 Applications

  • Introduction to Transactions
  • Introduction to Locks
  • Management of Locking
  • Transaction Isolation Levels


Handling Errors in T-SQL Code

  • Understanding T-SQL Error Handling
  • Implementing T-SQL Error Handling
  • Implementing Structured Exception Handling



Responding to Data Manipulation via Triggers

  • Designing DML Triggers
  • Implementing DML Triggers
  • Advanced Trigger Concepts


Implementing Managed Code in SQL Server 2012

  • Introduction to SQL CLR Integration
  • Importing and Configuring Assemblies
  • Implementing SQL CLR Integration


Storing XML Data in SQL Server 2012

  • Introduction to XML and XML Schemas
  • Storing XML Data and Schemas in SQL Server
  • Implementing the XML Data Type


Querying XML Data in SQL Server

  • Using the T-SQL FOR XML Statement
  • Getting Started with XQuery
  • Shredding XML


Working with SQL Server 2012 Spatial Data

  • Introduction to Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications


Working with Full-Text Indexes and QueriesThis module introduces Full-Text Indexing and how to implement Full-Text Indexes in SQL Server

  • Introduction to Full-Text Indexing
  • Implementing Full-Text Indexes in SQL Server
  • Working with Full-Text Queries

Weitere Schulungen zu Thema Abgekündigte Seminare

MOC 50068 MS SQL Server 2008 für erfahrene Oracle Datenbankadministratoren

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

Verstehen der Architektur des SQL Servers. Sie sind selbstständig in der Lage das SQL Server System, die Datenbanken und Benutzer zu verwalten. Es werden Ihnen die Möglichkeiten der Tools aufgezeigt um Orakel-Diagramme zu SQL Server- Datenbanken zu migrieren.

MOC 6730 Aufbaukurs - Netzwerkinfrastruktur- und Active Directory-Technologie für Windows Server 2008

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

Windows Server 2008 zu installieren und zu konfigurieren., Windows Server Core-Rollen hinzuzufügen und zu konfigurieren., Die neue Sicherungs-Infrastruktur, einschließlich des Volumeschattenkopie-Dienstes zu erläutern., Neue und verbesserte Netzwerkfunktionen mit Windows ...

MOC 6415 Updating Your Network Infrastructure Technology Skills to Windows Server 2008

- u.a. in Hannover, Zürich, Dresden, Düsseldorf, Varaždin

Die Kursteilnehmer werden nach Beendigung des Seminars in der Lage sein den Windows Server 2008 zu installieren, zu konfigurieren, und zu administrieren. Der Einsatz von neuen Funkionen wie IPv6, NAP usw. runden den Kurs ab. Examen 70-648

MOC 20533 Implementing Microsoft Azure Infrastructure Solutions

- u.a. in Frankfurt am Main, Köln, Basel, Darmstadt, Offenbach

In diesem Seminar lernen Sie die Verwaltung Ihrer Infrastruktur mit Microsoft Azure im Vergleich zur On-Premise-Lösung