Data Warehousing Certification Training


Data Warehousing Certification Training

A Self-Paced course designed to give you a head start into Data warehousing and train you on different concepts of Data warehousing along with the implementations of these concepts.

$259.00 $207.00

Introduction to Data Warehouse

Answer: Learning Objectives - Discussing about the basic concepts of a data warehouse and why it is needed. Difference between an operational system and an analytical system, Datamarts. Approaches to build a data warehouse. Topics - 1. What is a data warehouse? - Definition and explanation of the four terms - subject oriented, integrated, non volatile and time variant 2. Need for a data warehouse 3. Difference between a database and a data warehouse. OLTP and OLAP? 4. Datamart - The smaller cousin of the data warehouse 5. ODS - Operational Data Store - Definition and explanation of 4 terms - Subject oriented, Integrated, Current, Volatile, Detailed 6. Benefits of ODS 7. Design approach - Top down approach, bottom up approach, Federated

Dimension and Fact

Answer: Learning Objectives - Learning what a dimension and a fact is, the different types of dimensions and facts. Reporting concept of Hierarchy. Topics - 1. Dimensions and facts - What are dimensions and facts? 2. Types of dimensions - emphasis on SCD 1,2,3 implementations 3. Types of facts 4. What are hierarchies - Types of Hierarchies

Normalization and Schemas

Answer: Learning Objectives - Organizing data in multiple tables. Understanding normalization and its different forms. Learning what is a schema and the different types of schemas along with meta data. Topics - 1. Normalization 2. Schemas - What is a schema. Types - Star, Snowflake, Galaxy 3. Significant role of meta data


Answer: Learning Objectives - Understanding principles of requirement gathering to build a warehouse and dimensional modeling. Topics - 1. Requirement gathering 2. Principles of dimensional modelling 3. Modeling - ER diagrams

ETL in Detail

Answer: Learning Objectives - Understanding where will the data come from and how will the data come and Populating the warehouse.Learning concepts of Extracting data, Transforming data and Loading the data into different tables. Topics - 1. ETL Concept - Architectural components - like Source, Staging, Atomic, Dimension 2. Transformation - Data Validation, Data Accuracy, Data Type Conversion, Business Rule Application 3. Data Loading techniques.


Answer: Learning Objectives - Implementing a data warehouse Project. Topics - Discuss a project, its problem statement, probable solutions, and implement one solution.

Online self paced classes

Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You’ll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.

About The Course

Answer: This Data warehousing course enables participants with concepts of Data warehousing like Facts, Schema, Metadata, Normalization, Data transformation, Dimensional Modeling and ETL Concepts.

Course Objectives

Answer: After the completion of Data warehousing course at Edureka, you will be able to: 1. Understand the concept and need of Data warehouse 2. Implement concepts of dimension and fact table 3. Implement data modelling, normalization and schema concepts 4. Model a Data warehouse 5. Implement ETL jobs

Who should go for this course?

Answer: This course is a foundation to anyone who aspires to become a Data warehouse Architect, a Data warehouse Developer or a Data warehouse Business Analyst in the field of Data warehousing and Business Intelligence. The following professionals can go for this course : 1. BI /ETL Professionals 2. Project Managers 3. Testing Professionals 4. Mainframe Professionals 5. Analytics Professionals 6. Software Developers and Architects

Are there Pre-requisites for learning this course?

Answer: The pre-requisites for this course include basic knowledge of SQL, General Relational Database (Oracle), Microsoft Windows GUI, Basic Unix, Windows Command line.

Why learn Data Warehousing?

Answer: As we move from intuition based decision making to factual decision making, it is increasingly important to capture data and store it in a way that allows us to make smarter decisions. This is where Data warehouse comes into picture. There is a huge demand for Data warehousing professionals and this course acts as a foundation which opens the door to a variety of opportunities in Business Intelligence space.

What are the system requirements for this course?

Answer: Mac machine with Yosemite operating System, with 4GB RAM and operating system can be of 32-bit or 64-bit. If you do not have a mac machine, we will assist you in renting a remote mac machine over the cloud, e.g. through OR You can use any other service provider as well for executing the practicals.

How will I execute the Practicals?

Answer: For your practical work, we will help you setup Edureka's Virtual Machine in your System. The required installation guide is present in LMS.

Which Case-Studies or Project will be a part this course?

Answer: Towards the end of the Course, you will be working on a live project where you will be using Swift language to design beautiful and efficient iOS Applications. Project Name : Development of E-commerce application. Industry : E-commerce Problem Statement : Creating E-commerce application for iOS platform which will allow user to browse available products and purchase them.

What if I miss a class?

Answer: \"You will never miss a lecture at CertAddda You can choose either of the two options: View the recorded session of the class available in your LMS. You can attend the missed session, in any other live batch.\"

How soon after Signing up would I get access to the Learning Content?

Answer: Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover the access to our 24x7 support team will be granted instantly as well. You can start learning right away.

What if I have queries after I complete this course?

Answer: Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Do I get any assistance from CertAdda to fill up the application form?

Answer: Yes, we will guide you on how to apply & fill up the ACP® application form in PMI® website. You can use the following link to apply for examination: Apply for Exam

Will I get placement assistance?

Answer: To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the \"create your resume\" option.

Is the course material accessible to the students even after the course training is over?

Answer: Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

Who are the instructors?

Answer: All the instructors at CertAdda are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by CertAdda for providing an awesome learning experience to the participants.

What if I have more queries?

Answer: You can give us a CALL at +91 8178510474 / +91 9967920486 OR email at