admin@onlinetrainings9.com

IND No.+91-9036298699
  • Home
  • About
  • Courses
  • Instructors
  • Payment
  • Contact Us

ORACLE

ORACLE

DESCRIPTION

Course Content

:::…Oracle…:::
 Database Introduction
 Data
 Database
 Database Management System
 Types of Databases
 ER-Model
 Accessing the Database
 Environments to access database
 Toad
 Sql Developer
 Sql Navigator
 Sql * Plus

SQL
 Accessing the Databases using SQL
 Data types
 Database Objects :
 Types of Database Objects in SQLTables
 Views
 Types of Views
 Difference between Normal Views and Materialized Views
 Sequences
 Synonyms
 Indexes
 Clusters
Data Dictionary Tables or Meta Data Tables
 Types of SQL Statements

 DDL
 D M L
 DQL/DRL
 DCL
 TCL
 Dual Table
 SQL Operators
 Arithmetic Operators
 Comparison/Relational Operators
 Logical Operators
 SQL Special Operators
 Functions
 Single-Row Functions& Types
 Multi-Row Functions& Types
 Joins
 Oracle Joins
 ANSI Joins
 Sub Queries
 Types Of Sub Queries
 Advanced Sub Queries
 Set Operators
 Pseudo Columns
 Pseudo Columns
 Types of Pseudo Columns
 Rowid
 Rownum
 Nextval
 Currval
 Level
 Top-N & Bottom-N Analysis
 Hierarchal Queries
 Constraints
 Analytic Functions
 Cube
 Rollup
 Grouping
 Rank
 Dense Rank
 Over
 And more

PL/SQL

 Difference between SQL and PL/SQL
 Advantages of using PL/SQL
 Types of PL/SQL Programs
 Displaying Outputs in PL/SQL
 Variables
 Usage of Variables
 Scope of Variables
 Types of Variables
 Using DML Statements in PL/SQL program
 Using DQL Statements in PL/SQL Program
 Non-PL/SQL Variables
 Conditional Statements
 Iterative Statements
 Composite Data Types
 Records
 Collections
 Cursors
 Types of Cursors
 Cursor Attributes
 Writing Cursors using Iterative Statements
 Parameterized Cursor
 Static Cursor
 Dynamic/Ref Cursor
 Pragma
 Types of Pragmas
 Pragma Exception_Init
 Pragma Autonomous_Transaction
 Pragma Serially_Reusable
 Pragma Restrict Reference
 Exceptions
 Types of Exceptions
 Using Exception_Init
 Difference between dbms_output.put_line and raise_application_error in Exceptions
 Procedures
 Compilation and Execution of Procedures
 Types of Parameters in Procedures
 Calling one procedure from another procedure
 Using Pragma Autonomous Transaction
 Functions
 Compilation and Execution of Functions
 Types of Parameters in Functions
 Difference between Procedures and Functions
 Packages
 Compilation and Execution of a Package
 Private Sub Program
 Triggers
 Types of Triggers
 Mutating Trigger
 Advanced PL/SQL
 Bulk Fetching
 Dynamic SQL
 And more

     Register this course
  • Paypal:  rajani.kotapati9@gmail.com
  • riamoneytransfer.com
  • remitly.com
  • Duration:  6 Weeks
  • Type:  Online Training
  • Languages: English
  • Video : English
ORACLE

About

Online Trainnings9 is based at India and serves to global customers for IT Training and Consulting Services. Online Trainnings9having the trainer pool to deliver training programs with cutting edge techniques and methodology that provides people with right skills and knowledge to help them achieve their career goals.

Hot Links

  • About Us
  • Courses
  • Instructers
  • Payment
  • Contact Us

Contact

phone
IND NO.+91 90 3629 8699
USA NO.+1 7576099623
email
info@onlinetrainings9.com
Skype id
onlinetrainings9

Payment

    Thanks for your interest to register for a course with us, we ensure you to get the best service for the same. You can pay your course fee with the following options,

     
  •  Paypal  rajani.kotapati9@gmail.com
  •  riamoneytransfer.com
  •  www.remitly.com

Copyright © 2016 Onlinetrainings | All Right Reserved | Privacy Policy | Terms of Use

Designed & Developed By