Oracle Training

Top Oracle Course - Best Oracle Training Institute Guntur

Oracle is a Data Base 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.

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)

  • 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

Oracle (PL/SQL)

  • 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
  • About cursors in PL/SQL
  • Explicit cursors
  • For loop cursor
  • Cursor parameters
  • For update clause
  • Where current of clause
Implicit cursors
  • System defined exceptions

User defined exceptions

  • Introduction to subprograms
Difference between anonymous & named blocks
  • Creatng procedures
  • Working with IN,OUT, INOUT parameters
  • Procedures with cursors
  • Procedures returning records
  • Difference b/w procedures and functions
  • Inline functions
  • Introduction to packages
  • Package specification and package body
Overloading package members
Introduction to triggers:
  • DML triggers
  • DDL triggers
  • Db auditing using triggers
  • DB level triggers

Course Details

Course Duration

45 Days

Batches Timings

8:00 AM - 8:00 PM Each Session 1 Hour New Batches Starts on april 2019

Certifications

Valid certification on successful completion of course from Institute.

Contact Us

Send us a message

Nipuna Technologies offers best and quality training in Software Courses, Job Oriented Courses.

Find us at the office

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

Give us a ring

Nipuna Technologies
+91-7997927111
Mon - sat, 8:00 am - 10:00 pm

Mail Us

info@nipunatechnologies.com