Oracle Data Warehousing Development
Diploma Course – Oracle Data Warehousing Development : (D3)
Sample Training Video :
Oracle Data Warehousing Development is a Job Oriented Training Program. Candidates who join this Oracle Data Warehousing Development program will undergo a training on SQL, PL/SQL, UNIX & Shell Scripting. Oracle Data Warehousing Development Design and concepts, ETL (Extract, Transform & Load). Training will be provided as part of a hands-on industry strength ETL project. This project will walk you through the process of designing and building a real-life data mart for a Retail Sales Corporation.
What you will learn in Oracle Data Warehousing Development
In this course, students study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn the reasons why data warehousing is a compelling decision-support solution in today’s business climate. Participants also examine what Oracle has to offer to a successful data warehouse implementation by identifying the proven Data Warehouse and Business Intelligence (DW and BI) technologies and tools provided by Oracle.
Course Syllabus for Oracle Data Warehousing Development
Unit 1 – Red Hat Essentials
- Linux ideas and history.
- Linux usage basics
- Running commands and getting help
- Browsing the file system
- Users, groups and permissions
- Using the bash shell
- Standard i/o and pipes Network clients
- Advanced topics in users, groups and permissions
- Text processing tools
- Vim: an advanced text editor
- Basic system configuration tools
- Investigating the bash shell
- Finding and processing files
- Essential system administration tools
- The linux file system in depth
Unit 2 – Oracle SQL
- Basic SQL Statement
- Restricting and Sorting Data
- Single Row Functions
- Displaying Data from Multiple Tables
- Aggregating Data by Using Group Functions
- Writing Sub queries
- Sqlplus, isqlplus
- Manipulating Data
- Managing Tables, Constraints
- Views
- Other Database Objects
- Controlling User Access
- Using Set Operators
- Hierarchical Retrieval
- Oracle Extensions to DML and DDL Statements
Unit 3 – PL/SQL Programming
- Introduction.
- Declaring Variables
- Writing Executable Statements
- Interacting with the Oracle Server
- Writing Control Structures
- Working with Composite Data types
- Writing Explicit Cursors
- Advanced Explicit Cursor concepts
- Handling Exceptions
- Creating Functions
- Managing Subprograms
- Creating Packages
- More Package Concepts
- Using Oracle-Supplied Packages
- Creating Database Triggers
- More Trigger Concepts
- Managing Dependencies
- Manipulating Large Objects
- Creating Procedures
Unit 4 – UNIX Shell Scripting
- Bash & bash scripts
- Writing & debugging
- Shell initialization files
- Shell variables, expansion, alias
- Grep, egrep, fgrep
- Sed, awk, sort, uniq
- Introduction to “if”
- Using case statement
- Interactive scripts
- Loop (for, while)
- I/O Redirection
- Break, continue
- Database connectivity
- Menu driven scripts
- Automated emails
- Cron scheduler
Unit 5 – Data Warehousing Project
- Dealing with large amount of data (millions of rows)
- Database performance tuning
- Monitoring of daily & nightly jobs
- Data warehousing concepts
- Dimensional data modeling
- ETL – Extract Transform & Load
- Management
Unit 6 – International Certification Exams
- Introduction to Oracle SQL (Exam code- IZ0-007)
- Oracle Program with PL/SQL (Exam code-IZ0-147)
Unit 7 -Placement Assistance
- Preparation of the best resume
- Prepare for an Interview
- Most likely questions in interviews
- How to find a right job to match your skills
- How to get your resume short listed by HR
- Powerful resume searching techniques
Hiring Companies
- Persistent
- Amdocs
- IBM
- Data Vision
- Vodafone
- Cognizant
Upcoming Batches Schedule
| 02 July | Regular | 7.30 am To 9.30 am |
| 07 July | Weekend | 10.30 am To 02.30pm |
| 16 July | Regular | 7.30 am To 9.30 am |
| 21 July | Weekend | 10.30 am To 02.30pm |
Contact – Call us at 9372005897/ 8956930899 or fill out this form, and we will be happy to contact you back.
Will See you soon in center, Happy Learning!!!
Mr. Gaurav Pagar – i joined Oracle Data Warehousing Development training at sadashiv peth, wanted to mentioned here that our faculty is very good,providing good support.having a wonderful experience, having a wonderful lab set up feeling happy.