Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Would you like to be a data warehouse expert with Independent Concept Data Warehouse Training? In order to professionalize you at this topic, we gathered up all of the trainings and performed the application of the theorical informations to provide a better education.
After obtaining these informations, you’ll learn the Data Warehouse systems and its properties. In this training, all of the abilities that a Data Warehouse & Business intelligence specialist must have will be explained. In the end of the course, we’ll present a live sample of data warehouse. By using ODI (Oracle Data Integration) in the training’s content, you won’t need to do extra payment for the training of ETL tools. You’ll be able to have a wide range of informations over the topics listed bellow:
ODI (Oracle Data Integrator)
Why you should have this course?
I’m not just talking about the concept, but with its installations, I’m moving on with examples over ODI suitable for data warehouse structure and heavily used in the sector.
Despite the course language is English, I’m providing English subtitles support in order not to miss important points.
With various documents and end-of-chapter quizes, I aim to reinforce the topics.
As being more than 10 years in the sector and being an instructor in companies that have big DWH structures, I provide this course.
You are choosing an instructor that can provide support for any type of questions about the training or about DWH structures that does not fall within the training.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Section 1: Introduction|
|Section 2: Section 2: Data Warehouse Fundamentals|
Definition of a data warehouse and PropertiesPreview
Top-Down and Bottom-up ApproachPreview
Defining Inmon MethodologyPreview
Defining Kimball Methodology
Overview of Extraction, Transformation, and Loading
Overview of Change Data Capture(CDC)
Understanding Slowly Changing Dimensions(SCD)
Data Modeling and Relational Database Design
OLTP(Online Transactional Processing)
Operational Data Store (ODS)
Data Warehouse Structure
Data Mart Concepts
Data Warehousing Logical Design and Schema Approches
Performing Data Profiling
Data Quality Guide
Describing Database Metadata
|Section 3: Section 3: Installation And Examples of Oracle Data Integrator (ODI)|
How to Install Oracle Data Integrator
Creating and Connecting to ODI Master Repository
Creating and Connecting to ODI Work Repository
Setting Up the Oracle Data Integrator Topology(Physical and Logical)
Creating and Using Data Models at ODIPreview
Create a Project & Knowledge Module & Interface
Setting Up an ODI Agent
|Section 4: Section 4 :Live Demo|
Creating and Using Mappings
Data Warehouse Modelling 1
Data Warehouse Modelling 2
Data Warehouse Modelling 3
Data Warehouse Modelling 4
|Section 5: Section 5 :Documentation|
ODI Questions and Answers
DWH Questions and Answers
10 Things that must be done while starting Datawarehouse Project
10 Mistakes that are commonly done in Datawarehouse Projects
For 10 years of my work life, I’m continuing to work as an architect of Business Intelligence & Data Warehouse. I’ve realized projects over Data Warehouse and Business Intelligence in different technologies (Oracle, IBM, Teradata, Microsoft, SAP). Since 8 years, I’ve been giving trainings over Data Warehouse,SQL, Database and Business Intelligence.
Also I provide to training Companies, students and worker about BI, DWH, Reporting Tools etc.. in IT Sector.
Finally, My specialities are Modelling of DWH, ETL Development, Design of Reporting,Data Replication, Data Migration, Master Data Management, Metadata Management, Big Data.
Thanks - Good Luck!
After graduation from university I started to work as a DWH-ETL Developer in the telecommunication company. I am a data warehousing and ETL specialist having over 5+ years of experience in telecommunication and banking Industry.
Now, I am here to share my Know-how, experience and advantages of working Data Warehouse and ETL projects with them who want to plan students' career in DWH-BI and for them who want to learn about these technologies and discover further.