100% Practical Learning
Special Batch for Working Professionals
Resume & Interviews Preparation Support
This course helps students to understand Powerful PL/SQL programming language. In this class students can learn how to create PL/SQL blocks. Student will learn many oracle database objects like Stored Program Units like Procedure, Functions, Packages, and Triggers. Students will learn Exception Handling in Oracle. How to write Cursor and use of cursor attributes.
Our professional trainer having more than 16+ years of notable contribution in Database Management and Data Warehousing in the BFSI, Healthcare Insurance and Port and Cargo sectors and Supply and Chain domain.
Trainer having vast experience in Data/DWH/ETL Architect and Data Analytics. Trainer is well versed in End-to-End solution provider for OLTP/OLAP/ETL process with comprehensive experience in Technologies like Oracle SQL, PL/SQL, Performance Tuning of Large Database, UNIX, Unix Shell Scripting, ETL Tool Informatica Power Center 9x, Pentaho, Mongo Db, MDM and Business Objects.
Trainer is Proficient in application tuning in handling large volume of data and optimized many huge databases.
Trainer has also Experience of using Cloud AWS and Agile methodologies for execution of various projects.
This document shows the students regarding all the topics covered in Oracle classes. Student can learn oracle from basic to advance. Oracle Classes will also help the students how they can prepare themselves as per the industrial demand.
What are the measurement you have taken when your mapping/workflow running slow.
Which type of cache we should use Lookup transformation
How can load multiple files into one target table using only one mapping
There are many such questions and their answers will be discussed during the course so that candidate can grab job easily.
Informatica is an ETL tool , which extracts data from different sources such as oracle,files,SAP etc , TRANSFORM the data such as removing duplicate values or removing null or extra character and load the data in oracle, flat files, Teradata etc. Informatica is one of the famous tool, which is used across the IT industry in the data warehouse, data analytics and data extraction projects.
The Duration of this course is 12 Months
#56,Jyothi Nivas College Road,