> > > 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.



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
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!