Follow Us:

Diploma in Oracle Database Development Training in Chennai

Course Duration

40 HOURS Sign in with Facebook Sign in with Facebook

Course Contents

Diploma in Oracle Database Development
    Introduction to Oracle Database
    • Intro to RDBMS
    • Structured Query Language
    • Use the Client Tools- SQL*Plus,SQL Developer
    • Relational Structures
      • Creating, renaming and deleting Databases
      • Creating,Altering and Deleting Tables
      • Adding, Modifying and Removing Rows
      • Table Constraints
    Data Retrieval Using SQL Commands
    • Using SQL SELECT statement
      • Syntax of the SELECT Statement
      • Performing Single Table SELECT Statements
      • Selecting all Columns and Rows from a Table
      • Performing SELECT for more than one Table
      • Using Arithmetic Operators
      • Defining NULL values
    • Using SQL WHERE Clause
    • Using the ORDER BY Clause
    • JOINS and its types
    Using Functions
    • Defining a Function
    • Types of Functions
    • Use Character, Number and Date Functions
    • Conversion Functions and Conditional Expression
    • Aggregate Functions
    • Grouping Rows using GROUP BY Clause and HAVING Clause
    • Storing and Processing Dates and Times
    SQL *Plus
    • View and Edit SQL statements
    • Formatting the columns and Clearing
    • Storing and Retrieving files
    • Running files
    • Using Temporary and Defined Variables
    • Creation of simple reports in a Script
    Using Subqueries
    • Define Subqueries
    • Types of Subqueries
      • Singe Row Subqueries
      • Multiple Row Subqueries
      • Correlated Subqueries
      • Writing Singe Row Subqueries
      • Writing Multiple Row Subqueries
      • Writing Correlated Row Subqueries
      • Writing Correlated Row Subqueries
      • Writing Nested Subqueries
      • Writing DELETE and UPDATE Statements in Subquery
    • Advanced Queries Using the Set Operators
      • UNION Operator
      • UNION ALLOperator
      • MINUS Operator
      • INTERSECT Operator
      • Hierarchial Queries
    Create and Manage Tables using DDL Statements
    • Creating Table
    • Alter and Drop a Table
    • Truncate and Drop a Table
    • Retrieving data on a Table
    Manipulating Data
    • Data Manipulation Language (DML) Statement
      • INSERT
      • DELETE
      • UPDATE
      • MERGE
      • TRUNCATE
    • Insert Rows into a Table
    • Update Rows in a Table
    • Delete Rows from a Table
    • Merging Rows using MERGE
    • Removing Rows with TRUNCATE
    Database Transactions
    • Committing a Transaction
    • Rolling back a Transaction
    • Define ACID Transaction Properties
    • Locking a Transaction
    • SERIALIZABLE Transaction
    Views ,Sequences and Indexes
    • Create Views
    • Retrieve Data from Views
    • Create Sequences
    • Using Sequences
    • Create Index
    • Modify and Drop Index
    • Using Indexes
    Database Security
    • Database Users and Schemas
    • Privileges to a User
    • Roles to a User
    Programming in PL/SQL
    • Introduction to Oracle Data Types and Variables
    • Loops
    • Cursors
    • Exceptions
    • Triggers
      • Overview of Triggers
      • Parts of a Trigger
      • Types of Trigger
      • Creating, Firing and Dropping a Trigger
      • Trigger Execution
    • Procedures and Functions
      • Creating a Procedure and Function
      • Calling a Procedure and Function
      • Getting Data on a Procedure and Function
      • Dropping a Procedure and Function
    • Packages
      • Package Creation
      • Create Package Body
      • Use of Functions and Procedures within a Package
    • Database Objects
    • Define Collections
    • Multilevel Collections
    • Using Varray Types
    • Using of Nested Tables
    • Collection Methods
    • Manipulating Arrays and Nested Tables in PL SQL
    • Collection Enhancements
    Running SQL
    SQL Tuning
Register Now

You will Learn How To :

On completion of this course You will know
  • Deal with the DBMS and RDBMS related SQL Queries.
  • Data Retrieval Using SQL Commands
  • How to using a function
  • Using Subqueries
  • Create and Manage Tables using DDL Statements
  • Data Manipulation
  • Database Transactions
  • Views ,Sequences and Indexes
  • Programming in PL/SQL
  • Course Benefits :

    On completion of Diploma in Oracle Database Development it will lead to the job role as follows:
  • Database Administrator
  • Support Analyst
  • Database Developer
  • Senior Database Administrator
  • Senior Database Developer
  • Register Now

    Please use the form below to make your career excellent.