Oracle

Duration of this course : 27 - 30 hrs

Learning Objectives : Our Oracle courses are perfectly designed to train you to meet the growing demand for Oracle professionals in the industry.

Who should Join :Students of B.Tech / MCA / B.Sc. / BCA

Course fees ( in Rs ) : 2500/-

Venue : RND Consultancy Services, Serampore, Chatra, Hooghly, WB. Phone : +919674867457 / +919674948998

Our Oracle courses are perfectly designed to train you to meet the growing demand for Oracle professionals in the industry.

Computer Fundamentals, Windows Operating System

Basic knowledge of database can be much more useful

Critical Database Concepts

Introduction to SQL Database Object

Oracle Pre Defined Datatypes

DDL Commands

Create, Alter (add, modify, rename, drop)Columns, Rename, truncate, drop

DML-Insert, update, delete

Level Name Integrity

Foreign Keys

Where Does SQL Fit In?

Creating, Dropping and Altering Tables and Views

Users, Roles, and Privileges

Creating a User

Password Management

Three Standard Roles

Format for the Grant Command

Revoking Privileges

Importance of Data Integrity

Support of Integrity Constraints for Relating Table in RDBMS

NOT NULL constraint

UNIQUE constraint

PRIMARY KEY constraint

FOREIGN KEY constraint

CHECK constraint

Equi Join/Inner Join/Simple Join

Cartesian Join

Outer Joins

Self Join

Working with Sub Queries

Working with DCL, TCL Commands

VIEWS in Oracle

Pseudo Columns in Oracle

PL-SQL (Procedure Language – SQL)

Introduction to Programming Languages

Introduction to PL/SQL

The Advantages of PL/SQL

PL/SQL Architecture

PL/SQL Datatypes

Variable and Constants

Using Built_in Functions

Conditional and Unconditional Statements

Simple if, if… else, nested if..else, if..else Ladder

Selection Case, Simple Case, GOTO Label and EXIT

Iterations in PL/SQL

Simple LOOP, WHILE LOOP, FOR LOOP and NESTED LOOPS

SQL within PL/SQL


FIND US

Serampore, Chatra, Hooghly, West Bengal, India.
Phone: +919674867457 / +919674948998

E-mail: rndconsultancyservice@gmail.com



FOLLOW US

Industrial Training for Engineering Students 0n Java, Android, Web and SEO Facebook
Industrial Training for Engineering Students 0n Java, Android, Web and SEO Twitter
Industrial Training for Engineering Students 0n Java, Android, Web and SEO LinkedIn
Industrial Training for Engineering Students 0n Java, Android, Web and SEO Google+
Industrial Training for Engineering Students 0n Java, Android, Web and SEO Flicker
Industrial Training for Engineering Students 0n Java, Android, Web and SEO Youtube
Industrial Training for Engineering Students 0n Java, Android, Web and SEO Pinterest
Industrial Training for Engineering Students 0n Java, Android, Web and SEO Instagram

WRITE US A LETTER

Industrial Training for Engineering Students 0n Java, Android, Web and SEO