ORACLE 11g-( SQL & PL/SQL) ONLINE TRAINING

Home / ORACLE 11g-( SQL & PL/SQL) ONLINE TRAINING

ORACLE 11g-( SQL & PL/SQL) ONLINE TRAINING

ORACLE 11g-( SQL & PL/SQL) ONLINE TRAINING

ORACLE 11g-( SQL & PL/SQL) ONLINE TRAINING

ORACLE 11g-( SQL & PL/SQL) ONLINE TRAINING

1.Fundamentals of Database

  • DBMS Concepts
  • RDBMS Concepts
  • Oracle versions
  • Features of Oracle 8i/9i/10g/11G/12c
  • What is E-R Model?
  1. STRUCURE QUERY LANGUAGE( SQL )
  • What is SQL?
  • Role of SQL in RDBMS
  • Sub-languages in SQL
  • What is SQL, SQL*PLUS and ISQL*PLUS
  • Oracle data types
  1. LANGUAGES

Data Definition Language (DDL) Commands

  • CREATE
  • ALTER (ADD,MODIFY)
  • TRUNCATE
  • DROP
  • RENAME

Data Manipulation Languages(DML) Commands

  • INSERT
  • UPDATE
  • DELETE
  • SELECT

 

Transaction Control Languages(TCL) Commands

  • ROLLBACK
  • COMMIT
  • SAVEPOINT

 

 

Data Control Languages(DCL) Commands

  • GRANT
  • REVOKE

 

  1. DATA INTEGRITY CONSTRAINTS
  • KEY Constraints
  • DOMAIN Constraints
  • REFERENTIAL INTEGRITY Constraints

 

  1. OPERATORS
  • Arithmetic  Operators
  • Relational Operators
  • Relation Negation Operators
  • Logical Operators
  • Set Operators (Union, Union All, Intersect, Minus)

 

  1. JOINS
  • Use Of  JOINS
  • Types of  JOINS (Cross, Equi ,Non Equi, Self and Outer Joins)

 

7.SUB- QUERIES

  • Single row sub-queries
  • Multi-row sub-queries
  • Correlated Sub-Queries
  • Use of EXISTS / NOT EXISTS /ANY
  1. SQL OBJECTS

8.1. VIEWS

  • What is a view?
  • Importance of View.
  • Types of Views
  • Simple views
  • Composite views
  • Inline views
  • Materialized views

8.2. INDEXES

  • What is a INDEX
  • Types of Indexes

8.3. SYNONYMS

  • Use of Synonym
  • Types of Synonyms(PUBLIC,PRIVATE)
  • How and when to create synonyms?

8.4. CLUSTERS

  • Use of cluster
  • Creation of cluster
  • Advantages of clusters

8.5. SEQUENCE

  • Creating sequence
  • Using sequences

 

  1. PARTITIONS
  • What is partition
  • Types of partition
  1. SQL FUNCTIONS

Categories of Functions

  • Group or Aggregate Functions
  • Scalar  or Single Row Functions

Types of  Functions

  • Numerical Functions
  • String Functions
  • Conversion Functions
  • Date Functions
  1. PL/SQL
  • Introduction to PL/SQL
  • What is a Program block?
  • Advantages of PL/SQL.
  • Architecture of PL/SQL Engine
  • Features, Structure of Program Block
  • Data types, Executable Stmts.
  • What are the blocks in the program structure?
  • DECLARE Block
  • BEGIN Block
  • EXCEPTION Block
  • END

11.1. TYPES OF PROGRAMS

  • Static Programs
  • Dynamic Programs
  • Worked Examples and Assignments

11.2. Type Compatibility keywords

  • Declaring variables Dynamically —%TYPE
  • Declaring Table Type Record Variables–%ROWTYPE

11.3 SUB PROGRAMS

Stored Procedures

  • What is a procedure?
  • How to create it?
  • What are the advantages of procedures?
  • Types of stored procedures
  • Static Procedures (without Arguments)
  • Dynamic Procedures (with Arguments)
  • Arguments or Parameters  Mode
  • IN                           OUT                      INOUT

CONDITIONAL  STATEMENTS

  • Simple IF
  • IF—THEN—ELSE
  • COMPOUND IF
  • ELSIF Construct
  • Worked Examples and Assignments

 

 

LOOPS

  • Simple Loop
  • While Loop
  • For Loop

CURSORS

  • Types:  Implicit   and   Explicit   cursors
  • Cursor Variables

What is BULK COLLECT?

 ORACLE 11g-( SQL & PL/SQL) ONLINE TRAINING

EXCEPTION HANDLING AND THEIR TYPES

  • Predefined Exceptions
  • User defined Exceptions
  • Pragma_ Exception_init
  • RISE_APPLICATION_ERROR

PL/SQL RECORDS AND TABLES

  • Composite Data Types
  • PL/SQL Records & Tables
  • Nested Records
  • Using Record in a Table
  • And Examples

FUNCTIONS

  • What is  a Function?
  • When we have to create a function?
  • How to call it?
  • With and without arguments

PL/SQL Collections

  • VARRAYS
  • RECORDS (user defined)

TRIGGERS

  • What is a Trigger Program?
  • When we need a Trigger?
  • Parts of a Trigger
  • Types of Triggers
  • Database Triggers
  • Row Triggers with Ex.
  • Statement Triggers
  • Instead-of Triggers – Views with Ex.

PACKAGES

  • Structure
  • Implementation
  • Accessing   procedures and functions from a package

 

  • DURGA SOFTWARE TRAININGS IN YOUTUBE
  • 8000+ Technical Software training videos on all technologies
  • just subscribe link : https://goo.gl/BZ1gVj
  • For More Info:
  • DURGASOFT Online Team
  • mail: durgasoftonlinetraining@gmail.com
  • Ph:8885252627,7207212427/28