Implementing a Data Warehouse with Microsoft SQL Server (MS-20463)

This course helps professionals learn the art of implementing a data warehouse and helps professionals proficiently work with Business Intelligence Solutions.

Virtual

Learning Style

Microsoft

Provider

Intermediate

Difficulty

5 Days

Course Duration

5

SATV Value

Course Info

Download PDF

Certificate

See Sample

SubscribeBuy Individually
empty table
tab
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1189 other popular courses
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
43 Learners Have Enrolled For This Course

You have already taken demo for this course.

If you want to get access to demo again, feel free to contact our support at (855) 800-8240

This course helps professionals learn the art of implementing a data warehouse and helps professionals proficiently work with Business Intelligence Solutions.

Course Information

Candidates enrolling directly in this course without the Master Subscription Plan will receive a free official exam voucher for the 70-463 Exam (Except Purchases included in Training Vouchers/SATV). There is no free official exam voucher for candidates enrolling using the Master Subscription Plan. However, the official exam voucher can be purchased separately on request.

About this Course:

This intermediate-level 5-days course provides professionals with the conceptual insight of Data Warehousing. This course helps professionals learn the art of implementing a data warehouse and helps professionals proficiently work with Business Intelligence Solutions. The primary objective of this course is to train & prepare students for success in the Microsoft 70-463 Certification Exam. Through this course, professionals will learn the art of handling Microsoft SQL Servers proficiently and will help them become proficient BI Leaders

Course Objectives:

The core objective of this course is to help professional gain a better understanding and sound knowledge of the following key concepts:

  • Data Warehouse Architecture Considerations & Concepts
  • Hardware Platform Selection for Data Warehousing
  • Data Warehouse Implementation and Design
  • SSIS Package Control Flow & Data Flow Implementation
  • Troubleshooting and Debugging SSIS Packages
  • ETL Solution Implementation for Incremental Data Loading & Data Extraction
  • Microsoft Data Quality Services Data Cleansing Implementation
  • Enforcing Data Integrity by Master Data Services Implementation
  • SSIS Extension with Custom Components and Scripts
  • SSIS Packages Deployment and Configuration
  • BI Solution Data Consumption from Data Warehouse

Audience:

  • Business Intelligence Developers
  • Database Professionals
  • Professionals liable for Implementing Data Warehouse & Data Cleansing
  • Developers Creating & Developing BI Solutions
  • Professionals liable for Developing SSIS Packages & Enforcing Data Integrity

Prerequisites:

Professionals planning to enroll in this course must comply with the following prerequisites:

  • 2-Years’ Practical Experience of Relational Databases
  • Familiarity with Transact SQL Querying, Tables Creation, & Normalized Databases
  • Fundamental Knowledge of Branching, Looping, other Programming Concepts
  • Understanding of Major Business Priorities is highly Recommended

Outline

More Information

More Information
BrandMicrosoft
SubjectsIT Ops & Management
Lab AccessYes
TechnologyMicrosoft
Learning StyleVirtual Classroom
Learning TypeCourse
DifficultyIntermediate
Course Duration5 Days
LanguageEnglish
SATV Value5
VPA DiscountVPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Information
Virtual instructor Led

Virtual Classroom Courses

Our virtual instructor-led courses give you access to live instructors training you with other live students in a virtual classroom environment.

200+ Virtual Classroom Courses
Information
Self-Paced

Online Self-Paced Courses

Take self-paced online courses at your convenience and own pace, with unlimited access to courses in various emerging technologies.

700+ Self-Paced Courses
Information
College

E-books blogs, case studies, ariticles

As part of informal learning, our platform will recommend E-books, whitepapers, case studies, articles, and videos. This is AI curated content closely aligned with your learning objectives.

E-books blogs, case studies,...
Information
College

College Accredited Courses

QuickStart courses are accredited by several top schools and universities, including Texas A&M and University of Phoenix. You can print out certificates and also apply them towards your degree plan with them.

College Accredited
Information
Dashboard

Full Learning Dashboard & Analytics

Access all your enrolled, completed, course statistics, and community discussions from one centralized and intuitive learning dashboard with built in analytics, course tracking, time spent, and more.

Analytics/Reporting
Information
Social

QuickStart Discussions

Engage with other learners where you can directly chat, ask questions, and socialize with other learners experts and instructors on a course subject.

Community Access Community Access
Information
Labs

Virtual Labs

Videos and lectures only go so far. Get real world, hands-on practice with virtual labs (not available for all courses).

Virtual Labs Virtual Labs
Information
Live Instructor Support

Live Instructor Mentoring & Support

Get your IT problems solved through a community of mentors, experts and peers. Get live help from experts to answer questions on course material or guidance on a project.

Mentoring & Discussions Mentoring & Discussions
Information
Dashboard

Career Paths

Start a learning pathway towards understanding and mastering your career. With QuickStart career paths, you can fully understanding and being the best in your field.

Learning Paths Learning Paths
Information
Dashboard

Informal Learning

Access to AI curated content from various content publishers which can help in self-directed learning.

Informal Learning Informal Learning
Customer Reviews
  1. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    I wish my exchange class was not cancelled and when it was cancelled, it would have been good to have had a notification.

    Review by

    Posted on

  2. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Paula Woodall is a first­rate instructor, knowledgeable and organized. The class material was comprehensive, although a bit dated (SS2014). I have had a mix of experiences with QuickStart, but use more instructors like Paula, and update curriculum, and I will be back.

    Review by

    Posted on

  3. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Overall experience was great. I wasn't able to access the course through quickstart and received immediate support.

    Review by

    Posted on

  4. Confident Instructor
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I found Jeff personable,approachable and very knowledgeable on the subject matter. I feel like the labs cover a lot and I definitely need to go over them again to fully understand everything - however all the necessary components are there.

    Review by

    Posted on

  5. Real World Knowledge
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  6. Great Instructor!
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  7. Excellent
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  8. Course Value
    100%
    Quality of Instructor
    60%
    Overall Satisfaction
    60%
    9 isn't high enough in terms of a top rating! Instructors are great. I have worked less than 1 year in the IT industry when taking this training.

    Review by

    Posted on

  9. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  10. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  11. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  12. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  13. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Very enthusiastic and knowledgeable I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  14. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Great job I enjoyed class thoroughly and learned a lot. I have worked less than 1 year in the IT industry when taking this training.

    Review by

    Posted on

  15. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    40%
    Jeff has great stories on history of SQL Server and practical real world examples on how the tech is used. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  16. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Jeff is a fantastic trainer. Very knowledgeable on the subject matter. Great teaching skills. Quickly develops a great rapport with the students. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  17. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Overall the instructor was very good I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  18. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  19. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I don't have much experience in SQL server the instructor provided the information needed for me at work. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  20. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Jeff has been outstanding answering all our questions queries and provided relevant examples and references. He is a subject matter expert. Love to take his classes. ~Sushant I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  21. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Like Jeff's approach on presenting the course material through real life situations.It is effective in understanding and applying the knowledge. I don't like when instructor read from the manual; I can do that on my own. Jeff is a great instructor and communicator. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  22. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  23. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  24. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Excellent Instructor I have worked 3-5 years in the IT industry when taking this training.

    Review by

    Posted on

  25. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    Jeff clearly has a grasp of the course material and was more than willing and able to answer any questions I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  26. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  27. Quality of Instructor
    80%

    Review by

    Posted on

  28. Course Quality
    80%
    Quality of Instructor
    60%
    Overall Satisfaction
    80%

    Review by

    Posted on

  29. Quality of Instructor
    100%

    Review by

    Posted on

  30. Quality of Instructor
    100%
    Hardware was good..configuration has already been told to the client.the machine was setup accordingly. NA

    Review by

    Posted on

  31. Quality of Instructor
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  32. Quality of Instructor
    100%

    Review by

    Posted on

  33. Overall Satisfaction
    80%

    Review by

    Posted on

  34. Course Quality
    80%
    Overall Satisfaction
    100%
    More real world examples could be used

    Review by

    Posted on

  35. Overall Satisfaction
    100%
    Very well put together class. Jeff is very practical and knowledgeable. Willing to share. I would not change much. Just make sure the students know they must have some SQL experience. Otherwise, this is very hard class with no SQL exp.

    Review by

    Posted on

  36. Quality of Instructor
    80%
    Overall Satisfaction
    100%
    With not having any experience what so ever with DW, I would have like so spend more time learning about dimensions and fact tables. Also, which tables do users query on for reports for the most of the time

    Review by

    Posted on

  37. Overall Satisfaction
    100%

    Review by

    Posted on

  38. Overall Satisfaction
    80%
    I learn visually so I would like to see more demos and examples.

    Review by

    Posted on

  39. Overall Satisfaction
    100%

    Review by

    Posted on

  40. Quality of Instructor
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  41. Overall Satisfaction
    100%

    Review by

    Posted on

  42. Course Quality
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  43. Overall Satisfaction
    100%

    Review by

    Posted on

  44. Course Quality
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  45. Overall Satisfaction
    100%
    I hope the class can provide physical book and online book

    Review by

    Posted on

  46. Overall Satisfaction
    100%
    It was made clear that another course is focused more on reporting, but it would be nice to have the full package/overview from inception to user delivery Jeff's knowledge and ability to pass it on in a clear and concise manner is great.

    Review by

    Posted on

  47. Course Quality
    60%
    Overall Satisfaction
    100%
    Jeff is an excellent instructor, can explain things so a 7 year old could understand

    Review by

    Posted on

  48. Course Quality
    80%
    Overall Satisfaction
    100%
    The instructor was great. He kept the class engaged, was knowledgeable and easy to follow.

    Review by

    Posted on

  49. Overall Satisfaction
    100%

    Review by

    Posted on

  50. Overall Satisfaction
    100%

    Review by

    Posted on

  51. Overall Satisfaction
    100%
    I thought the examples made the material easier to understand.

    Review by

    Posted on

  52. Course Quality
    80%
    Overall Satisfaction
    100%
    Jeff was very knowledgable and patient with awnsering any and all questions.

    Review by

    Posted on

  53. Course Quality
    60%
    Course Value
    60%
    Overall Satisfaction
    100%
    The instructor showed great knowledge in the subject area and was also very good in explaining the various modules.

    Review by

    Posted on

  54. Overall Satisfaction
    100%

    Review by

    Posted on

  55. Course Value
    60%
    Quality of Instructor
    60%
    Overall Satisfaction
    80%

    Review by

    Posted on

  56. Overall Satisfaction
    100%

    Review by

    Posted on

click here