This 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.
At Course Completion
- Provision a Database Server.
- Upgrade SQL Server.
- Configure SQL Server.
- Manage Databases and Files (shared).
Who is the target audience?
- 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.
Microsoft Official Courses
Microsoft Official Courses On-Demand (MOC On-Demand) are authorized Microsoft official courses exclusively developed by Microsoft Certified Trainers. MOC on-demand delivers a comprehensive training experience comprising a merge of high-quality audiovisuals, academic readings, Microsoft labs online and knowledge check/assessments.
MOC on-demand is a self-paced training structured for IT Professionals and Developers which makes them proficient in the Microsoft technology and develop technical skills. It focusses on providing you a live, real-time environment for hands-on training while including all the interactive features with credible content that other On-demand offerings lack.
MOC On-Demand comprises a range of courses which are structured in a modular format consisting different modules that are further segregated into lessons, each of which contains questions to testify your knowledge.
MOC On-Demand - Features that make it the best
An online course structure which gives you utmost flexibility to learn.
Official Microsoft content
HD-quality streaming videos with interactive content delivered by expert instructors -“straight from the source”.
Digital Microsoft Official Curriculum
Access to the official curriculum anywhere & anytime.
Hands-on live labs
Microsoft Labs Online to work on your technical skills with integrated lab steps.
Knowledge check and instant feedback to mark your stand in the training process.
Microsoft-hosted mentors available to you round the clock via chat, email, & phone.
Authored by Microsoft certified experts
In-depth technical content structured by individuals who wrote the software and delivered by expert instructors.
Module 1: Introduction to Data Warehousing
Module 2: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
Module 4: Column store Indexes
Module 5: Implementing an Azure SQL Data Warehouse
Module 6: Creating an ETL Solution
Module 7: Implementing Control Flow in an SSIS Package
Module 8: Debugging and Troubleshooting SSIS Packages
Module 9: Implementing a Data Extraction Solution
Module 10: Enforcing Data Quality
Module 11: Using Master Data Services
Module 12: Extending SQL Server Integration Services (SSIS)
Module 13: Deploying and Configuring SSIS Packages
Module 14: Consuming Data in a Data Warehouse
What you’ll get in your subscription
Full access to the official Digital Microsoft Official Courseware (dMOC)
Microsoft’s HD-quality streaming videos
Access to Hands-On, Live Lab
Microsoft Training Support 24*7
Exercises, Readings and Knowledge checks
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
- Some experience with database design.