|
Course Details |
|
|
Diploma in Data Warehouse Development : (D3)
|
This is a Job Oriented
Training Program. Candidates who join this program will undergo a training on
SQL, PL/SQL, UNIX & Shell Scripting. Data Warehouse 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 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) technologis and tools provided by Oracle.
Course Syllabus:
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 Fucntions
-
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
|
|
|
|
|
|
|
|