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.