ATLANTA COMPUTER INSTITUTE
NEAR COFFEE HOUSE and BANK OF BARODA, OPPOSITE TITAN EYE, WHC ROAD, DHARAMPETH,
NAGPUR -10, MAHARASHTRA, INDIA.
Mobile: 9595 321479
Mobile: 9970 198839
Oracle Classes in Nagpur - Oracle Training in Nagpur - Oracle Institute in Nagpur - Oracle Courses in Nagpur
Oracle is world's largest used Database. Oracle is the product of Oracle Corporation. Oracle is the market of database for many decades. It works on mostly all operating systems. Most of the world's top companies use Oracle . Oracle is used to store information about company's staff, salary, stocks, and all related information. Any of person going for computer field should have knowledge of database preferably Oracle. Oracle Classes and Training is conducted by expert teaching staff . Oracle Batches starts on First and Third Mondays of every month at our Nagpur Centers. Oracle Course covers the following syllabus.
- CONCEPTS of Oracle - Introduction to the database management system, Types of Database, The Relational Database Management System, Normalization, Entity Relationship Diagram, Client / Server Architecture Model
- SQL & SQL PLUS in Oracle -
Introduction to SQL , Classification of
SQL Statement ( DDL, DML, DCL
), SQL Operator and Functions, The SQL
Select Statement and Types of Queries,
Different Set of Operators and Joins,
What is SQL Plus, Creating Reports using SQL Plus
- PL / SQL in Oracle -
Introduction to PL/ SQL, The PL/SQL
Block Construct, Using Variables and SQL statement in the PL/SQL BLOCK , PL/SQL Constructs like If, Elseif, Elseif, Else, Endif, Loop... End Loop , While Loop etc, Working with Cursor, Creating and Using Shared Functions, Procedures and Packages, Writing Event Driven Database Level Triggers, Using Oracle Packages
- INTRODUCTION TO OBJECT ORIENTED DBMS in Oracle
- NEW DATATYPES in Oracle - Lob's ( Large Objects), Type of Lob's, Creating and Managing Tables using Lob's, Using DBMS_LOB, Packing to work with Lob's
- ORACLE OBJECT OPTION The Objects Data Type, Create Type Statement, Creating Tables Based on Object Data Types, Using SQL AND PL/SQL Statement to work with object Table.
- COMPOSITE DATA TYPES in Oracle
- OBJECT VIEWS in Oracle