MOC 20464

Developing Microsoft SQL Server 2014 Databases

Module 1: Introduction to Database Development
This module introduces database development and the key tasks that a database developer would typically perform.
Lessons
   Introduction to the SQL Server Platform
  SQL Server Database Development Tasks
Module 2: Designing and Implementing Tables
This module explains how to design, create, and alter tables. Also it focusses on working with schemas.
Lessons
   Designing Tables
  Data Types
  Working with Schemas
  Creating and Altering Tables
   Partitioning Data
  Compressing Data
Module 3: Ensuring Data Integrity through Constraints
This module explains how to enforce data integrity, and implement domain integrity to maintain high quality data. Also it focusses on implementing Entity and Referential Integrity.
Lessons
  Enforcing Data Integrity
   Implementing Domain Integrity
   Implementing Entity and Referential Integrity
Module 4: Introduction to 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 5: Designing Optimized Index Strategies
This module explains covering indexes and the INCLUDE clause as well as the use of padding, hints and statistics. The module also covers the use of the Database Engine Tuning Advisor and index-related dynamic management views to assess indexing strategies.
Lessons
   Covering Indexes
   Managing Indexes
   Working with Execution Plans
  Using the DTE
Module 6: Columnstore Indexes
This module explains columnstore indexes and how to use them to maximize the performance and scalability of database applications.
Lessons
   Introduction to Columnstore indexes
  Creating Columnstore Indexes
   Working with Columnstore Indexes
Module 7: Designing and Implementing Views
This module introduces Views, and explains how to create and manage Views. Also it focuses on the performance consideration for Views.
Lessons
   Introduction to Views
  Creating and Managing Views
   Performance Considerations for Views
Module 8: Designing and Implementing Stored Procedures
This module describes the potential advantages of the use of stored procedures along with guidelines on creating them.
Lessons
  Introduction to Stored Procedures
   Working With Stored Procedures
   Implementing Parameterized Stored Procedures
  Controlling Execution Context
Module 9: Designing and Implementing User-Defined Functions
This module explains how to design and implement user-defined functions that enforce business rules or data consistency, and modify and maintain existing functions written by other developers.
Lessons
   Overview of Functions
  Designing and Implementing Scalar Functions
   Designing and Implementing Table-Valued Functions
   Implementation Considerations for Functions
  Alternatives to Functions
Module 10: Responding to Data Manipulation via Triggers
This module, explains what DML triggers are and how they enforce data integrity. Also it focusses on the different types of triggers available, and how to define triggers in a database.
Lessons
   Designing DML Triggers
   Implementing DML Triggers
  Advanced Trigger Concepts
Module 11: Using In-Memory Tables
This module covers the creation of in-memory tables and native stored procedures and discusses the advantages and disadvantages of using in-memory tables.
Lessons
   In-Memory Tables
  Native Stored Procedures
Module 12: Implementing Managed Code in SQL Server 2014
This module explains how to use CLR integrated code to create user-defined database objects that are managed by the .NET Framework.
Lessons
  Introduction to SQL CLR Integration
   Importing and Configuring Assemblies
   Implementing SQL CLR Integration
Module 13: Storing and Querying XML Data in SQL Server
This module introduces XML and shows how XML data can be stored within SQL Server and then queried, including queries written in a language called XQuery.
Lessons
  Introduction to XML and XML Schemas
  Storing XML Data and Schemas in SQL Server
   Implementing the XML Data Type
   Using the T-SQL FOR XML Statement
   Getting Started with XQuery
Module 14: Working with SQL Server 2014 Spatial Data
This module introduces Spatial Data, and explains how to work with SQL Server Spatial Data Types.
Lessons
   Introduction to Spatial Data
   Working with SQL Server Spatial Data Types
  Using Spatial Data in Applications
Module 15: Incorporating Data Files into Databases
Lessons
   Querying Data with Stored Procedures
  Implementing FILESTREAM and File Tables
   Searching Data Files

Dauer: 5 Tage

Preis bei einer Person
2.750,00 € (Preise im Borussia-Park abweichend)

Dieses Training anfragen

Anfrage

Kursinfo
Detail Anfrage
Alle mit "*" gekennzeichneten Felder sind Pflichtfelder.
Der Widerruf zur zweckmäßigen Verwendung deiner Daten ist jederzeit möglich.

Mehr Ausblick

Für alle Fußball-Fans

Alle Seminare bieten wir auch in Fußballstadien an. Z.B. in einer VIP-Lounge vom Borussia Mönchengladbach.

mehr

Haben Sie Fragen?

Bitte scheuen Sie sich nicht uns zu fragen. Wir helfen Ihnen gern weiter, beraten Sie ausführlich und erstellen Ihnen gern ein Angebot.

Kontakt

Durch die Nutzung dieser Webseite stimmen Sie der Verwendung von Cookies zu.
Einzelheiten zur Nutzung von Cookies finden Sie in unserer Datenschutzerklärung. | Impressum