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.
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.
Learn Data Warehousing and ETL Live Online from top industry professionals
Interactions with an Live Expert, get your doubts cleared in Real Time.
Access to World Class Instructors, from anywhere
Your guide from Edureka, to ensure you achieve your learning goals.
Live course assures 6 times more probability of getting certified
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.
1. What is a data warehouse? - Definition and explanation of the four terms - subject oriented, integrated, non volatile and time variant
5. ODS - Operational Data Store - Definition and explanation of 4 terms - Subject oriented, Integrated, Current, Volatile, Detailed6. Benefits of ODS 7. Design approach - Top down approach, bottom up approach, Federated
Learning Objectives - Learning
what a dimension and a fact is, the different types of dimensions
and facts. Reporting concept of Hierarchy.
1. Dimensions and facts - What are dimensions and facts?
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.
Learning Objectives -
Understanding principles of requirement gathering to build
a warehouse and dimensional modeling.
1. Requirement gathering
2. Principles of dimensional modelling
3. Modeling - ER diagrams
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
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.
Learning Objectives -
Implementing a data warehouse Project.
Topics - Discuss a project, its problem statement, probable solutions, and implement one solution.
This Data warehousing course enables participants with concepts of Data warehousing like Facts, Schema, Metadata, Normalization, Data transformation, Dimensional Modeling and ETL Concepts.
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
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
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.
It is a very good experience to learn from edureka!.Faculty seems excellent in sharing real world experiences.I do not feel even for single moment that i am learning from any tutor,it is like face to face gathering with an experienced person sharing it's curriculum knowledge.
Knowledgeable Presenters, Professional Materials, Excellent Customer Support what else can a person ask for when acquiring a new skill or knowledge to enhance their career. Edureka true to its name is the place to gather garner and garden the knowledge for all around the globe. My Best wishes to Edureka's team for their upcoming bright future in E-Learning sector."
I would definitely like to give more than 5 stars to Edureka, i have been associated with more than two years from now, and i have never had any issue or any complains. Support staff is excellent and very professional, the amount of time they spend with each customer is really appreciated. Today I registered for the PMP training, and Mr Shyam from sales was extremely good to do the registration process. Keep up the good work , a very well organized and structured company I would say.
I have taken 3 courses (Hadoop development, Python and Spark) in last one year. It was an excellent learning experience, most of the instructors were very interactive and having extensive industry knowledge. The support team is highly professional, always ready to assist you and let you chose your classes based on your own availability. The Learning Management System(LMS) is great. and good thing is that you would get Lifetime access to all the course that you have registered. Apart from courses and instructors, Edureka support is excellent as they provide quick resolution to any issues(example VM setup. cluster connectivity issues and etc) . If you are looking for Big Data related courses then Edureka is the right place.
The online course delivered by Edureka on big data, Hadoop - developer is really nice. The first thing of Edureka is that, the very first day of your registration, you have access the full tutorial ( record of some previous batch) and which will provide enough knowledge/teaching, so whenever you are attending your actual training session, you are not a fresher of the session, but a kind, expert and you can clear any knowledge gap.More of that, as you are getting 2 lectures for the same session, your knowledge is much more, than you would have expected. As these recording will be available you for ever, you always go again and again and again.The help/administration/support is really really good.For Hadoop big Data developer, I will recommend to join.Thanks
I have been part of Edureka family more than an year and I appreciate all the effort that edureka make for bringing the required courses to make learning easier with affordable prices. I have been part of Java/J2EE and SOA course. The courses were brilliantly designed to make the leraners understand and gain confidence on what they are learning for. I got more than what I am looking for and gathered so much of information and confidence which makes me proceed in the direction which I wished to. Thanks for Edureka and their team!!!