RDBMS & Oracle 11g Course Details

  • RDBMS with Oracle-11g course Overview

    Oracle is most powerful and feature rich RDBMS tool. It is used in many mission critical and high volume oriented systems . It also have ORDBMS feature .which is introduced in this cource .PL/SQL is procedural extension to the SQL language . This course is designed to give users an understanding of Oracle SQL and Oracle PL/SQL languages It also introduce Participants to Basic Database Administration

    Outcome

  • Upon completion of this course, students will be able to:
  • Explain the difference between SQL, PL/SQL and SQL*PLUS.
  • Write basic SQL queries to retrieve desired data.
  • Use DML statements (insert, update, and delete).
  • Use DDL statements (create, alter, and drop).
  • Use transaction control statements to commit, rollback, and create savepoints.
  • Write advanced queries.
  • Write scripts to do queries and display SQL*PLUS reports.
  • Control access to your database objects.
  • Write a PL/SQL block using all elements of block structure.
  • Write PL/SQL statements using lexical units, declared variables, and assignment
    statements.
  • Use control structures to loop, branch, and jump.
  • Use PL/SQL named exceptions and user-defined exceptions.
  • Use explicit cursors.
  • Understand Basic Database administration , managing users and rights
    database and backups

  • Syllabus

    Module A- SQL ,Module B -PL/SQL, Module C DBA basic

      Database design

    • Database Models
    • Some Introductory Terminology
    • Codd's Rules
    • Normalization

      Oracle Standard Interfaces

    • SQL
    • SQL*Plus
    • Oracle Architecture
    • Interfaces to Oracle
    • Command Line Interface
    • Viewing a Sample Table
    • The Graphical User Interface
    • The SQL Buffer
    • The Web-Based Interface

      Data Definition Language

    • Categories of SQL Statements
    • Oracle Datatypes
    • The CREATE Statement
    • The DROP Command
    • The ALTER Command
    • Integrity Constraints
    • Entity Integrity Constraints
    • Referential Integrity Constraints
    • Modifying Table to Use Constraints
    • Checking Constraints
    • Data Dictionary

      Data Manipulation Language

    • DML Statements
    • The SELECT Statement
    • The INSERT Statement
    • The DELETE Statement
    • The UPDATE Statement
    • More SQl *Plus Commands

      Transaction Control

    • Transactions
    • Command Classification
    • Savepoints

      SQL Operators

    • Simple Selects
    • Comparison Operators
    • IN and NOT IN Operators
    • BETWEEN Operator
    • The LIKE Operator
    • Logical Operators
    • NULL and IS NOT NULL
    • ANY
    • ALL

      SQL FUNCTIONS

    • Introduction
    • The DISTINCT Keyword
    • Miscellaneous Functions
    • Mathematical Functions
    • String Functions
    • Date Functions
    • Pseudo Columns
    • other useful functions

      Joining Tables

    • Joins
    • Cartesian Product
    • Inner Joins
    • Equi-Join
    • Table Aliases
    • Non-Equi Join
    • Non-Key Join
    • Reflexive Join
    • Natural Join
    • Outer Joins
    • Right Outer Join
    • Left Outer Join
    • Full Outer Join
    • Oracle-Specific and ANSI Syntax for Joins

      Set Operators

    • Introduction
    • Selection Criteria
    • Union
    • Union All
    • Intersect
    • Minus

      SQL Subqueries

    • Introduction
    • Using a Subquery with a DML Statement
    • Typical Subqueries
    • Subquery Operators
    • Standard vs. Correlated Subqueries
    • Correlated Subquery Example

      Aggregate queries and Groups

    • SQL Statements
    • GROUP BY Clause
    • HAVING Clause
    • Order of a SELECT Statement

      More Database Objects

    • Relational Views
    • Updating a View
    • Indexes
    • Synonyms

      Reports

    • Report Features
    • Session Control
    • The SET Command
    • The COLUMN Command
    • The BREAK Command
    • The COMPUTE Command

      Introduction to PL/SQL

    • SQL vs. PL/SQL
    • A Few Simple Examples
    • Saving Procedures
    • Comments
    • Variable Substitution
    • Simple Exception Handling
    • Advantages of PL/SQL

      Declarations and Data Types

    • Declarations
    • Standard Data Types
    • Initialization
    • Variable Names
    • Specialized Data Types - %TYPE
    • Specialized Data Types - %ROWTYPE
    • Building Your Own Data Types - Records
    • A Quick look at Loops
    • Arrays
    • Tables
    • Nested Blocks

      Language Components

    • Introduction
    • Decision Making Statements
    • Simple Loops
    • Loops - for
    • Loops - indefinite
    • Loops - while
    • Simple Loops
    • Nested Loops
    • Boolean Variables
    • PL/SQL Relational Operators
    • PL/SQL Logical Operators
    • The CASE Construct

      Cursors

    • Introduction
    • Cursor Manipulation
    • Using the Cursor
    • For Loops Cursors
    • Cursor Attributes
    • Cursor Parameters
    • Nested Cursors
    • Cursor Exceptions

      Exceptions

    • Errors in Programs
    • Run Time Exceptions
    • Oracle Built In Exceptions
    • Unnamed Exceptions
    • Built in Exception Functions
    • Creating Your Own Exceptions
    • Building Non Terminating Exceptions

      Functions and Procedures

    • Introduction
    • Creating a Procedure
    • Using Parameters
    • Functions
    • Procedures and Exceptions
    • Database Triggers

      Miscellaneous advanced topics

    • Hierarchical queries in ORACLE
    • Advanced aggregate -ROLLUP CUBE and top N queries
    • advanced table creation – creating partitioned table
    • querying partitioned table
    • ORDBMS in ORACLE
    • Creating types
    • Creating ORDBMS tables
    • Querying ORDBMS tables

      ORDBMS in ORACLE

    • Creating types
    • Creating ORDBMS tables
    • Querying ORDBMS tables

      ORACLE Features for Administrators

    • Oracle Overview and Architecture.
    • Installing
    • Creating a Database and Data Dictionary.
    • Control and Redo Log Files.
    • backups
    • Logical and Physical Database Structures.
    • Segments and Storage Structures.
    • Managing Tables, Indexes, and Constraints.
    • Managing Users
    • Control User Access
    • Differentiate system privileges from object privileges
    • Create Users
    • Grant System Privileges
    • Create and Grant Privileges to a Role
    • Change Password, freeze an account
    • Grant Object Privileges
    • How to pass on privileges?
    • Revoke Object Privileges
    • Management of Schema Objects
    • Add, Modify, and Drop a Column
    • Add, Drop, and Defer a Constraint
    • Enable and Disable a Constraint

    Upcoming Batches


    For New Batches Contact +91-81026-29294

    Fill Up the Enquiry Form

    Training Methodology

    40 Hrs of Class Room Training

    Study Material

    4 Assignments

    1 Project[10hrs]

    Online Tests

    Final Online Test

    Certification

    Life Time Access of Training Resources

    Training Fee: INR 6000
    Discount Policy

    Group Discount : 4 and above 15% discount:INR 5100

     +91-88048-78791
    Enquiry Form