We are happy to advise you!
+49 40 253346-10     Contact
> > > FT-MCSA-SQL16-DBDEV

Fast Track: MCSA SQL 2016 Database Development (FT-MCSA-SQL16-DBDEV)

 

Course Overview

  • Einmaliger Kursbesuch 5 Tage
  • Original MOC Unterlagen (MOC20761 / MOC20762)
  • 2 Prüfungsvoucher für die Examen 70-761 und 70-762

Who should attend

Datenbank Administratoren, Datenbank Entwickler und Business Intelligence Professionals.

Prerequisites

  • Grundlegende Kenntnisse über das Microsoft Windows Betriebssystem sowie Kern Funktionalität.
  • Kenntnisse über relationale Datenbanken.
  • Grundlegende Kenntnisse zu Transact SQL

Course Objectives

Dieser 5-tägige Power Workshop kombiniert die Inhalte aus den beiden Microsoft SQL 2016 Kursen Querying Data with Transact-SQL (MOC 20761) sowie Developing SQL Databases (MOC 20762) und bereitet die Teilnehmer optimal auf die Prüfung zum MCSA: SQL 2016 Database Development vor.

Course Content

Querying Data with Transact-SQL (MOC 20761)

  • Module 1: Introduction to Microsoft SQL Server 2016
  • Module 2: Introduction to T-SQL Querying
  • Module 3: Writing SELECT Queries
  • Module 4: Querying Multiple Tables
  • Module 5: Sorting and Filtering Data
  • Module 6: Working with SQL Server 2016 Data Types
  • Module 7: Using DML to Modify Data
  • Module 8: Using Built-In Functions
  • Module 9: Grouping and Aggregating Data
  • Module 10: Using Subqueries
  • Module 11: Using Set Operators

Developing SQL Databases (MOC 20762)

  • Module 1: Introduction to Database Development
  • Module 2: Designing and Implementing Tables
  • Module 3: Advanced Table Designs
  • Module 4: Ensuring Data Integrity through Constraints
  • Module 5: Introduction to Indexes
  • Module 6: Designing Optimized Index Strategies
  • Module 7: Columnstore Indexes
  • Module 8: Designing and Implementing Views
  • Module 9: Designing and Implementing Stored Procedures
  • Module 10: Designing and Implementing User-Defined Functions
  • Module 11: Responding to Data Manipulation via Triggers
  • Module 12: Using In-Memory Tables
  • Module 13: Implementing Managed Code in SQL Server
  • Module 14: Storing and Querying XML Data in SQL Server
  • Module 15: Working with SQL Server Spatial Data
  • Module 16: Storing and Querying Blobs and Text Documents in SQL Server
Classroom Training

Duration 5 days

Price (excl. tax)
  • Germany: 2,990.- €
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


Digital courseware

Courseware language: English

 
Click on town name to book Schedule
Germany
13/01/2020 - 17/01/2020 Frankfurt
30/03/2020 - 03/04/2020 Hamburg
06/07/2020 - 10/07/2020 Berlin
05/10/2020 - 09/10/2020 Munich
Switzerland
05/10/2020 - 09/10/2020 Zurich