> > > FT-MCSA-SQL16-DBDEV

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

Course Description Schedule
 

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
Modality: C

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 Dates and Booking
 
Click on town name to book Schedule
Germany
17/12/2018 - 21/12/2018 Berlin
28/01/2019 - 01/02/2019 Berlin
04/03/2019 - 08/03/2019 Frankfurt
08/04/2019 - 12/04/2019 Düsseldorf
13/05/2019 - 17/05/2019 Munich
24/06/2019 - 28/06/2019 Münster
22/07/2019 - 26/07/2019 Hamburg
26/08/2019 - 30/08/2019 Berlin
Switzerland
13/05/2019 - 17/05/2019 Zurich
04/11/2019 - 08/11/2019 Zurich
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!