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

DLK Career Development Centre Logo

Oracle Training

Oracle instructional exercise gives fundamental and propelled ideas of Oracle. Our Oracle instructional exercise is intended for apprentices and experts. Oracle is a social database administration framework.

by DLK Career Development Centre [Claim Listing ]
Vyom Data Science's Logo

Hbase

HBase: Do you feel like your relational database is not giving you the flexibility you need anymore? Column oriented storage, no fixed schema and low latency make HBase a great choice for the dynamically changing needs of your applications.

by Vyom Data Science's [Claim Listing ]
AlgoxFusion Logo

Database Training

A database is a structured collection of data that is organized and stored in a computer system. It allows for efficient storage, retrieval, and manipulation of data, making it a fundamental component of modern computing.

by AlgoxFusion [Claim Listing ]
STU Corner Logo

MySQL Training

SQL server is an RDBMS from Microsoft and SQL- Structured Query Language is which used to communicate with the Information source and platforms. An RDBMS (Relational Database Management System) allows saving, adjusting and accessing data saved in various platforms.

by STU Corner [Claim Listing ]
MIS Infotech Logo

Oracle

Oracle database is a relational database management system. It is known as Oracle database, OracleDB or simply Oracle. It is produced and marketed by Oracle Corporation.Oracle database is the first database designed for enterprise grid computing.

by MIS Infotech [Claim Listing ]

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