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.
You Will Learn How To:
- Describe the key elements of a data warehousing solution
- Describe the main hardware considerations for building a data warehouse
- Implement a logical design for a data warehouse
- Implement a physical design for a data warehouse
- Create columnstore indexes
- Implementing an Azure SQL Data Warehouse
- Describe the key features of SSIS
- Implement a data flow by using SSIS
- Implement control flow by using tasks and precedence constraints
- Create dynamic packages that include variables and parameters
- Debug SSIS packages
- Describe the considerations for implement an ETL solution
- Implement Data Quality Services
- Implement a Master Data Services model
- Describe how you can use custom components to extend SSIS
- Deploy SSIS projects
- Describe BI and common BI scenarios
-
On-Demand Training Description
With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.
PLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!
- Flexibility to take the course on your own time, at your own pace
- Forever access to the digital course materials – for any refreshers
- You will receive a code with your purchase.The code may be redeemed for online access to this On Demand course for up to six months
- Upon course activation, the MOC On Demand videos and labs are available for three months
- 2 FREE hours of individual coaching from an MCT Learning Tree Instructor
- This delivery is also eligible for Microsoft Assurance Training Vouchers (SATVs)
- NOTE: Only live, in-class training is eligible for NASBA CPEs; on-demand training is not eligible for CPE credit
-
Requirements
- In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- At least 2 years’ experience of working with relational databases, including:
- Designing a normalized database
- Creating tables and relationships
- Querying with Transact-SQL
- Some exposure to basic programming constructs (such as looping and branching)
- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
- In addition to their professional experience, students who attend this training should already have the following technical knowledge:
-
Exam Information
This course can help you prepare for the following Microsoft certification exam — 70-767: Implementing a Data Warehouse using SQL
-
Redeem Your Microsoft Training Vouchers (SATV):
- This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
- Want to learn more about Microsoft SATVs? Click to view our SATVs infographic.