ODI 11g Hands On Tutorials
ODI 11g Hands On Tutorials, available at $59.99, has an average rating of 4.05, with 84 lectures, 11 quizzes, based on 327 reviews, and has 1577 subscribers.
You will learn about First, you are made familiar with the basics of ETL processes and then learn how to use of ODI development objects with the help of practical examples. You then move on to get an understanding of ODI’s transformation vehicles and its interface, followed by how ODI packages can be used to develop more workflow-based data integration tasks. Next we show you how reusable objects can be customized by using variables to suit your needs. The following sections broaden your understanding of topologies, scenarios, load plans, and data integration solutions. By the end of the course, you will have enough knowledge of ODI, development, deployment, and maintenance techniques to give you the confidence to develop your own data integration projects. Covering all the key ODI concepts, this video course shows you how to make the best use of ODI’s declarative approach to define your strategy with Knowledge Modules. This video course will show you how to use ODI for your data transformation and integration projects. It will also provide you with valuable input on which methods to use for various ODI objects according to the situation, with examples based on real-life requirements. Describe ODI Model concepts Describe architecture of Oracle Data Integrator 11g Apply ODI Topology concepts for data integration Design ODI Interfaces, Procedures, Packages, and Load Plans to perform ELT data transformations Explore, audit data, and enforce data quality with ODI Administer ODI resources and setup security with ODI Implement Changed Data Capture with ODI This course is ideal for individuals who are SOA Architect or Data Warehouse Administrator or Database Administrators or Data Modelers or Business Analysts or Technical Consultant or Beginers It is particularly useful for SOA Architect or Data Warehouse Administrator or Database Administrators or Data Modelers or Business Analysts or Technical Consultant or Beginers.
Enroll now: ODI 11g Hands On Tutorials
Summary
Title: ODI 11g Hands On Tutorials
Price: $59.99
Average Rating: 4.05
Number of Lectures: 84
Number of Quizzes: 11
Number of Published Lectures: 82
Number of Published Quizzes: 11
Number of Curriculum Items: 95
Number of Published Curriculum Objects: 93
Original Price: $39.99
Quality Status: approved
Status: Live
What You Will Learn
- First, you are made familiar with the basics of ETL processes and then learn how to use of ODI development objects with the help of practical examples. You then move on to get an understanding of ODI’s transformation vehicles and its interface, followed by how ODI packages can be used to develop more workflow-based data integration tasks. Next we show you how reusable objects can be customized by using variables to suit your needs. The following sections broaden your understanding of topologies, scenarios, load plans, and data integration solutions.
- By the end of the course, you will have enough knowledge of ODI, development, deployment, and maintenance techniques to give you the confidence to develop your own data integration projects.
- Covering all the key ODI concepts, this video course shows you how to make the best use of ODI’s declarative approach to define your strategy with Knowledge Modules.
- This video course will show you how to use ODI for your data transformation and integration projects. It will also provide you with valuable input on which methods to use for various ODI objects according to the situation, with examples based on real-life requirements.
- Describe ODI Model concepts
- Describe architecture of Oracle Data Integrator 11g
- Apply ODI Topology concepts for data integration
- Design ODI Interfaces, Procedures, Packages, and Load Plans to perform ELT data transformations
- Explore, audit data, and enforce data quality with ODI
- Administer ODI resources and setup security with ODI
- Implement Changed Data Capture with ODI
Who Should Attend
- SOA Architect
- Data Warehouse Administrator
- Database Administrators
- Data Modelers
- Business Analysts
- Technical Consultant
- Beginers
Target Audiences
- SOA Architect
- Data Warehouse Administrator
- Database Administrators
- Data Modelers
- Business Analysts
- Technical Consultant
- Beginers
Overview:
- ·Our Video courses: practical screencast-based tutorials that show you how to get the job done.
- 3 live practice tests covers all possible questions of ODI 11g certification exam where each test consists of live 71 questions. Each video tutorial section is followed by a quiz to test your skills.
- ·Develop the necessary skills for effectively carrying out data integration and transformations in ODI11g interfaces
- ·Understand the use of ODI11g development objects with methods and concepts illustrated from real projects
- ·Master the key concepts of ODI 11g’s physical and logical architecture and the use of Knowledge Modules and data models
- ·It covers complete ODI 11g Developer & Administrator video Tutorials
What You will learn:
Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data – the approach that optimizes performance, scalability and lowers overall solution costs.
This offering details on how to use Oracle Data Integrator (ODI) 11g to implement high-performance movement and transformation of data among various platforms. It also deals with usage of ODI 11g graphical user interfaces that enable user to access different ODI 11g components and resources that form ODI 11g infrastructure. Using the graphical interfaces, you create and manage ODI 11g repositories, which stores configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI 11g Topology, organize ODI 11gmodels and design ODI 11g interfaces, procedures, packages and other objects.
Oracle Data Integrator (ODI) 11g is Oracle’s strategic tool covering all your data integration requirements. ODI 11g lets you write custom code easily, extract data from source files, transform data in a staging area, and load this data to your target database. So, if you are a database administrator with an aim to effectively use ODI 11g as a powerful tool for data integration solutions, it’s time you started making the most of it.
16 key Reasons to buy this course:
1. 24/7 Course Access for lifetime
2. As interactive as Classroom training
3. Very Cost effective
4. Advanced way of teaching
5. In depth explanation of each topic
6. Contains Hands on sessions
7. Any New module will be without additional charge
8. No travel and Hassel
9. Learn as per your comfort
10. Real time scenarios Hands on
11. Practice at Home using Virtual Machine
12. Free installation of ODI 11g software in your laptop
13. 100% Support will be provided to practice the Hands on's
14. More than 50 videos as on date (08-04-2014).
New videos will be added every week
15.Covers complex scenarios to aim ODI 11g certification
16. Covers most of the scenarios from ODI 11g blogs
Course Curriculum
Chapter 1: Overview of Oracle data integrator
Lecture 1: ETL vs ELT
Lecture 2: ETL and ELT Approaches
Lecture 3: Introduction to Oracle Data Integrator 11g
Lecture 4: Oracle Data Integrator overview
Lecture 5: ODI Studio Components
Lecture 6: ODI Repositories
Lecture 7: Optional: Overview of Oracle Data Integrator
Chapter 2: Product Installation
Lecture 1: Demonstration Scripts and files (Lab setup)
Lecture 2: Lecture:7 Oracle Data Integrator Developer Installation
Lecture 3: Oracle Data Integrator Developer Installation Document
Lecture 4: Creating Schemas for repositories
Lecture 5: Creating Master Repository
Lecture 6: Creating connection to Master Repository
Lecture 7: Creating work Repository
Lecture 8: Attaching work Repository to Master Repository
Chapter 3: Topology Setup
Lecture 1: Setting up Topology
Lecture 2: Hide unused Technologies
Chapter 4: Models
Lecture 1: Creating Models and Reverse Engineering
Lecture 2: Querying Data store
Lecture 3: ODI Data store & Counting number of rows
Chapter 5: Project and Interfaces
Lecture 1: Creating an Integration Project
Lecture 2: Introduction to Knowledge Modules
Lecture 3: Types of Knowledge modules
Lecture 4: Optional: Knowledge Module usage
Lecture 5: Importing Knowledge Modules
Lecture 6: Introduction to Business rules
Lecture 7: Creating Simple Interfaces
Lecture 8: Debugging Interfaces using Operator
Lecture 9: Optional: Creating an Integration Project and Importing Knowledgemodules
Lecture 10: Optional: Creating Simple Interface Example -1
Lecture 11: Optional-2 Creating Simple Interface Example-2
Chapter 6: Filter Transformations
Lecture 1: Simple Filter Transforamtion
Lecture 2: Optional Creating Filter Transformation Example-1
Lecture 3: Filter Transformation Examples
Lecture 4: Optional Creating Filter Transformation Example-2
Lecture 5: Advanced Filter Transformation
Lecture 6: Optional Creating Filter Transformation Example-3
Chapter 7: Join Transformations
Lecture 1: Inner Join Transformation
Lecture 2: Optional : Join Transformation
Lecture 3: Left outer Join Transformation
Lecture 4: Right Outer Join Transformation
Lecture 5: Between Join Transforamtion
Lecture 6: Self Join Transformation
Chapter 8: Set Operators Transformations
Lecture 1: Union Transformation
Lecture 2: Union All Transformation
Lecture 3: Minus Transformation
Lecture 4: Intersect Transformation
Chapter 9: Complex Transformations
Lecture 1: ODI Pivot: Rows to columns Transformation
Lecture 2: ODI Pivot: Columns to Rows Transformation
Chapter 10: Lookups Transformations
Lecture 1: Creating Lookup Transformations
Chapter 11: Slowly changing Dimension Transformations
Lecture 1: Implementing SCD Type-1 Transformations
Lecture 2: Implementing SCD Type-2 Transformation
Chapter 12: Aggregation Transformations
Lecture 1: Handling Group By in ODI
Chapter 13: Yellow Interfaces in ODI
Lecture 1: Implemernting subqueries in ODI through yellow interfaces
Chapter 14: Knowledge Modules
Lecture 1: Overview of LKM and IKM knowledge Modules in ODI
Chapter 15: Files and XML Transformations
Lecture 1: Exporting Delimeter Flat File to RDBMS
Lecture 2: Exporting Fixed width Flat File to RDBMS
Lecture 3: Exporting XML to RDBMS
Chapter 16: Procedures and Packages
Lecture 1: Creating an ODI Procedure
Lecture 2: Package Overview
Lecture 3: Creating Packages in ODI
Chapter 17: Variables and Complex Package
Lecture 1: Variables Overview
Lecture 2: creating loops in ODI Package (Multiple sources single target)
Chapter 18: Data Quality in ODI
Lecture 1: Data Quality Introduction
Lecture 2: Creating constraints in ODI
Lecture 3: Creating a data quality check interfaces in ODI
Chapter 19: Change Data Capture
Lecture 1: Overview and Implementation of change data capture in ODI
Chapter 20: ODI Run Time Components Installations
Lecture 1: ODI Run time components overview
Lecture 2: ODI StandAlone Agent Installation
Lecture 3: ODI Standalone Agent Installation Video Part1
Lecture 4: ODI Standalone Agent Installation Video Part2
Chapter 21: Scenarios & Load Plans
Lecture 1: ODI Scenario Overview video
Instructors
-
RAM KUMAR
Certified Oracle Cloud Analytics Specialist
Rating Distribution
- 1 stars: 32 votes
- 2 stars: 34 votes
- 3 stars: 91 votes
- 4 stars: 95 votes
- 5 stars: 75 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Best Parenting Skills Courses to Learn in March 2025
- Best Home Improvement Courses to Learn in March 2025
- Best Gardening Courses to Learn in March 2025
- Best Sewing And Knitting Courses to Learn in March 2025
- Best Interior Design Courses to Learn in March 2025
- Best Writing Courses Courses to Learn in March 2025
- Best Storytelling Courses to Learn in March 2025
- Best Creativity Workshops Courses to Learn in March 2025
- Best Resilience Training Courses to Learn in March 2025
- Best Emotional Intelligence Courses to Learn in March 2025
- Best Time Management Courses to Learn in March 2025
- Best Remote Work Strategies Courses to Learn in March 2025
- Best Freelancing Courses to Learn in March 2025
- Best E-commerce Strategies Courses to Learn in March 2025
- Best Personal Branding Courses to Learn in March 2025
- Best Stock Market Trading Courses to Learn in March 2025
- Best Real Estate Investing Courses to Learn in March 2025
- Best Financial Technology Courses to Learn in March 2025
- Best Agile Methodologies Courses to Learn in March 2025
- Best Project Management Courses to Learn in March 2025