This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

The primary audience for this course is IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database.

The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server database.

Inhalte

• Introduction to Database Development
• Designing and Implementing Tables
• Advanced Table Designs
• Ensuring Data Integrity through Constraints
• Introduction to Indexes
• Designing Optimized Index Strategies
• Columnstore Indexes
• Designing and Implementing Views
• Designing and Implementing Stored Procedures
• Designing and Implementing User-Defined Functions
• Responding to Data Manipulation via Triggers
• Using In-Memory Tables
• Implementing Managed Code in SQL Server
• Storing and Querying XML Data in SQL Server
• Storing and Querying Spatial Data in SQL Server
• Storing and Querying Blobs and Text Documents in SQL Server

Voraussetzungen

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.

Seminarzeiten

Dieses Seminar findet täglich von 9:00 – ca. 17:00 Uhr statt.

Seminarsprache und -unterlagen

Die Seminarsprache ist Deutsch, die Seminarunterlagen werden in englischer Sprache zur Verfügung gestellt.

Enthaltene Leistungen

Im Seminarpreis sind die Seminarunterlagen, die Pausenverpflegung (Kaffee, Tee, kalte Getränke, Kekse, Süßigkeiten) sowie die Mittagsverpflegung enthalten.

Zertifizierungen

MCSA: SQL 2016 Database Development

Weiterführende Seminare

MOC10986 Updating Your Skills to SQL Server 2016

MOC20761 Querying Data with Transact-SQL

MOC20764 Administering a SQL Database Infrastructure

MOC20767 Implementing a SQL Data Warehouse

MOC20768 Developing SQL Data Models

Referenzen

SQL Server

SQLServer

MySql