Top Oracle Course

Oracle is a Database which stores any data, which is considered a unit. It is developed by Oracle Corporation using SQL functionality.PL/SQL is Procedural Language for SQL and Oracle relational database, It is an extension to Oracle SQL which stores ten times more data.

Best Oracle Training Institute Guntur

Oracle corporation integrates both business and technology. It releases Oracle updated versions now and then with add on features along existing features.

PL/SQL includes procedural language elements such as conditions and loops. It will have  declaration of constants and variables, procedures and functions, types and variables of those types, and triggers

One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.

Our Course Curriculum

·         Definition of Database
·         Definition of DBMS
·         Features of RDBMS
·         Introduction to SQL
·         Datatypes in Oracle
·         Schemas and Schema Objects
·         About Table Creation
·         Inserting Data
·         Data Retrieval:
·         SELECT statement
·         Column alias, Table alias
·         Clauses in SQL
·         Data filtering using WHERE clause
·         Copying Data from one table to another
·         INSERT command
·         UPDATE command
·         DELETE command
·         Creating Table from another Table
·         ALTER command
·         DROP command
·         TRUNCATE command
·         RENAME command
·         Difference between DELETE and TRUNCATE
·         Types of Integrity Constraints
·         Declaring Constraints
·         Column level
·         Table level
·         Alter Level Adding Constraints to an Existing table
·         Enabling & Disabling Constraints
·         Getting information about Constraints
·         Single Row functions
·         String functions
·         Date functions
·         Mathematical functions
·         Conversion functions
·         Special functions
·         Analytic al functions
·         Multi Row functions
·         Group by clause
·         Having clause
·         Types of Joins
·         Equi Join
·         Non-Equi Join
·         Self Join
·         Outer Join
·         Left Outer
·         Right Outer
·         Full Outer
Cross join
  • UNION , UNION ALL, INTERSECT, MINUS

Psuedo columns :

  • ROWID, ROWNUM
·         Importance of Subqueries
·         Types of Subqueries
·         Single row subqueries
·         Multi row subqueries
·         Nested queries
Multi column subqueries
  • commit command
  • rollback command
  • savepoint command
·         System privileges and Object privileges
·         Granting and revoking privileges
·         Creating users and roles
Schema objects :
·         Views
·         Synonyms
·         Indexes
·         Clusters
·         Materialized views
·         Sequences
Types

Introduction

·         Introduction to PL/SQL
·         Advantages of PL/SQL
·         PL/SQL architecture
·         Datatypes in PL/SQL
·         PL/SQL program structure
·         Simple PL/SQL programs
·         Embedding SQL statements in PL/SQL
·         Conditional statements
Loops

Cursors

·         About cursors in PL/SQL
·         Explicit cursors
·         For loop cursor
·         Cursor parameters
·         For update clause
·         Where current of clause
Implicit cursors

Exception Handling

  • System defined exceptions

User defined exceptions

 Subprograms

·         Introduction to subprograms
Difference between anonymous & named blocks

 Stored procedures

·         Creatng procedures
·         Working with IN,OUT, INOUT parameters
·         Procedures with cursors
·         Procedures returning records

 Functions

·         Difference b/w procedures and functions
·         Inline functions

Packages

·         Introduction to packages
·         Package specification and package body
Overloading package members

Triggers

Introduction to triggers:
·         DML triggers
·         DDL triggers
·         Db auditing using triggers
·         DB level triggers
Call Now ButtonCall for Information