Menu
  • All Courses
    • Accounting
    • Administration
    • Aged Care
    • Agriculture
    • Allied Health
    • Animal Care
    • Animal Care & Sciences
    • Animal Science
    • Art & Design
    • Arts
    • Automotive
    • Beauty & Hairdressing
    • Bookkeeping
    • Building and Construction
    • Business
    • Business & Finance
    • Business Administration
    • Celebrancy
    • Change Management
    • Childcare
    • Cisco
    • Cloud Computing
    • Coding
    • Community & Health Services
    • Community Services
    • Computing & IT
    • Conservation and Land Management
    • Counselling
    • Criminal Justice & Psychology
    • Culinary Arts
    • Cyber Security
    • Database Administration & Development
    • Dentistry
    • Disability
    • Dog Grooming
    • Dog Training
    • Education
    • Engineering
    • Event Management
    • Eyebrow Specialist
    • Eyelash Extension
    • Fashion Design
    • Finance
    • Financial Planning
    • Floristry
    • Graphic Design
    • Health
    • Herbal Medicines
    • Horse Breeding & Equine Studies
    • Horticulture
    • Hospitality
    • Hospitality, Tourism & Events
    • Human Resources
    • Interior Design
    • IT
    • IT Security
    • Journalism
    • Language
    • Leadership
    • Legal
    • Logistics
    • Makeup
    • Management
    • Marketing
    • Massage
    • Mental Health
    • Microsoft
    • MYOB
    • Nail Technology
    • Natural Therapies
    • Naturopathy
    • Networking
    • Nursing
    • Nutrition
    • Nutritional Medicine
    • Pharmacy
    • Photography
    • PMBOK
    • Politics
    • Prince2
    • Professional Development
    • Programming
    • Project Management
    • Psychology
    • Real Estate
    • Retail
    • RG146
    • Sales
    • Science
    • Security
    • Six Sigma
    • Small Business
    • Social Media Marketing
    • Software
    • Sport, Fitness & Wellbeing
    • Sports & Fitness
    • Tourism
    • Training and Assessment
    • UX/UI
    • Veterinary Nursing
    • Virtual Assistant
    • Web Design
    • Web Development
    • Work Health & Safety
    • Xero
    • View All Courses
  • Search Courses
  • Contact Us
  • Education Providers
  • Blog
  • About Us
  • Affiliates
  1. Home
  2. Computing & IT
  3. Implementing a SQL Data Warehouse
Get a free course guide

Implementing a SQL Data Warehouse Microsoft 20767

Study Method
Virtual
Institution
DDLS
Start Date
Enrol anytime
Add to shortlist
DDLS Courses

Course overview

This five-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.

Expand all and read more

Who's It For?

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.

What you'll learn

After completing this course, students will be able 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

Study method

  • Virtual
    Virtual Delivery - Live and interactive classroom-style learning conducted completely online
  • Blended
    Blended delivery - both online course content and partial face to face requirements
  • In-class
    In class delivery - predominately face to face course content conducted at a specific location
  • Online
    Online delivery - online course content with the exception of assessments and work placement

Duration study load

  • 5 days

Entry requirements

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of relational databases
  • Some experience with database design
Find out more about the entry requirements for this course
Get the course guide

Course features

Control your learning experience with Microsoft Official Courses On-Demand!

Now you can build Microsoft technical expertise while balancing the demands of your schedule, with Microsoft Official Courses On-Demand (MOC On-Demand).

Subjects

Core Modules
Introduction to Data Warehousing

This module describes data warehouse concepts and architecture consideration.

Lessons

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
Planning Data Warehouse Infrastructure

This module describes the main hardware considerations for building a data warehouse.

Lessons

  • Considerations for data warehouse infrastructure
  • Planning data warehouse hardware
Designing and Implementing a Data Warehouse

This module describes how you go about designing and implementing a schema for a data warehouse.

Lessons

  • Data warehouse design overview
  • Designing dimension tables
  • Designing fact tables
  • Physical Design for a Data Warehouse
Columnstore Indexes

This module introduces Columnstore Indexes.

Lessons

  • Introduction to Columnstore Indexes
  • Creating Columnstore Indexes
  • Working with Columnstore Indexes
Implementing an Azure SQL Data Warehouse

This module describes Azure SQL Data Warehouses and how to implement them.

Lessons

  • 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
  • Copying data with the Azure data factory
And more!
Want more information about the subjects for this course?
Get the course guide

About DDLS

DDLS is Australia’s largest provider of corporate IT and process training, with the largest portfolio of strategic partners and courses in Australia. We partner with world-class companies to help organisations and individuals in the IT industry remain up-to-date with new processes, technology and platforms to reduce risk and enable efficient business practices. We have convenient locations in almost every capital in Australia as well as the Philippines, flexible delivery modalities, industry-accredited trainers, and state-of-the-art course material and labs to produce the highest quality learning outcomes for our clients.

DDLS promotes a balanced approach to training with a focus on the key areas of Technology, Process and People. We provide extensive training options tailored to your organisation’s needs – from vendor-certified courses to customised training, including bespoke in-house developed courses.

Study method

  • Virtual
    Virtual Delivery - Live and interactive classroom-style learning conducted completely online
  • Blended
    Blended delivery - both online course content and partial face to face requirements
  • In-class
    In class delivery - predominately face to face course content conducted at a specific location
  • Online
    Online delivery - online course content with the exception of assessments and work placement

Want to know more about this course?
Complete the form and learn about:

  • Pricing and payment options
  • Start dates
  • Subjects
  • Study Method
  • How to get help and contact information
  • Everything you need to know before enrolling!

Want to know more about this course?

Get your free course guide now! Complete this easy form and you'll also receive a course consultation with DDLS.

By submitting this enquiry I accept the "Privacy Policy" and "Terms of Use"

Receive a consultation from a course expert

See student testimonials below

"I found the website easy to use and the contact I received after my enquiry was good. Not too pushy but there if I needed them." - Dimity G.
"All details and info was there and my query was answered quickly." - Soula M.
"Gave me everything I needed and someone called me, pretty much straight away." - Marlon T.
  • Popular Subjects
  • Popular Blogs
  • Accounting
  • Animal Care
  • Administration
  • Agriculture
  • Beauty
  • Bookkeeping
  • Celebrancy
  • Counselling
  • Dog Grooming
  • Event Management
  • Eyelash Extension
  • Horticulture
  • Mental Health
  • MYOB
  • Nutrition
  • Nail Technology
  • Project Management
  • Real Estate
  • Veterinary Nursing
  • Xero
  • View More
  • Become a Medical Receptionist
  • Becoming a Veterinary Assistant Everything You Need To Know
  • Best Self Employed Jobs In Australia
  • Best Short Term Courses To Get You A Job In Australia
  • Future Jobs Australia
  • How To Become A Bookkeeper In Australia
  • How To Become An Actuary
  • How To Become An Engagement Manager
  • How To Become Zookeeper
  • Park Ranger
  • Unusual Jobs That You Wouldn't Know Pay More Than 100k
  • Wedding Planner
  • View More
Copyright © 2022 Shortcourses.com.au Contact About Blog Privacy Terms Advertise Affiliates

We are using cookies to give you the best experience on our website.

You can find out more about which cookies we are using or switch them off in settings.

Shortcourses.com.au
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

Additional Cookies

This website uses the following additional cookies:

(List the cookies that you are using on the website here.)

Please enable Strictly Necessary Cookies first so that we can save your preferences!