All Oracle session will be covered with real time scenarios along with a real time project explanation.

Topics Covered

:::…Oracle…::: Database Introduction Data Database Database Management System Types of Databases ER-Model Accessing the Database Environments to access database Toad Sql Developer Sql Navigator Sql * Plus SQL Accessing the Databases using SQL Data types Database Objects Types of Database Objects in SQL Tables Views Types of Views Difference between Normal Views and Materialized Views Sequences Synonyms Indexes Clusters Data Dictionary Tables or Meta Data Tables Types of SQL Statements DDL DML DQL/DRL DCL TCL Dual Table SQL Operators Arithmetic Operators Comparison/Relational Operators Logical Operators SQL Special Operators Functions Single-Row Functions& Types Multi-Row Functions& Types Joins Oracle Joins ANSI Joins Sub Queries Types Of Sub Queries Advanced Sub Queries Set Operators Pseudo Columns Pseudo Columns Types of Pseudo Columns Rowid Rownum Nextval Currval Level Top-N & Bottom-N Analysis Hierarchal Queries Analytic Functions Cube Rollup Grouping Rank Dense Rank Over And more PL/SQL Difference between SQL and PL/SQL Advantages of using PL/SQL Types of PL/SQL Programs Displaying Outputs in PL/SQL Variables Usage of Variables Scope of Variables Types of Variables Using DML Statements in PL/SQL program Using DQL Statements in PL/SQL Program Non-PL/SQL Variables Conditional Statements Iterative Statements Composite Data Types Records Collections Cursors Types of Cursors Cursor Attributes Writing Cursors using Iterative Statements Parameterized Cursor Static Cursor Dynamic/Ref Cursor Pragma Types of Pragmas Pragma Exception_Init Pragma Autonomous_Transaction Pragma Serially_Reusable Pragma Restrict Reference Exceptions Types of Exceptions Using Exception_Init Difference between dbms_output.put_line and raise_application_error in Exceptions Procedures Compilation and Execution of Procedures Types of Parameters in Procedures Calling one procedure from another procedure Using Pragma Autonomous Transaction Functions Compilation and Execution of Functions Types of Parameters in Functions Difference between Procedures and Functions Packages Compilation and Execution of a Package Private Sub Program Triggers Types of Triggers Mutating Trigger Advanced PL/SQL Bulk Fetching Dynamic SQL And more

Who should attend

Anybody

Pre-requisites

Computer with net

What you need to bring

Notebook

Key Takeaways

FAQ Real Time Scenarios Mock Interviews Real time Assignments