SSIS - Oracle

Oracle DB Certificate Training

Courses Details

Every application, small and enterprise scale alike, requires data management at some level, which is where this course comes in.This course is the programmer's course in Oracle Database, that teaches you SQL and PL/SQL. Spreading across 50 hours, it trains you extensively in SQL and PL/SQL - the two most essential components required in making you an Oracle Database programmer.

Course Objectives

By the end of the course, you will be able to

Understand Data processing models
Differentiate RDBMS from HDBMS and NDBMS
Create/modify/delete table structures
Insert/update/delete data from oracle tables
Use different oracle built-in functions
Retrieve data from oracle tables
Filter and order data
Perform data grouping
Join data from multiple tables
Write complex queries using subqueries
Write complex queries using WITH
Perform Top-N analysis
Implement hierarchical queries
Flashback deleted tables
Implement data integrity using constraints
Manage transactions
Control data access using grant and revoke
Work with views
Fine tune data retrieval with indexes and clusters
Understand the structure of a pl/sql block
Write anonymous blocks as well as named blocks
Use cursors within PL/SQL blocks
Write stored functions
Write stored procedures
Differentiate parameter modes
Build custom packages
Implement complex triggers
Work with objects
Work with object tables
Work with varrays and nested tables

Pre-requisites

This course is open to anyone who is interested in taking up Database programming , though there are no explicit pre-requisites, knowledge of a programming language will prove helpful.

Module 1

Introduction to DBMS

Understand the term DBMS
Types of Databases
Types of Database Management Systems
Types of Data Processing Models
Why Oracle DB
Features of Oracle DB

Module 3

SQL - Part 1

Oracle Datatypes
Create a Table
Alter a Table
Drop a Table
Flashback a Table
Insert data into a Table
Update data in a Table
Delete data from a table

Module 5

SQL- Part 3

Group Data
Rollup VS Cube
Join Tables
Sub queries
Top-N analysis
Hierarchical queries

Module 7

PL/SQL - Part 1

Drawbacks of SQL
Introduction to PL/SQL
PL/SQL Architecture
Anonymous Blocks Vs Stored Blocks
Anatomy of a PL/SQL Block
Datatypes in PL/SQL
Working with Records
Control Structures

Module 9

Objects in Oracle

Object Types
Object Tables
Object Inheritance
Object Views
VArrays
Nested Tables

Module 2

Introduction to Oracle

History Of Oracle
Oracle Editions
Oracle Versions
Setting up Oracle DB

Module 4

SQL - Part 2

Understand the Select Command
Selection Vs Projection
Understand NULL in Oracle
Order data
Implement Multi-table Insert
Understand DUAL Table
Oracle Built-in Functions

Module 6

SQL - Part 4

Constraints
Views
Sequences
Security
Transaction Management

Module 8

PL/SQL - Part 2

Exception Handling
Cursors
Static Vs Dynamic Cursors
Stored Procedures
Stored Functions
Packages
Parameter Modes
DB Triggers

Can I attend a Demo Session before enrolling myself?

Yes, every student can attend upto 3 classes,before enrolling, to get an insight of the quality of the subject.

What if I miss a class?

You can always attend that class in any other batch as per your convenience, provided the reason for missing the class is genuine.

Do we have a single instructor or multiple instructors per course?

A single instructor will take you through the entire course, avoiding the inconvenience of having to adjust to the frequencies of multiple instructors.

Can I switch my batch?

Yes, however please do remember that we limit the number of students per batch,so that, the instructor ,gets to concentrate on every student equally. Should a batch you request,have vacancies, you will be accommodated in it.

Do I get Placement Assistance?

We take utmost care in designing our curriculum.It is so meticulously designed, that it takes care of every aspect that goes into making you a world class computer professional. Our students are groomed in such a manner that they won't have a problem expressing themselves technically, which should help them sail through interviews. Please do understand that we are into training and not placements.

Will I be able to give the certification exam?

Training at SSIS, will not only make you industry ready, but will also equip you with all the necessary subject and skills to give the corresponding certification exam.

Can I repeat a course/topic ?

Once you enroll with us, you gain a life time access.Should you, come across the need to repeat a course/topic at any later point in time, all that you will have to do is, get in touch with us and schedule a batch as per availability, at no extra cost.

Do I get to work on a project at the end of the course?

Yes,Any course is incomplete without a project.We provide a range of real world case studies and encourage every student to implement one of those , as a part of the course-end project.

What if I need assistance?

We have a huge library, where you can always quench your thirst for knowledge, in case you need more than the assistance offered on the floor, during work hours.

SSIS.. In one word we can define it as home of modern software technologies..This is the only place in vizag where one can learn best courses like Hadoop, Java , Oracle etc.. If one wants to make IT as a career I suggest this is the best institute to excel your skills. After getting trained here, one will definitely say "Programming is not choice, It is Life".
Baratam. Yasaswi
Associate Software Engineer
Tech Mahindra

It is beyond the training. Here I received the proper expert advice , it is because of SSIS that I became more confident. The training is focused more on makes us fit for the real world. Here I went through the best training ever.
Potta. Swati
Associate Systems Engineer
IBM India

Every block of stone has a statue inside it, and it is the task of the sculptor to discover it, similarly SSIS made my professional life unique, Thank you SSIS.
Bandi. Kalyani
Programmer Analyst
Cognizant Technology Solutions(CTS)

I had learned Oracle and Java in Sai Sri Info solutions (SSIS) institute. I'm an Electrical and Electronics student I know only C programming before joining SSIS but now due to Sir's explanation I learnt Java and Oracle.Sir explained each and every topic clearly.
Grandhi. Supriya
Associate Systems Engineer
HCL Technologies

20^th
June

07:00 pm - 09:00 pm

Mon - Fri ( Fast Track )

Assignments

Assignments based on real world case studies, are provided,at the end of every concept, to enhance your practical implementation of what you learn in the class.

Project

Any course is incomplete without a project.We provide a range of real world case studies and encourage every student to implement one of those , as part of the course-end project.

Life-Time Access

Once you enroll with us for a course, you get a life time access to that course, which entitles you for a free repetition of a concept or a part of the course or the entire course itself.

Get-Certified

We certify you,based on the assignments submitted and the project work done at the end of the course.

Related Courses