ORACLE 12C DB

Description :  Oracle Database is the software which tells us to store the data in most secure and organized manner. Database comprises of SQL- which is a querying language to interact with the Database through the Application or back-end as well. PL/SQL is the programming language used to apply the programmatical interactions to the database objects through front-end applications or back-end as well.It is the most preferred mode of interacting with the database.

Prerequisite :  Person with basic programming knowledge in any language like C.

SQL

Session 1: Introduction

Session 2: Oracle Environment

Session 3: SQL Commands - Basics

Session 4: SQL Commands contd..

Session 5: Simple SELECT

Session 6: SQL Functions

Session 7: SQL Functions Contd..

Session 8: Normalization

Session 9: Normalization Contd..

Session 10: Constraints

Session 11: Constraints contd..

Session 12: Constraints contd..

Session 13: Privileges & TCS

Session 14: Locks

Session 15: SubQueries

Session 16: Co-related Subqueries

Session 17: Joins

Session 18: Joins Contd..

Session 19: Inline Queries

Session 20: Misc Queries

Session 21: Views

Session 22: Synonyms,Indexes & Sequences

Session 23: Sql* Plus Report Writing

PL /SQL

Session 24: Introduction

Session 25: PL/SQL Language

Session 26: SQL in PL/SQL

Session 27: Exceptions

Session 28: Exceptions Contd..

Session 29: Stored Procedures

Session 30: Packages

Session 31: Cursors

Session 32: Cursors Contd

Session 33: Cursors Contd..

Session 34: Triggers

Session 35: Triggers Contd..

Session 36: Native SQL & LOBS

Session 37: Types & Objects

Session 38: Collections

Session 39: Collections contd..

Session 40: Export & Import