Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle Professional

No Reviews Yet

Andhrakesari Nagar, Nellore

Course ID: 12272

Andhrakesari Nagar, Nellore

No Reviews Yet

Date and Time

Not decided yet.

Phanindra Kumar.O.V.V

Director, Technical Consultant

About Phanindra Kumar.O.V.V

I have been Taking "Technical Training" Classes at Academic and Corporate Sectors from past 17 Years
No reviews currently Be the First to Review

About the Course

It is very use full course those who are doing graduation(B.Tech),MCA and seeking for JOB

Topics Covered

Oracle
DBMS
• Introduction to Database
• Database Views
o Internal View
o Conceptual View
o External View
• Data Models
o Hierarchical Model
o Network Model
o Relational Model
o Object Oriented Relational Model
RDBMS
• Introduction to RDBMS
• Types of RDBMS
• Oracle Popularity
• Oracle Products
SQL
• Rules for Oracle Database
• Data Types in ORACLE
• Introduction to SQL
o Data Definition Language
o Data Manipulation Language
o Data Control Language
o Transaction Control Language (TCL)
• Operators
o Introduction
o Types of Operators
? Relational Operators
? Arithmetic Operators
? Logical Operators
? Special Operators
o Sorting the Records
• Constraints
o Introduction
o Types of Constraints
? Integrity Constraints
? Referential Integrity Constraints
o Column Constraints , Table Constraints
o List out the Constraints of particular table
o Adding the Constraints for already existing tables
o Disable/Enable Constraints
o Remove the Constraints
o Cascading the table Constraints
• JOINS
o Introduction
? Types of JOINS
? Equi Join
? Self Join
? Outer Join
? Non-Equi Join
• Functions
o Single Row Functions
? String Functions
? Number Functions
? Date Functions
? Conversion Functions
? Special Functions
o Group Functions
• Sub Queries
o Simple Sub Queries
? Sub Query Comparison Test
? Sub Query Membership Test
? Quantified Comparison Test
? Existence Test
o Correlated Sub Queries
• Views, Sequence, Set Operators
• SQL *Plus
PL / SQL (Programming Language for Structured Query Language)
• PL/SQL Introducxtion
o Advantages
o What is Block ?
o Data Typesin PL/SQL
? SQL Data Types
? Composite Data Types
? %type
? %rowtype
o Programming Constructions
• Cursors
o What is Cursor ?
o Types of Cursors
? Implicit Cursors
? Explicit Cursors
• Stored Procedures
o Introduction
o Types of Stored Procedures
? Procedures
? Functions
? Triggers
• Triggers
o Purpose of Triggers
o Types of Triggers
? Statement Level Triggers
? Row Level Triggers
? Trigger Events
? Trigger Parts
• Packages

o Introduction
o Package Specification
o Package Body
o Using the package in anothe PL/SQL Block
• Exception Handling
o Introduction
o Types of Exceptions
? Implicit Exceptions
? Explicit Exceptions
Advanced Concepts
• Objected Oriented Databases
• Collections
• Partitions

Who should attend

Any Graduate

Pre-requisites

Basing Knowledge in Computers

What you need to bring

Queries

Key Takeaways

Able to write any level of Complex Queries

Reviews

No reviews currently Be the First to Review

Gallery (1)

Discussions

Post your requirement and let us connect you with best possible matches for Database Training classes Post your requirement now
₹ 5,000 Enquire