[go: up one dir, main page]
Scribd
Upload
410 views13 pages

Microsoft Official Course: Implementing A SQL Data Warehouse

Uploaded by

Richie Poo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
410 views13 pages

Microsoft Official Course: Implementing A SQL Data Warehouse

Uploaded by

Richie Poo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 13

Microsoft Official Course

20767C
Implementing a SQL Data
Warehouse
Welcome!
Thank you for joining us today. today’s experience. We value your
feedback!
We’ve worked together with Microsoft
Learning Partners and Microsoft IT Certification Benefits. After training,
Academies to bring you a world-class consider pursuing a Microsoft
learning experience, including: Certification, to help distinguish your
technical expertise and experience. Ask
Microsoft Certified Trainers +
your instructor about available exam
Instructors. Your instructor is a
promotions and discounts.
premier technical and instructional
expert who meets ongoing We wish you a great learning
certification requirements. experience and ongoing career
success!
Customer Satisfaction Guarantee.
Our Partners offer a satisfaction
guarantee and we hold them
accountable for it. At the end of class,
please complete an evaluation of
Hello

• Instructor: <Instructor Name>


• <Title or other credentials, e.g. Microsoft
Certified Trainer>
• <Affiliation/Company>
• <A few words about my technical and
professional experience>
Student Introductions

• Name
• Company affiliation
• Title/function
• Job responsibility
• Business Intelligence experience
• Your expectations for the course
Facilities

• Class hours
• Building hours
• Parking
• Restrooms
• Meals
• Phones
• Messages
• Smoking
• Recycling
About This Course

• Audience
• Course Prerequisites
• Course Objectives
• What You Can Expect
Your Course Materials
Designed to optimize your classroom learning experience.
And support you back on the job.

Microsoft Official Course Handbook


• Organized by Modules
• Includes Labs + Lab Answer Keys
• Module Reviews + Takeaways—
great for on-the-job reference
Course Outline

• Module 1, “Introduction to Data Warehousing"


• Module 2, “Planning Data Warehouse Infrastructure"
• Module 3, “Designing and Implementing a Data Warehouse "
• Module 4, “Columnstore 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, “Master Data Services"
• Module 12, “Extending SQL Server Integration Services"
• Module 13, “Deploying and Configuring SSIS Packages"
• Module 14, “Consuming Data in a Data Warehouse"
Related Courses
• 20761C: Querying Data with Transact-SQL
• 20762C: Developing SQL Databases
• 20764C: Administering a SQL Database Infrastructure
• 20765C: Provisioning SQL Databases
• 20767C: Implementing a SQL Data Warehouse
• 20768C: Developing SQL Data Models
• 10985C: Introduction to SQL Databases
• 10986C: Updating Your Skills to SQL Server 2016
• 10987C: Performance Tuning and Optimizing SQL databases
• 10988C: Managing SQL Business Intelligence Operations
• 10989C: Analyzing Data with and PowerBI
• 10990C: Analyzing Data with SQL Server Reporting Services

See the full line of Microsoft Training and Certification resources at: http
://www.microsoft.com/learning/
Microsoft Certification Program

Get trained. Get certified.


Get ahead.
Microsoft Certifications demonstrate you
have the skills to design, deploy, and
optimize the latest technology solutions.

Ask your Microsoft Learning Partner how


you can prepare for certification.

Also see:
http://www.microsoft.com/learning/
certification
Preparing for the Labs

Your lab activities will be centered around Adventure Works


Cycles, a fictitious manufacturer and seller of cycles and related
products.

To complete the labs, you will work in a virtual


machine (VM) environment.
Virtual Machine Environment

Virtual Machine Name: Use as:

20767C-MIA-DC Domain controller

20767C-MIA-SQL Database and BI server

MSL-TMG1 Internet gateway

MIA-DC

Internet

MIA-SQL
ADVENTUREWORKS.MSFT MSL-TMG1
Demonstration: Using Hyper-V Manager

In this demonstration, you will learn how to:


• Open Hyper-V Manager
• Navigate the various sections/panes within Hyper-V Manager
• Virtual Machines, Snapshots, and Actions: Server-specific and VM-
specific
• Identify the VMs used in the labs for this course
• Take a Snapshot and Apply a Snapshot
• Connect to a VM
• Start and log on to a VM
• Switch between full screen and window modes
• Revert to the previous Snapshot
• Shut down a VM
• When to use Shut Down or Turn off
• Close Hyper-V Manager

You might also like