"Oracle Professional" is no longer available

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

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more