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

Check out more Oracle courses in India

Innovative Technology Solutions Logo

Oracle Database 19c: SQL Training

In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

by Innovative Technology Solutions [Claim Listing ]
  • Price
  • Start Date
  • Duration
Appex Technologies Logo

PHP & MySQL Course

The PHP Hypertext Preprocessor (PHP) is a programming language, which is strictly used for web development that allows web developers to create dynamic content which interacts with databases. PHP course in coimbatore is more popular when it comes to web applications.

by Appex Technologies [Claim Listing ]
Fatema Training Institute Logo

Oracle

Oracle course is offered by Fatema Training Institute. All courses are held in the care of women. Separate classes for women are taken. Thus the Institute is run for all ages, the elderly, children, and women are considered.

by Fatema Training Institute [Claim Listing ]
Radical Technologies Logo

Teradata

Today all databases are failed for Big Data warehouse. Teradata is only database which sustain in market because of it speed and linear scalability. Most of the global airlines using teradara .good number of global financial organizations are using teradara.

by Radical Technologies [Claim Listing ]
Om Institute Logo

MySQL Course

The MySQL Server course with Om Institute of education is designed to provide students with the skills and knowledge necessary to effectively manage and administer a MySQL server.

by Om Institute [Claim Listing ]

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