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
Yes, every student can attend upto 3 classes,before enrolling, to get an insight of the quality of the subject.
You can always attend that class in any other batch as per your convenience, provided the reason for missing the class is genuine.
A single instructor will take you through the entire course, avoiding the inconvenience of having to adjust to the frequencies of multiple instructors.
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.
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.
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.
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.
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.
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".
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.
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.
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.
07:00 pm - 09:00 pm
Mon - Fri ( Fast Track )