Peakin

Menu
Register For Demo Session

Oracle SQL /PLSQL

DBMS Concepts

  • What is Database?
  • What is Database System?
  • F.CODD’s Rules
  • RDBMS
  • Difference Between DBMS, RDBMS


SQL

  • What is SQL?
  • DDL Commands
  • Create, Alter, Drop
  • Truncate, Rename
  • DML Command – Insert


SQL SELECT statements

  1. Order by Clause
  2. Distinct Clause
  3. Where Clause
  4. Operators
  5. Comparison Conditions


Constraints

  1. Primary Key Constraint
  2. Unique Constraint
  3. Not Null Constraint
  4. Foreign Key Constraint
  5. Check Constraint
  6. Cascade Constraints


Joins

  1. What is a Join?
  2. Cartesian Join
  3. Equi Join
  4. Non – Equi Join
  5. Self Join
  6. Outer Join
  7. Left Outer Join
  8. Right Outer Join
  9. Full Outer Join
  10. Pseudo Columns


Functions

  1. Numeric Functions
  2. Character Functions
  3. Date Functions
  4. Conversion Functions
  5. General Functions
  6. Aggregating Data Using Group Functions


Sub Queries

  1. Simple Sub Queries
  2. Multiple Row Sub Queries


Update

  1. Data Updating
  2. Updating data using Sub Queries


Delete

  1. Deleting Data
  2. Deleting data using Sub Queries
  3. Deleting data using join


Transaction Control Language (TCL)

  1. Commit
  2. Roll back
  3. Save point


Database Objects

  1. View
  2. Synonym
  3. Sequence
  4. Index
  5. Privileges


View

  1. Simple View
  2. Complex View
  3. In Line View
  4. Materialized views


Synonym

  1. Private Synonym
  2. Public Synonym


Privileges

  1. Grant
  2. Revoke
Our Practices

PL/SQL

  1. PL/SQL
  2. Block Structure of PL/SQL
  3. Data Types, Variables & Constants
 

Flow Control Statements

  1. Simple IF
  2. IF-THEN-ELSE Statements
  3. IF-THEN-ELSIF Statements
 

Iterative Statements

  1. Simple Loop
  2. While Loop
  3. For Loop
 

Attribute Data Types

  1. %type
  2. %Rowtype
 

Cursor Management

  1. What is Cursor?
  2. Implicit Cursor
  3. Explicit Cursor
  4. Cursor with parameters
  5. Cursor with For Loop
 

Exceptions

  1. What is an Exception?
  2. Predefined Exception
  3. User defined Exception
 

Sub Programs

  1. Named PL/SQL Block
  2. Stored Procedures
  3. Types of Parameters
  4. Stored Function
  5. Difference between Function and Procedure
 

Package

  1. What is package?
  2. Importance of package
 

Triggers

  1. What is a Trigger?
  2. Row Level Trigger
  3. Table Level Trigger
  4. Instead of Trigger
  5. DML Triggers
  6. System Triggers
 
 
  1. Reference Cursors and Records.
  2. Collections—- Varray , Index by table , Nested table, Bulk collection,
  3. Dynamic SQL In PL/SQL