Welcome to iTask Technologies
Contact Us
logo
Menu

Oracle Training

Courses Images

Oracle TrainingDetails

Course Basic Information

  • Normal Track : 15 Days (2 Hours Daily)
  • Fast Track : 10 Days (3 Hours Daily)
  • Location : Campus / Online
APPLY NOW

About Oracle Training

ORACLE training teaches developers all the PL-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server. Gives idea about writing Queries & Sub-queries, working with Joins, etc.

Course Syllabus

Introduction to JAVA

  • Learn Database models
  • Overview of PL / SQL Studio and PL-SQL language
  • Master writing simple and complex queries that retrieve data from the database
  • Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
  • Insert, update, and delete data
  • Retrieve data from tables
  • Joins
  • Sub-queries
  • Working with Data Types
  • Procedure and Functions
  • Understand the different Views
  • Working with Triggers
  • Design a database
  • Maintain databases, tables, and sequences with SQL statements
  • Create and manage views
  • Ensure the integrity of multiple, related database updates by using transactions
  • Retrieve data using cursors
  • Manage binary data using BLOBs
  • Definition of Database
  • Definition of DBMS
  • FMS
  • Advantage of DBMS over FMS
  • DB Life Cycle
  • ER MODEL
  • NORMALIZATION
  • Hierarchical
  • Network
  • Relational
  • Object Relational
  • Object Oriented
  • CODD rules
  • Client / server Architecture
  • Oracle versions
  • Oracle Installation
  • Oracle architecture
  • Introduction to SQL
  • SQL standards
  • SQL sublanguages
  • About SQL*PLUS
  • Difference between SQL and SQL*PLUS
  • Datatypes in Oracle
  • Operators in Oracle
  • Schemas and Schema Objects
  • About Table Creation
  • Inserting Data
  • SELECT statement
  • Column alias, Table alias
  • Clauses in SQL
  • Data filtering using WHERE clause
  • Data Sorting using ORDER BY clause
  • Copying Data from one table to another
  • INSERT command
  • UPDATE command
  • DELETE command
  • INSERT ALL command
  • MERGE 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
  • 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
  • Analytical functions
  • Multi Row functions
  • Group by clause
  • Having clause
  • Cube & Rollup
  • Importance of Join Operation
  • Types of Joins
  • Equi Join
  • Non-Equi Join
  • Self Join
  • Outer Join
  • Left Outer
  • Right Outer
  • Full Outer
  • Cross join
  • ANSI joins
  • UNION , UNION ALL
  • INTERSECT
  • MINUS
  • ROWID , ROWNUM
  • Importance of Subqueries
  • Types of Subqueries
  • Single row subqueries
  • Multi row subqueries
  • Nested queries
  • Multi column subqueries
  • Co-related subqueries
  • In-line views
  • Scalar queries
  • Commit command
  • Rollback command
  • Savepoing command
  • Views
  • Indexes
  • Materialized views
  • 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 paramenters
  • For update clause
  • Where current of clause
  • Ref cursors
  • Implicit cursors
  • System defined exceptions
  • User defined exceptions
  • Sqlcode & sqlerrm
  • Pragma exception_init
  • Introduction to subprograms
  • Difference between anonymous & named blocks
  • Creatng procedures
  • Working with IN , OUT ,INOUT parameters
  • Procedures with cursors
  • Procedures returning records
  • Pragma autotnomous transaction
  • Difference b/w procedures and functions
  • Inline functions
  • 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
  • Collections in PL/SQL
  • Built-in packages in PL/SQL

    • Other Courses

    Our Demo Videos

    Contact form

    OUR COURSES
    View All Courses
    ASP .Net TrainingASP .Net Training
    gis trainingGIS Training
    Core JAVA TrainingCore JAVA Training
    C,C++ TrainingC,C++ Training
    Software Testing TrainingSoftware Testing
    Bigdata TrainingBigdata Training
    RPA TrainingRPA Training
    Python TrainingPython Training
    PHP TrainingPHP Training
    Digital Marketing TrainingDigital Marketing
    WHAT PEOPLE SAY ABOUT iTASK

    Harish Kumar

    I am glad that I gained a lot from the course offered by iTask. I learned RAP from excellent faculty who tuned my skills and made me a professional RPA developer.

    Rama Swamy

    Very insightful and straight to the point training by knowledgeable Faculty. Highly recomnd iTask.

    Jayashree

    The staff, trainers, and management of iTask is great. These people really help freshers like me to get a good job. They have changed thousands of lives and I am happy to say that mine was also changed by them. So thank you.