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

  • 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