Top Oracle Course – Best Oracle Training Institute Guntur

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. Oracle corporation integrates both business and technology. It releases Oracle updated versions now and then with add on features along existing features.

For Free Counselling

Best Oracle Training Institute Guntur

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.

Oracle (SQL)

Introduction
·         Definition of Database
·         Definition of DBMS
·         Features of RDBMS
SQL
·         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
DML Commands
·         Copying Data from one table to another
·         INSERT command
·         UPDATE command
·         DELETE command
DDL commands
·         Creating Table from another Table
·         ALTER command
·         DROP command
·         TRUNCATE command
·         RENAME command
·         Difference between DELETE and TRUNCATE
Integrity Constraints
·         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
Built-in Functions
·         Single Row functions
·         String functions
·         Date functions
·         Mathematical functions
·         Conversion functions
·         Special functions
·         Analytic al functions
·         Multi Row functions
Data Aggregation
·         Group by clause
·         Having clause
Importance of Join Operation
·         Types of Joins
·         Equi Join
·         Non-Equi Join
·         Self Join
·         Outer Join
·         Left Outer
·         Right Outer
·         Full Outer
Cross join
SET operators
  • UNION , UNION ALL, INTERSECT, MINUS

Psuedo columns :

  • ROWID, ROWNUM
Subqueries
·         Importance of Subqueries
·         Types of Subqueries
·         Single row subqueries
·         Multi row subqueries
·         Nested queries
Multi column subqueries
Database Transactions (DCL)
commit command
rollback command
savepoint command
Database Security
·         System privileges and Object privileges
·         Granting and revoking privileges
·         Creating users and roles
Schema objects :
·         Views
·         Synonyms
·         Indexes
·         Clusters
·         Materialized views
·         Sequences
Types
Oracle (PL/SQL)

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

Location

Sai Kidambi Towers Road,Above Vijaya Digitals, Arundalpet, Guntur, Andhra Pradesh 522002

Email: info@nipunatechnologies.com

Contact: +91-7997927111

Call Now ButtonCall for Information