This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
Wir empfehlen den Besuch unserer smart Seminare:
After completing this course, students will be able to:
- Provision a Database Server
-
Upgrade SQL Server
-
Configure SQL Server
-
Manage Databases and Files (shared)
Alle Details einblenden
Zielgruppe
The primary audience for this course are:
- database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
Vorkenntnisse
This course requires that you meet the following prerequisites:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
-
Working knowledge of relational databases.
-
Some experience with database design
Schwerpunkte
- Module 1: Introduction to Data Warehousing
- Overview of Data Warehousing
- Considerations for a Data Warehouse Solution
- Lab: Exploring a Data Warehouse Solution
- Module 2: Planning Data Warehouse Infrastructure
- 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: Columnstore Indexes
- Introduction to Columnstore Indexes
- Creating Columnstore Indexes
- Working with Columnstore Indexes
- Lab: Using Columnstore Indexes
- Module 5: Implementing an Azure SQL Data Warehouse
- Advantages of Azure SQL Data Warehouse
- Implementing an Azure SQL Data Warehouse
- Developing an Azure SQL Data Warehouse
- Migrating to an Azure SQ Data Warehouse
- Lab: Implementing an Azure SQL Data Warehouse
- Module 6: Creating an ETL Solution
- Introduction to ETL with SSIS
- Exploring Source Data
- Implementing Data Flow
- Lab: Implementing Data Flow in an SSIS Package
- Module 7: Implementing Control Flow in an SSIS Package
- Introduction to Control Flow
- Creating Dynamic Packages
- Using Containers
- Lab: Implementing Control Flow in an SSIS Package
- Lab: Using Transactions and Checkpoints
- Module 8: 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
- Log SSIS package events
- Handle errors in an SSIS package
- Module 9: Implementing an Incremental ETL Process
- Introduction to Incremental ETL
- Extracting Modified Data
- Temporal Tables
- Lab: Extracting Modified Data
- Lab: Loading Incremental Changes
- Module 10: 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 11: 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 12: Extending SQL Server Integration Services (SSIS)
- Using Custom Components in SSIS
- Using Scripting in SSIS
- Lab: Using Scripts and Custom Components
- Module 13: Deploying and Configuring SSIS Packages
- Overview of SSIS Deployment
- Deploying SSIS Projects
- Planning SSIS Package Execution
- Lab: Deploying and Configuring SSIS Packages
- Module 14: Consuming Data in a Data Warehouse
- Introduction to Business Intelligence
- Introduction to Reporting
- An Introduction to Data Analysis
- Analyzing Data with Azure SQL Data Warehouse
- Lab: Using Business Intelligence Tools
Alle Details ausblenden
