90. spotkanie Data Community Kraków
- 17:30 – 17:40 Rozpoczęcie spotkania, sprawy organizacyjne
- 17:40 – 18:40 Design and implement partitioned tables and views - Michał Sadowski
- 18:40 – 19:00 Networking
- 19:00 - 20:00 Design and implement an extract, transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package - Michał Sadowski
- 20:00 - 20:10 Zakończenie spotkania
Zapraszamy na drugie spotkanie Study Group przygotowujące do egzaminu 70-767: Implementing a Data Warehouse using SQL organizowane przez Data Community - Kraków.
ABSTRAKTY
Study Group przygotowuje do egzaminu 70-767: Implementing a Data Warehouse using SQL organizowane . Na spotkaniu będziemy omawiać następujące wymagania do egzaminu:
Design and implement partitioned tables and views - Design a partition structure to support a data warehouse, implement sliding windows, implement partition elimination, design a partition structure that supports the quick loading and scale-out of data
Design and implement an extract, transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package - Design and implement ETL control flow elements, including containers, tasks, and precedence constraints; create variables and parameters; create checkpoints, sequence and loop containers, and variables in SSIS; implement data profiling, parallelism, transactions, logging, and security