Signup as a Tutor

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

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

No Reviews Yet

Greater Noida, Noida

Course ID: 6889

Greater Noida, Noida

Students Interested 1 (Seats Left 0)

₹ 4,000

No Reviews Yet

Date and Time

Not decided yet.

Pankaj Arora picture
Pankaj Arora

MCA

10 Years of Experience

About Pankaj Arora

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.
No reviews currently Be the First to Review

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.

Reviews

No reviews currently Be the First to Review

Students Interested 1 (Seats Left 0)

₹ 4,000

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now
₹ 4,000 Enquire

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