Loading...

Terminy kursów:

26.11.2018 - 30.11.2018
17.12.2018 - 21.12.2018
25.03.2019 - 29.03.2019
24.06.2019 - 28.06.2019

Oficjalny konspekt Microsoft Pozostałe szkolenia

MS-20463 Implementing a Data Warehouse with Microsoft SQL Server

Czas trwania kursu: 5 dni
Cena: 2299zł

KLUCZOWE ZAGADNIENIA

  • zrozumienie czym jest hurtownia danych
  • tworzenie pakietów SSIS – Control Flow, Data Flow, kontenery
  • logowanie i obsługa błędów pakietów
  • wdrażanie gotowych projektów i uruchamianie pakietów
  • DQS, czyli dbanie o jakość danych
  • podstawy zarządzania danymi za pomocą MDS

Bartosz Ratajczyk, Microsoft Certified Trainer

 CERTYFIKACJE ZAWODOWE

Certyfikacja podstawowa CertyfIkacja specjalistyczna Certyfikacja ekspercka
FUNDAMENTALS ASSOCIATE EXPERT

 

Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce MCSA: SQL Server 2012
Dowiedz się więcej o certyfikacjach Microsoft


POZIOM SZKOLENIA

podstawowy średniozaawansowany zaawansowany ekspercki
100 200 300 400

 

TEMATYKA ZAJĘĆ

  • Module 1: Introduction to Data Warehousing
    Overview of Data Warehousing
    Considerations for a Data Warehouse Solution
    Lab : Exploring a Data Warehousing Solution

 

  • Module 2: Data Warehouse Hardware Considerations
    Considerations for building a Data Warehouse
    Data Warehouse Reference Architectures and Appliances
    Lab : Planning Data Warehouse Infrastructure

 

  • Module 3: Designing and Implementing a Data Warehouse
    Logical Design for a Data Warehouse
    Physical design for a data warehouse
    Lab : Implementing a Data Warehouse Schema

 

  • Module 4: Creating an ETL Solution with SSIS
    Introduction to ETL with SSIS
    Exploring Data Sources
    Implementing Data Flow
    Lab : Implementing Data Flow in an SSIS Package

 

  • Module 5: Implementing Control Flow in an SSIS Package
    Introduction to Control Flow
    Creating Dynamic Packages
    Using Containers
    Managing Consistency
    Lab : Implementing Control Flow in an SSIS Package
    Lab : Using Transactions and Checkpoints

 

  • Module 6: Debugging and Troubleshooting SSIS Packages
    Debugging an SSIS Package
    Logging SSIS Package Events
    Handling Errors in an SSIS Package
    Lab : Debugging and Troubleshooting an SSIS Package

 

  • Module 7: Implementing an Incremental ETL Process
    Introduction to Incremental ETL
    Extracting Modified Data
    Loading Modified data
    Lab : Loading Incremental Changes
    Lab : Extracting Modified Data

 

  • Module 8: Enforcing Data Quality
    Introduction to Data Quality
    Using Data Quality Services to Cleanse Data
    Using Data Quality Services to Match data
    Lab : Cleansing Data
    Lab : De-duplicating data

 

  • Module 9: Using Master Data Services
    Master Data Services Concepts
    Implementing a Master Data Services Model
    Managing Master Data
    Creating a Master Data Hub
    Lab : Implementing Master Data Services

 

  • Module 10: Extending SQL Server Integration Services
    Using Scripts in SSIS
    Using Custom Components in SSIS
    Lab : Using Custom Components and Scripts

 

  • Module 11: Deploying and Configuring SSIS Packages
    Overview of SSIS Deployment
    Deploying SSIS Projects
    Planning SSIS Package Execution
    Lab : Deploying and Configuring SSIS Packages

 

  • Module 12: Consuming Data in a Data Warehouse
    Introduction to Business Intelligence
    Introduction to Reporting
    An Introduction to Data Analysis
    Lab : Using Business Intelligence Tools

MS-101T02: Microsoft 365 Compliance Management
MS-100T01: Office 365 Management
MS-100T02: Microsoft 365 Tenant & Service Management
MS-100T03: Microsoft 365 Identity Management
MS-101 Office 365
10.12.2018 - 13.12.2018
MS-100 Office 365
03.12.2018 - 06.12.2018
AZ-301T02: Designing a Data Platform Solution
MS-40551 Microsoft Security Workshop: Enterprise Security Fundamentals
MS-40555 Microsoft Security Workshop: Implementing PowerShell Security Best Practices
MS-40552 Microsoft Security Workshop: Managing Identity
MS-40553 Microsoft Security Workshop: Planning for a Secure Enterprise – Improving Detection
MS – Microsoft Security Workshop
14.01.2019 - 18.01.2019
MS-20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014
SQL Server 2012/2014
MS-20466 Implementing Data Models and Reports with SQL Server 2014
SQL Server 2012/2014
28.01.2019 - 01.02.2019
MS-20465 Designing Solutions for Microsoft SQL Server 2014
SQL Server 2012/2014
14.01.2019 - 16.01.2019
MS-20464 Developing Microsoft SQL Server 2014 Databases
SQL Server 2012/2014
07.01.2019 - 11.01.2019
MS-40554 Microsoft Security Workshop: Implementing Windows 10 Security Features
AZ-301T01: Designing for Identity and Security Show all
AZ-301T03: Designing for Deployment, Migration, and Integration
AZ-301T04: Designing an Infrastructure Strategy
AZ-301 Microsoft Azure Architect Design
21.01.2019 - 24.01.2019
AZ-300T06: Developing for the Cloud
AZ-300T05: Implementing Authentication and Secure Data
AZ-300T04: Creating and Deploying Apps
AZ-300T03: Understanding Cloud Architect Technology Solutions
AZ-300T02: Implementing Workloads and Security
AZ-300T01: Deploying and Configuring Infrastructure
AZ-300 Microsoft Azure Architect Technologies
26.11.2018 - 30.11.2018
AZ-201T03: Develop Azure Cognitive Services, Bot, and IoT Solutions
AZ-201T02: Implement Azure Development Integration Solutions
AZ-201T01: Develop for an Azure Cloud Model
AZ-201 Microsoft Azure Developer Advanced Solutions
19.11.2018 - 22.11.2018
AZ-200T01: Select the Appropriate Azure Technology Development Solution
AZ-200T02: Develop for Azure Storage
AZ-200T03: Develop Azure Platform as a Service Solutions
AZ-200T04: Implement Security in Azure Development Solutions
AZ-200 Microsoft Azure Developer Core Solutions
12.11.2018 - 15.11.2018
AZ-101T01: Migrate Servers to Azure
AZ-101T02: Implementing and Managing Application Services
AZ-101T03: Implement Advanced Virtual Networking
AZ-101T04: Secure Identities
AZ-101 Microsoft Azure Integration and Security
05.11.2018 - 08.11.2018
AZ-100T04: Configuring and Managing Virtual Networks
AZ-100T02: Implementing and Managing Storage
AZ-100T03: Deploying and Managing Virtual Machines
AZ-100T05: Manage Identities
MS-101T01: Microsoft 365 Security Management
AZ-100T01: Manage Subscriptions and Resources
AZ-100 Microsoft Azure Infrastructure and Deployment
14.01.2019 - 18.01.2019
MS-101T03: Microsoft 365 Device Management
MS-10986 Updating Your Skills to SQL Server 2016
SQL Server 2016
05.11.2018 - 07.11.2018
MS-10985 Introduction to SQL Databases
SQL Server 2012/2014
25.03.2019 - 27.03.2019
MS-10994 Data Analysis Fundamentals using Excel
SQL Server 2016
08.11.2018 - 09.11.2018
MS-20537 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack
MCSA
05.11.2018 - 09.11.2018
MS-20535 Architecting Microsoft Azure Solutions
Windows
12.11.2018 - 16.11.2018
MS-55224-2 Operationalize Cloud Analytics Solutions with Microsoft Azure
MCSE
26.11.2018 - 27.11.2018
MS-55224-1 Microsoft Azure Big Data Analytics Solutions
SQL Server 2016
26.11.2018 - 27.11.2018
MS-20776 Engineering Data with Microsoft Cloud Services
SQL Server 2016
19.11.2018 - 23.11.2018
MS-20773 Analyzing Big Data with Microsoft R
SQL Server 2016
03.12.2018 - 05.12.2018
MS-20775 Performing Data Engineering on Microsoft HD Insight
SQL Server 2016
12.11.2018 - 16.11.2018
MS-55021 Configuring and Administering Hyper-V in Windows Server 2012
Windows Server 2012/2012R2
02.01.2019 - 04.01.2019
MS-20778 Analyzing Data with Power BI
SQL Server 2016
19.11.2018 - 21.11.2018
MS-20779 Analyzing Data with Excel
SQL Server 2016
05.11.2018 - 07.11.2018
MS-20417 Upgrading Your Skills to MCSA Windows Server 2012
Windows Server 2012/2012R2
17.12.2018 - 21.12.2018
MS-20414 Implementing an Advanced Server Infrastructure
Windows Server 2012/2012R2
10.12.2018 - 14.12.2018
MS-20413 Designing and Implementing a Server Infrastructure
Windows Server 2012/2012R2
03.12.2018 - 07.12.2018
MS-20409 Server Virtualization with Windows Server Hyper-V and System Center
Windows Server 2012/2012R2
17.09.2018 - 21.09.2018
MS-10974 Deploying and Migrating Windows Servers
Windows Server 2012/2012R2
19.11.2018 - 21.11.2018
MS-10970 Networking with Windows Server
Windows Server 2012/2012R2
11.02.2019 - 15.02.2019
MS-20697-2 Deploying and Managing Windows 10 Using Enterprise Services
Windows 10
17.12.2018 - 21.12.2018
MS-20697-1 Implementing and Managing Windows 10
Windows 10
01.10.2018 - 05.10.2018
MS-10982 Supporting and Troubleshooting Windows 10
Windows 10
15.10.2018 - 19.10.2018
MS-20412 Configuring Advanced Windows Server 2012 Services
Windows Server 2012/2012R2
05.11.2018 - 09.11.2018
MS-20411 Administering Windows Server 2012
Windows Server 2012/2012R2
19.11.2018 - 23.11.2018
MS-20410 Installing and Configuring Windows Server 2012
Windows Server 2012/2012R2
12.11.2018 - 16.11.2018
MS-20774 Perform Cloud Data Science with Azure Machine Learning
SQL Server 2016
05.11.2018 - 09.11.2018
MS-55200 SharePoint 2016 Power User Training
SharePoint 2016
05.11.2018 - 06.11.2018
MS-55199 SharePoint 2016 End User Training
SharePoint 2016
19.11.2018 - 21.11.2018
MS-20745 Implementing a Software-Defined DataCenter
System Center
03.12.2018 - 07.12.2018
MS-10997 Office 365 Administration and Troubleshooting
Office 365
19.11.2018 - 21.11.2018
MS-20703-2 Integrating MDM and Cloud Services with System Center Configuration Manager
System Center
05.11.2018 - 07.11.2018
MS-20703-1 Administering System Center Configuration Manager
System Center
19.11.2018 - 23.11.2018
MS-10996 Hybrid Cloud and Datacenter Monitoring with Operations Management Suite (OMS)
03.12.2018 - 07.12.2018
MS-20489 Developing Microsoft SharePoint Server 2013 Advanced Solutions
SharePoint 2013
05.11.2018 - 09.11.2018
MS-20532 Developing Microsoft Azure Solutions
MCSA
10.12.2018 - 14.12.2018
MS-55247 Designing and Implementing Cloud Data Platform Solutions
08.10.2018 - 10.10.2018
MS-20487 Developing Windows Azure and Web Services
Programowanie
26.11.2018 - 30.11.2018
MS-20486 Developing ASP.NET MVC 4 Web Applications
Programowanie
19.11.2018 - 23.11.2018
MS-20483 Programming in C#
Programowanie
12.11.2018 - 16.11.2018
MS-20480 Programming in HTML5 with JavaScript and CSS3
Programowanie
17.12.2018 - 21.12.2018
MS-10962 Advanced Automated Administration with Windows PowerShell
MCSA
29.10.2018 - 31.10.2018
MCSA: Cloud Platform
MCSA
08.04.2019 - 29.05.2019
MS-55154 Office 365 for the End-User
Office 365
19.11.2018 - 19.11.2018
MS-55179 Advanced Microsoft Outlook 2016
06.11.2018 - 06.11.2018
MS-55178 Introduction to Microsoft Outlook 2016
05.11.2018 - 05.11.2018
MS-55177 Advanced Microsoft PowerPoint 2016
PowerPoint 2016
07.12.2018 - 07.12.2018
MS-55176 Introduction to Microsoft PowerPoint 2016
PowerPoint 2016
06.12.2018 - 06.12.2018
MS-55167 Advanced Microsoft Excel 2016
Excel 2016
07.11.2018 - 07.11.2018
MS-55166 Intermediate Microsoft Excel 2016
Excel 2016
11.12.2018 - 11.12.2018
MS-55165 Introduction to Microsoft Excel 2016
Excel 2016
05.11.2018 - 05.11.2018
MS-55175 Advanced Microsoft Word 2016
Word 2016
05.12.2018 - 05.12.2018
MS-55174 Intermediate Microsoft Word 2016
Word 2016
04.12.2018 - 04.12.2018
MS-55173 Introduction to Microsoft Word 2016
Word 2016
03.12.2018 - 03.12.2018
MS-20698 Installing and Configuring Windows 10
Windows 10
19.11.2018 - 23.11.2018
MS-10993 Integrating On-Premises Identity Infrastructure with Microsoft Azure
05.11.2018 - 06.11.2018
MS-10992 Integrating On-Premises Core Infrastructure with Microsoft Azure
19.11.2018 - 21.11.2018
MCSA: Windows Server 2016
MCSA
18.03.2019 - 29.05.2019
MS-20768 Developing SQL Data Models
SQL Server 2016
12.11.2018 - 14.11.2018
MS-20767 Implementing a SQL Data Warehouse
SQL Server 2016
17.12.2018 - 21.12.2018
MS-20334 Core Solutions of Skype for Business 2015
Skype for Business 2015
03.12.2018 - 07.12.2018
MS-20744 Securing Windows Server 2016
Windows Server 2016
28.01.2019 - 01.02.2019
MS-20337 Enterprise Voice and Online Services with Microsoft Lync Server 2013
Lync Server 2013
10.12.2018 - 14.12.2018
MS-20336 Core Solutions of Microsoft Lync Server 2013
Lync Server 2013
03.12.2018 - 07.12.2018
MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager
System Center
12.11.2018 - 16.11.2018
MS-55004 Installing and Configuring System Center 2012 Operations Manager
System Center
10.12.2018 - 10.12.2018
MS-20765 Provisioning SQL Databases
SQL Server 2016
10.12.2018 - 14.12.2018
MS-20764 Administering a SQL Database Infrastructure
SQL Server 2016
26.11.2018 - 09.11.2018
MS-20762 Developing SQL Databases
SQL Server 2016
19.11.2018 - 23.11.2018
MS-20761 Querying Data with Transact-SQL
SQL Server 2016
12.11.2018 - 16.11.2018
MS-50255 Managing Windows Environments with Group Policy
Windows Server 2012/2012R2
18.03.2019 - 22.03.2019
MS-20339-2 Advanced Technologies of SharePoint 2016
SharePoint 2016
12.11.2018 - 16.11.2018
MS-20339-1 Planning and Administering SharePoint 2016
SharePoint 2016
17.12.2018 - 21.12.2018
MS-20741 Networking with Windows Server 2016
Windows Server 2016
05.11.2018 - 09.11.2018
MS-20740 Installation, Storage, and Compute with Windows Server 2016
Windows Server 2016
13.11.2018 - 16.11.2018
MS-20742 Identity with Windows Server 2016
Windows Server 2016
17.12.2018 - 21.12.2018
MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016
Exchange Server 2016
19.11.2018 - 23.11.2018
MS-20345-1 Administering Microsoft Exchange Server 2016
Exchange Server 2016
07.01.2019 - 11.01.2019
MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016
Windows Server 2016
25.02.2019 - 01.03.2019
MS-10972 Administering the Web Server (IIS) Role of Windows Server
Windows Server 2012/2012R2
12.11.2018 - 16.11.2018
MS-10967 Fundamentals of a Windows Server Infrastructure
Windows Server 2012/2012R2
19.11.2018 - 23.11.2018
MS-10971 Storage and High Availability with Windows Server
Windows Server 2012/2012R2
05.11.2018 - 08.11.2018
MS-10969 Active Directory Services with Windows Server
Windows Server 2012/2012R2
26.11.2018 - 30.11.2018
MS-20488 Developing Microsoft SharePoint Server 2013 Core Solutions
SharePoint 2013
19.11.2018 - 23.11.2018
MS-20332 Advanced Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
12.11.2018 - 16.11.2018
MS-20331 Core Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
17.12.2018 - 21.12.2018
Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune
Microsoft Azure / Office 365 / Windows Intune
12.11.2018 - 14.11.2018
Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
03.12.2018 - 05.12.2018
Bezpieczeństwo w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
26.11.2018 - 28.11.2018
Podstawy bezpieczeństwa w środowiskach Microsoft
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
19.11.2018 - 21.11.2018
MCSA: Office 365
MCSA
09.04.2019 - 30.05.2019
MCSA: SQL Server 2014
MCSA
11.10.2018 - 20.12.2018
MS-10961 Automating Administration with Windows PowerShell
MCSA
21.01.2019 - 25.01.2019
MS-20342 Advanced Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
10.12.2018 - 14.12.2018
MS-20341 Core Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
03.12.2018 - 07.12.2018
MS-20533 Implementing Microsoft Azure Infrastructure Solutions
26.11.2018 - 30.11.2018
MS-10979 Microsoft Azure Fundamentals
13.11.2018 - 14.11.2018
MS-10748 Planning and Deploying System Center 2012 Configuration Manager
System Center
05.11.2018 - 07.11.2018
MS-20347 Enabling and Managing Office 365
Office 365
03.12.2018 - 07.12.2018
MS-20463 Implementing a Data Warehouse with Microsoft SQL Server
SQL Server 2012/2014
26.11.2018 - 30.11.2018
MS-20462 Administering Microsoft SQL Server Databases
SQL Server 2012/2014
10.12.2018 - 14.12.2018
MS-20461 Querying Microsoft SQL Server
SQL Server 2012/2014
12.11.2018 - 16.11.2018