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

Brainwave Infotech Logo

MySQL

MySQL course is offered by Brainwave Infotech. Our vision is to exceed the student’s expectations by providing high-quality and cost-effective education. This will be accomplished through the coordination of the associates working together in an ethical, efficient, respectful and manner.

by Brainwave Infotech [Claim Listing ]
Technolinks Logo

Oracle Course

Oracle course is offered by Technolinks. We provide customized training module for all age groups according to their requirements. Our all instructors expert and highly experienced. We provide study materials to our students.

by Technolinks [Claim Listing ]
Interface Software Services Logo

PHP & MySQL Training

PHP is a server-side scripting language, which is extensively designed for website development. It is also used as an all-purpose programming language as it is user-friendly and efficient. PHP is an easy program language with logical syntax and well-described command functions.

by Interface Software Services [Claim Listing ]
  • Price
  • Start Date
  • Duration
Career Lines Logo

Oracle Certification Training

Oracle is the world's most popular database management system. There are many job opportunities available for Oracle professionals at present. Oracle is one of the most in-demand technologies in the IT market, and many companies are looking for experienced professionals.

by Career Lines [Claim Listing ]
E-Learners Computer Education Logo

Oracle Course

Oracle course is offered by E-Learners Computer Education for all skill level. Our mission to become the best education provider company of the world by teaching millions of people around the globe, by providing essential computer education, quality produce and services.

by E-Learners Computer Education [Claim Listing ]

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