Oracle (SQL & PL/SQL)

by NICE (National Institute of Computer Education Pvt. Ltd) Claim Listing

Oracle (SQL & PL/SQL) course is offered by NICE (National Institute of Computer Education Pvt. Ltd). NICE-National Institute of Computer Education Pvt. Ltd., is one of the Pioneer Computer Training Institute of the Country setting quality standards for ‘IT Education’.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

NICE (National Institute of Computer Education Pvt. Ltd) Logo

img Duration

3 Months

Course Details

Oracle (SQL & PL/SQL) course is offered by NICE (National Institute of Computer Education Pvt. Ltd). NICE-National Institute of Computer Education Pvt. Ltd., is one of the Pioneer Computer Training Institute of the Country setting quality standards for ‘IT Education’.

Quality Education & Training from NICE have become synonymous. This is reflected by the acceptance of NICE Certificates by all and utilization of its Services by MNCs, Public & Private Sector Organizations, Government Departments, Universities, Colleges, Etc.

 

Course Structure:

  • 1.DBMS Concepts
  • What is Database?
  • What is Database System?
  • F.CODD’s Rules
  • RDBMS
  • ORDBMS
  • Difference Between DBMS, RDBMS & ORDBMS
  • 2.SQL
  • What is SQL?
  • DDL Commands
  • Create, Alter, Drop
  • Truncate, Rename
  • DML Command – Insert
  • SQL SELECT statements
  • What is SQL?
  • DDL Commands
  • Create, Alter, Drop
  • Truncate, Rename
  • DML Command – Insert
  • Constraints
  • Primary Key Constraint
  • Unique Constraint
  • Not Null Constraint
  • Foreign Key Constraint
  • Check Constraint
  • Cascade Constraints
  • Joins
  • What is a Join?
  • Cartesian Join
  • Equi Join
  • Non – Equi Join
  • Self Join
  • Outer Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Pseudo Columns
  • Functions
  • Numeric Functions
  • Character Functions
  • Date Functions
  • Conversion Functions
  • General Functions
  • Aggregating Data Using Group Functions
  • Sub Queries
  • Simple Sub Queries
  • Multiple Row Sub Queries
  • Update
  • Data Updating
  • Updating data using Sub Queries
  • Delete
  • Deleting Data
  • Deleting data using Sub Queries
  • Deleting data using join
  • Transaction Control Language (TCL)
  • Commit
  • Roll back
  • Save point
  • Database Objects
  • View
  • Synonym
  • Sequence
  • Index
  • Privileges
  • View
  • Simple View
  • Complex View
  • In Line View
  • Synonym
  • Private Synonym
  • Public Synonym
  • Privileges
  • Grant
  • Revoke
  • 3.PL/SQL
  • Block Structure of PL/SQL
  • Data Types, Variables & Constants
  • Flow Control Statements
  • Simple IF
  • IF-THEN-ELSE Statements
  • IF-THEN-ELSIF Statements
  • Iterative Statements
  • Simple Loop
  • While Loop
  • For Loop
  • Attribute Data Types
  • %type
  • %Rowtype
  • Cursor Management
  • What is Cursor?
  • Implicit Cursor
  • Explicit Cursor
  • Cursor with parameters
  • Cursor with For Loop
  • Exceptions
  • What is an Exception?
  • Predefined Exception
  • User defined Exception
  • Sub Programs
  • Named PL/SQL Block
  • Stored Procedures
  • Types of Parameters
  • Stored Function
  • Difference between Function and Procedure
  • Package
  • What is package?
  • Importance of package
  • Triggers
  • What is a Trigger?
  • Row Level Trigger
  • Table Level Trigger
  • Instead of Trigger
  • DML Triggers
  • System Trigger
  • Bhubaneshwar Branch

    Plot # 560 (1st Floor), Saheed Nagar, Bhubaneshwar

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy