> > > SQLBC

Fast Track: SQL Data Platform & Data Analytics (SQLBC)

Course Description Schedule
 

Who should attend

Datenbank-Administratoren, die praxisorientiert die Konfiguration und Wartung des Microsoft SQL Server 2017 erlernen wollen, vor allem mit dem Ziel, BI-Lösungen aufzubauen, zu erweitern und zu pflegen.

Prerequisites

Datenbank-Grundwissen.

Course Objectives

Am Ende des Kurses sind Sie in der Lage, Microsoft SQL Server Datenbanken zu installieren und zu betreiben. Sie kennen die Prozesse und Strukturen von BI-Lösungen und sind in der Lage, den ETL-Prozess (Data- und Workflow), die Datenspeicherung und die Präsentation der Daten zu begleiten bzw. aufzubauen.

Course Content

Data Platform:
  • Introduction to T-SQL Querying
  • Querying multiple tables
  • Sorting & filtering data
  • Using Window Ranking, Offset and Aggregate Functions
  • Programming with T-SQL
  • Recovery Models and Backup Strategies
  • Backing Up SQL Server Databases
  • Restoring SQL Server Databases
  • SQL Server Security
  • Authorizing Users to Access Resources
Data Analytics
  • Planning Data Warehouse Infrastructure
  • Creating an ETL Solution
  • Implementing Control Flow
  • Implementing Data Flow
  • Debugging and Troubleshooting the ETL Process
  • Deploying and Configuring SSIS-Packages
  • Building Dynamic ETL with BIML
  • Exploring Data Vault
  • Building the Business Layer
  • Working with Cubes
Classroom Training
Modality: C

Duration 5 days

Price (excl. tax)
  • Germany: 3,290.- €
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.


Dates and Booking
 
Click on town name to book Schedule
Germany
11/02/2019 - 15/02/2019 Stuttgart
01/04/2019 - 05/04/2019 Düsseldorf
13/05/2019 - 17/05/2019 Frankfurt
08/07/2019 - 12/07/2019 Berlin
26/08/2019 - 30/08/2019 Munich
21/10/2019 - 25/10/2019 Hamburg
02/12/2019 - 06/12/2019 Münster
 

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