Mon-Fri 9am to 6pm CST
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
Course Info
Certificate
{{startDate}}
9:00 AM - 5:00 PM CST
Duration - 0 Days -
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
Career & Salary Insight
Outline
Practice Certification Exam
Exam Test Sample: 70-463 Implementing Data Warehouse with Microsoft SQL Server
More Information
| Brand | Microsoft |
|---|---|
| Subjects | Data Platform |
| Lab Access | Yes |
| Technology | Microsoft |
| Learning Style | Virtual Classroom |
| Learning Type | Course |
| Difficulty | Intermediate |
| Course Duration | 5 Days |
| Language | English |
Acclaim Badge
Reviews
Write Your Own Review
Related Courses
Course Expert:
Tom Robertson
(Data Science Enthusiast)
Tom is an innovator first, and then a Data Scientist & Software Architect. He has integrated expertise in business, product, technology and management. Tom has been involved in creating category defining new products in AI and big data for different industries, which generated more than hundred million revenue cumulatively, and served more than 10 million users.
As a Data Scientist and Software Architect Tom has extensive experience in data science, engineering, architecture and software development. To date Tom has accumulated over a decade of experience in R, Python & Linux Shell programming.
Tom has expertise on Python, SQL, and Spark. He has worked on several libraries including but not limited to Scikit-learn, Pandas, NumPy, Matplotlib, Seaborn, SciPy, NLTK, Keras, and Tensorflow.
Customer Reviews
-
Implementing a Data Warehouse with Microsoft SQL Server (MS20463)Course material should have focused little bit more on planning and designing data warehousing. Instructor was pretty flexible and was able to help me out understand the subject and labs.
Posted on
-
I wish my exchange class was not cancelled and when it was cancelled, it would have been good to have had a notification.
Posted on
-
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.
Posted on
-
Overall experience was great. I wasn't able to access the course through quickstart and received immediate support.
Posted on
-
Confident InstructorI 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.
Posted on
-
Real World Knowledge
Posted on
-
Great Instructor!
Posted on
-
Excellent
Posted on
-
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.
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Very enthusiastic and knowledgeable I have worked over 10 years in the IT industry when taking this training.
Posted on
-
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.
Posted on
-
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.
Posted on
-
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.
Posted on
-
Overall the instructor was very good I have worked over 10 years in the IT industry when taking this training.
Posted on
-
Posted on
-
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.
Posted on
-
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.
Posted on
-
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.
Posted on
-
Posted on
-
Posted on
-
Excellent Instructor I have worked 3-5 years in the IT industry when taking this training.
Posted on
-
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.
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Hardware was good..configuration has already been told to the client.the machine was setup accordingly. NA
Posted on
-
Posted on
-
Posted on
-
Posted on
-
More real world examples could be used
Posted on
-
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.
Posted on
-
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
Posted on
-
Posted on
-
I learn visually so I would like to see more demos and examples.
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
Posted on
-
I hope the class can provide physical book and online book
Posted on
-
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.
Posted on
-
Jeff is an excellent instructor, can explain things so a 7 year old could understand
Posted on
-
The instructor was great. He kept the class engaged, was knowledgeable and easy to follow.
Posted on
-
Posted on
-
Posted on
-
I thought the examples made the material easier to understand.
Posted on
-
Jeff was very knowledgable and patient with awnsering any and all questions.
Posted on
-
The instructor showed great knowledge in the subject area and was also very good in explaining the various modules.
Posted on
-
Posted on
-
Posted on
-
Posted on
Chat