Oracle Sql / Plsql Online Training

Oracle 11g( SQL, Pl/Sql)

  • Introduction to Data Base Management
    • Basic Data Base Concepts
    • Introduction to DataBase Utilities
    • Introduction to Oracle Tools
  • Interactive SQL
    • Invoking Sql* Plus
    • Data Manipulation in Data Base Management systems
    • Oracle Data Types
    • Creating a table
    • Creating table from a table
    • Insertion of data into tables
      • Inserting a single row of data into a table
      • Inserting data into a table from another table
      • Insertion of selected data into a table from another table
      • Updating the contents of a table
    • Deletion operations
      • Deletion of all rows
      • Deletion of specified number of rows
    • Data extraction
      • Global data extract
      • The retrieval of specific columns from a table
      • Elimination of duplicates from the select statement
      • Sorting of data in a table
      • Selecting a data set from table data
    • Modifying the structure of tables
      • Adding new columns
      • Modifying existing columns
      • Restrictions on the Alter table
    • Revoking/Deleting/Dropping Tables
      • Exercise
    • investigate the EMP database
  • Using SQL*Plus
    • Command prompt formatting keywords and their usage
    • Creating basic reports using
    • Exercise format a simple query in the emp database
  • sql Data constraints
    • Column Level and Table Level Constraints
    • Null Value concepts
    • Primary Key Concepts
    • Unqiue Key concepts
    • Default value concepts
    • The Foreign key/References constraint
    • Check Integrity Constraints
    • Defining different constraints on the table
    • Defining Integrity constraints in the ALTER TABLE command
    • Dropping Integrity constraints in the ALTER TABLE command
  • Computations in Expression lists used to select data
    • Renaming Columns used with Expression Lists
    • Arithmetic Operators
    • Logical Operators
    • Range Searching
    • Pattern matching
      • The use of the LIKE predicate
      • The IN AND NOT IN predicates
    • Advanced SQL operators
      • Between operator
      • EXISTS clause
      • Using wildcards in queries (LIKE operator)
      • Aggregation in SQLCount(*)
      • Concatination operator
  • Select statement class
  • Oracle Functions
  • Joins
    • Equi joins
    • Self joins
  • Subqueries
    • Exercise write a subquery
    • Correlated subquery
    • Non-correlated subqueries
  • Indexes
    • Creating an Index for a table
    • Dropping Indexes
  • Views
    • Creation of views
    • Renaming the columns of a view
    • Using views
    • Selecting a data set from a view
    • Updateable views
    • Destroying views
  • Sequences
    • Creation of Sequences
    • Referencing a Sequence
    • Altering a Sequence
    • Dropping a Sequence
  • Privileges
    • Granting permissions
    • Revoking Permission
  • Tuning Basics
    • Sql Query Optimization techniques
    • Indexes
    • Introduction to TKPROF,EXPLAIN PLAN

PL/SQL Section

  • Introduction of PL/SQL
    • PL/SQL architecture
    • Advantages of PL/SQL Over other programming languages
  • Overview of PL/Sql Elements
    • Blocks
    • Variables and constants
    • Using Sql In PL/Sql
  • Introduction of PL/SQL structures
    • Simple blocks
    • Branching and Conditional Control
    • Loop Statements
    • Go To statement
    • Declaring variables and constants
    • Executing Simple block with various examples on constants and variables
  • Error checking
    • exception handling
    • Defining exceptions
    • Using the when others clause
    • Ensuring complete error checking
    • Passing error messages to calling routine
  • Boolean logic in PL/SQL
    • Identifying the Uses and Types of Control Structures
    • Constructing an IF Statement
    • If-then-else structure
    • Testing for numbers characters and Booleans
  • Iteration in PL/SQL
    • Constructing and Identifying Different Loop Statements
    • For loop
    • While loop
  • Cursors
    • Introduction of cursor
    • Cursor Attributes
    • Implicit cursor & Explicit cursor
  • Procedure, Function and Packages
    • Defining stored procedures & functions
    • Passing arguments to functions and stored procedures
    • Recompiling functions and stored procedures
    • Package forward declaration
    • Package dependency
    • Listing package information
  • Records, Pl/Sql Tables
    • Defining PL/SQL tables
    • Reasons to use PL/SQL tables
    • Populating a PL/SQL table
    • Retrieving from a PL/SQL table
  • Object types and Collections.
  • Triggers
    • Use of Data base triggers
    • Defining a trigger
    • Enabling and disabling a trigger