Signup as a Tutor

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

Enquire

Submit your enquiry for Expert in Oracle 10/11g,SQL,Pl/SQL

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Pankaj

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Expert in Oracle 10/11g,SQL,Pl/SQL

Greater Noida, Noida

4,000

No Reviews Yet
1 Interested

About the Course


Class will be very intractive and clear all the doubts regarding Oracle and Database.

Topics Covered

INTRODUCTION OF ORACLE
LEVEL 'A'
ORACLE BASICS OVERVIEW
There are many basic topics which help the students regarding Oracle Database. These
topics will cover as per industry standards. Some of the important topics are as follows:-

• Different type of Data type in Oracle
• Different Type of Statements in oracle (DDL, DML, DCL etc)
• Primary Key, Foreign Key, Unique Key in Oracle
• Different type of constraint in Oracle
• Different type of joins ( Like Natural, Outer, Self Joins) in Oracle
• Group Functions in Oracle like SUM, MAX, and MIN etc.
• Use of DECODE and CASE Function in Oracle
• Loops in Oracle
• PL/SQL Block
• Control Flow in PL/SQL Block
• Different types of triggers in Oracle, Use of Triggers in Oracle
• Oracle Procedure/ Functions and Packages
• Exception Handling in Oracle, User defined Exceptions in Oracle, Use of SQLCODE and SQLERRM, Predefined Exceptions in Oracle
• Use of RAISE_APPLICATION_ERROR in Oracle


ORACLE ADVANCED TOPICS
There are many advanced topics in Oracle. These classes will cover how to use the
advance features of the oracle. Some of the topics are as follows:-

• Creating Users/ Schema in Oracle
• Different type of Views in Oracle
• Sequence in Oracle
• Sub Queries in Oracle
• Autonomous Procedures/ Functions in Oracle
• EXCEPTION_INIT Pragma in Oracle
• RISTRICT_REFERENCES in Oracle
• SERIALY_REUSABLE Pragma in Oracle
• BULK_COLLECT in Oracle
• FORALL Statement in Oracle
• Flashback Features in Oracle
• Different Types of Locks in Oracle
• Analytical Functions (RANK, DENSE_RANK, ROW_NUMBER etc) in Oracle
• Types of Cursors in Oracle Explicit/ Implicit Cursors, Parameterized and Ref Cursors
• Use of DB Link in Oracle
• SQL Loader in Oracle
• Different Types of Collection (VARRY, INDEX_BU_BINARY_INTEGER) in Oracle
• Auditing in Oracle
• Dynamic SQL in Oracle

ORACLE DICTIONARY DETAILS
There are many oracle in build views which stored all the objects created by us. These all the views store the information. Types of dictionary views are as:-
a. ALL
b. DBA
c. USER
Some of the oracle dictionary views are as follows:-
• USER_CONSTRAINTS
• USER_TABLES
• USER_INDEXES
• USER_OBJECTS
• USER_SEQUENCES
• USER_TRIGGERS
• USER_VIEWS
• USER_SOURCE
• USER_TYPES
• USER_SYNONYMS
• USER_TAB_COLUMNS
• USER_AB_COMMENTS
• USER_COL_COMMENTS
• USER_IND_COLUMNS
• DBA_TABLES
• DBA_TAB_PARTITIONS
• DBA_TABLESPACE
• DBA_PROCEDURES
• ALL_ERRORS
• ALL_SOURCE_TABLES

ORACLE SUPPLIED PACKAGES
Oracle provides us many in build packages which give us freedom to do different type of activities in a very simple manner. Some of these oracle supplied packages are as:-

• DBMS_OUTPUT
• DBMS_JOB
• DBMS_UTILITY
• DBMS_SQL
• DBMS_MVIEW
• DBMS_FGA
• DBMS_STANDARD

Performance related issues in Oracle
Introduction of Oracle Tuning
Creation of Indexes in Oracle
Types of Indexes
Use of Indexes in Oracle
How to write best query
Dos and DON’TS in Oracle

PRACTICAL EXPERIENCE REGARDING INDUSTRIES STANDARD
• Where should we use RANK and DENSE_RANK Analytical Function in Oracle?
• Use of NOCOPY Clause in Oracle
• PIVOT Query in Oracle
• What is DUAL Table in Oracle?
• Delete duplicate rows in oracle Table
• Query to find highest salary in a Organization
• Mutating Triggers in Oracle
• MERGE Command in Oracle
• Use of Materialized views in oracle
• Overloading in Oracle
• Difference in between Procedure, Functions and Package
• Difference in between NUMBER, INTEGER, PLS_INTEGER, BINNARY_INTEGER in Oracle
• Difference between COUNT(1) and COUNT(*) in Oracle
• Difference between UNION and UNION ALL
• Difference between IN and EXISTS
• Difference between NOT IN and NOT EXISTS

Who should attend

Any Graduate/Post Graduate, BTech/MCA Fresher who just started his/her job. Candidate should willing to learn Database concepts.

Pre-requisites

Candidate should willing to learn Database concepts.

What you need to bring

Enthusiasm to learn Database concepts.

Key Takeaways

Become database expert.
Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 1 of 1
S

Sumit 17/10/2013

HI i am looking for pl/sql and unix online training. Unable to send you message somehow. Plz contact me with your unix syllabus

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer

Pankaj Arora picture
I am having more than 10 years of IT experience in technologies like Oracle, SQL, PL/SQL, Oracle Performance tunning, Oracle Forms and Reports 6i, ETL tool Informatica, TOAD.
Seats Left-

Students Interested 1

Course Id: 6889