Det finns inga varor i din kundvagn. Fortsätt handla på vår Kurskatalog sida.
Betala Nu -ELLER- betala Senare
Betala med kreditkort nu
-ELLER - betala mot faktura som vanligt.
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
Plus, get prepped for Microsoft exam 70-767, a requirement for MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics.
LIVE, LÄRARLEDD
FÖRETAGSINTERN UTBILDNING
Anpassa kurs och innehåll efter teamets behov
Kontakta ossLearning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .
1 - 5 mar
9:00 - 4:30 GMT
Online (AnyWare)
24 - 28 maj
9:00 - 4:30 BST
Online (AnyWare)
16 - 20 aug
9:00 - 4:30 BST
Online (AnyWare)
15 - 19 nov
9:00 - 4:30 GMT
Online (AnyWare)
22 - 26 mar
9:00 - 4:30 EDT
Online (AnyWare)
19 - 23 apr
9:00 - 4:30 EDT
New York / Online (AnyWare)
20 - 24 sep
9:00 - 4:30 EDT
Herndon, VA / Online (AnyWare)
18 - 22 okt
9:00 - 4:30 EDT
New York / Online (AnyWare)
Kurs med startgaranti
När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.This course can help you prepare for the following Microsoft certification exam — 70-767: Implementing a Data Warehouse using SQL
Describe data warehouse concepts and architecture considerations.
Lessons
Lab: Exploring a Data Warehouse Solution
After completing this module, students will be able to:
This module describes the main hardware considerations for building a data warehouse.
Lessons
Lab: Planning Data Warehouse Infrastructure
After completing this module, students will be able to:
This module describes how you go about designing and implementing a schema for a data warehouse.
Lessons
Lab: Implementing a Data Warehouse Schema
After completing this module, students will be able to:
This module introduces Columnstore Indexes.
Lessons
Lab: Using Columnstore Indexes
After completing this module, students will be able to:
This module describes Azure SQL Data Warehouses and how to implement them.
Lessons
Lab: Implementing an Azure SQL Data Warehouse
After completing this module, students will be able to:
At the end of this module you will be able to implement data flow in a SSIS package.
Lessons
Lab: Implementing Data Flow in an SSIS Package
After completing this module, students will be able to:
This module describes implementing control flow in an SSIS package.
Lessons
Lab: Implementing Control Flow in an SSIS Package
Lab: Using Transactions and Checkpoints
After completing this module, students will be able to:
This module describes how to debug and troubleshoot SSIS packages.
Lessons
Lab: Debugging and Troubleshooting an SSIS Package
After completing this module, students will be able to:
This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.
Lessons
Lab: Extracting Modified Data
Lab: Loading Incremental Changes
After completing this module, students will be able to:
This module describes how to implement data cleansing by using Microsoft Data Quality services.
Lessons
Lab: Cleansing Data
Lab: De-duplicating Data
After completing this module, students will be able to:
This module describes how to implement master data services to enforce data integrity at source.
Lessons
Lab: Implementing Master Data Services
After completing this module, students will be able to:
This module describes how to extend SSIS with custom scripts and components.
Lessons
Lab: Using Scripts
After completing this module, students will be able to:
This module describes how to deploy and configure SSIS packages.
Lessons
Lab: Deploying and Configuring SSIS Packages
After completing this module, students will be able to:
This module describes how to debug and troubleshoot SSIS packages.
Lessons
Lab: Using Business Intelligence Tools
After completing this module, students will be able to:
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs.
Yes! This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
This course helps prepare you for the Microsoft 70-767 certification exam, Implementing a SQL Data Warehouse (beta).
Yes! It fulfills a requirement for MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics certifications.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.