Oracle

Oracle DB Certificate Training

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.

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

reviewStudentImg

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

reviewStudentImg


reviewStudentImg

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

reviewStudentImg

20th
June

07:00 pm - 09:00 pm

Mon - Fri ( Fast Track )
Assignment

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

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.

LifeTime

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.

Certificate

Get-Certified

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

Related Courses

Java
Hadoop
Python