Global Techsys Learning | Oracle Training

Untitled Document

Oracle Training in Pune with Placement

Oracle Course Feature

Practical and industry oriented training with live projects

100% job assurance

Best course material for future use

Real time case studies to practice

Mock interview sessions

Lifetime assistance for job

Who can take Oracle Training ?

Freshers

BE/Bsc Candidates

Any Graduate

Any Post-Graduate

Average Salary of Oracle Training in India

3 LPA - 15 LPA

Course Content

INTRODUCTION

Introduction to Database, DBMS, RDBMS
Disadvantages of File Management System
Database Design using ER Model
Database Design using Normalization

SQL

Introduction to SQL
Sublanguages of SQL
Datatypes in SQL
Creating Tables and Inserting Data into Tables
Data Retrieval using SELECT Command
Writing WHERE Conditions using Various Operators
Built-in functions in Oracle
Group By Clause
Joins
Set Operators
Sub Queries
DB Transactions
DB Security
Working with Views
Working with Synonyms
Working with Sequences
Integrity Constraints
Working with Indexes
Working with Clusters
Working with Materialized Views
Working with Types
Advanced Features

PL/SQL

Introduction to PL/SQL
Basic Progamming in PL/SQL
Writing Programs using Conditional Statements
Writing Programs using Loops
Cursors
Collections
Exception Handling
Procedures
Functions
Packages
Triggers
UTL_FILE package
Working with LOBs
Dynamic SQL
Advanced Features

Happy Faces from Our Recent Batch

Contact Global Techsys For More Info : 8308998128, 8308405445

Finance Partner for Every Course

No Cost EMI Starting at Rs. 6000/- Per Month

Untitled Document

Copyright © Powered By Global Techsys Learning