Six Weeks Oracle Summer Training in Kanpur
Oracle Training Course Overview
Introduction to DBMS:
Advantage of RDBMS
Sub Language Commands:
Introduction to SQL Database Object
Built in Functions
Grouping the Result of a Query
Working with Integrity Constraints
Working with different types of integrity Constraints
REF constraint
Querying Multiple Tables (Joins)
Working with Sub Queries
Working with DCL, TCL Commands
Maintaining Database Objects
VIEWS in Oracle
Working with Sequences
Working with Synonyms
Working with Index and Clusters
Creating Cluster Tables, Implementing Locks, working with roles
Pseudo Columns in Oracle
Data Partitions & Parallel Process
Locks
SQL * Loader
PL-SQL (Procedure Language – SQL)
Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS
SQL within PL/SQL
Composite Data types (Complete)
Cursor Management in PL/SQL
Implicit Cursors
Explicit Cursors
Cursor Attributes
Cursor with Parameters
Cursors with LOOPs Nested Cursors
Cursors with Sub Queries
Ref. Cursors
Record and PL/SQL Table Types
Advanced PL/SQL

EXCEPTIONS in PL/SQL

Database Triggers in PL/SQL

File Input/Output

Implementing Object Technology

Using LOBS

Using Collections

Oracle Database Architecture

Advanced Features

DBA CONCEPTS


Offered Courses

FOUNDATION COURSES
PROGRAMMING HUB
BETUE DOAT
6 MONTH JAVA TRAINING
6 MONTH .NET TRAINING
6 MONTH PHP TRAINING
6 WEEK PHP TRAINING
6 WEEK ADVANCE JAVA TRAINING
6 WEEK BIG DATA HADOOP TRAINING
6 WEEK CORE JAVA TRAINING
ANDROID TRAINING
ASP .NET TRAINING
AUTOCAD TRAINING
C_language TRAINING
C# TRAINING
C++ TRAINING
DataStructure TRAINING
DOT NET SUMMER TRAINING
EMBEDDED TRAINING
HTML5 CSS3 TRAINING
INDUSTRIAL TRAINING
JAVA DIPLOMA TRAINING
JQUERY TRAINING
MATLAB TRAINING
.NET DIPLOMA TRAINING
.NET MVC TRAINING
ORACLE TRAINING
PHP DIPLOMA TRAINING
PYTHON TRAINING
Robotics TRAINING
SQL SERVER TRAINING
WCF TRAINING
WEB SERVICES TRAINING
WORDPRESS TRAINING
WPF TRAINING



B T P S
TRAINING | PLACEMENT | WEBSITE DEVELOPMENT
AN ISO 9001:2008 CERTIFIED COMPANY

Head Office

117/62 -[O] Block,Geeta Nagar,Crossing No. 9
Phone:9044900033,9198147777
email : btps.kanpur@gmail.com
Web URL : www.btps.co.in
© 2017 All rights Reserved | Design by BTPS TEAM