16 Years Of Excellence.

Oracle

Oracle

1. Introduction to RDBMS

  • Approach to Data Management Database Management:
  • An evolution Phenomenon Introduction to DBMS Database Models
  • Hierarchical Model Network Model Relational Model
  • The 12 Rules for an RDBMS (CODD’s
  • Rule) Zero rule
  • Need for an Extended Service form an
  • RDBMS
  • Why Oracle?
  • New Features of Oracle
  • Oracle as an Object Relational Database Management System (ORDBMS) Networking Computing Architecture (NCA)
  • Oracle Products

2. Introduction to SQL * Plus

    • Introduction to SQL *Plus
    • Oracle Data types
    • Information Representation
    • Starting SQL *Plus
      • Querying database Tables

      • Guaranteed Access
      • Systematic Treatment of Null
      • Systematic Treatment of Null
          Conditional Retrieval of Rows
      • Values
  • Working with NULL Values4.Database Description Rule
  • Matching a pattern with a5.Comprehensive Data Sub- Language
  • Column from a table6.View Updating
  • Summarizing data with Aggregate7.High-Level Update, Insert, Delete
  • Functions8.Physical Data Independence
  • Ordering the Result of a Query9.Logical Data Independence
  • Command Summary of SQL *Plus Editor10.The Distribution Rule

3.Querying Multiple Table

  • Collating Information
    • E-R Modeling
    • Degree of Relationship
    • Normalization
    • Need for Normalization
    • Steps in Normalization
    • Present Scenario for Data Management Relational Database Management System
    • Features of Oracle
    • Equi Joins
    • Cartesian Joins
    • Outer Joins
    • Self Joins
    • SET Operators Union Intersect Minus
    • Nested Queries
    • Correlated Sub query
    • Using Special Operators in Sub
    • Defining Header, Footer and Column
    • queries
    • Headings
    • Column Functions
    • Formatting the Columns
    • Arithmetic Functions
    • Control Break Reports
    • Data Functions
    • 4.PL/SQL

      • General Functions
      • Introduction
      • PL/SQL Block Structure
      • PL/SQL Architecture
      • Variables and Constants
      • 5.Data Manipulation and Control -1

        • Conditional and Iterative Control
        • Creating tables
        • Writing the PL/SQL Code
        • Applying column constraints
        • Cursor Management in PL/SQL
        • Introduction to VIEWS
        • Explicit Cursor Attributes
        • Inserting Values into a Table
        • Implicit Cursor Attributes
        • Inserting the result of a query
        • Composite Data types
        • Inserting through Parameter

        6.Advanced PL/SQL

        • SQL *Plus Reporting
        • DETAbase triggers nad how to create them
        • Stored Packege
        • Using stored Function in SQL Statement

Address:

#7-20, 4th Floor,
Kamala Land Mark,
Beside Konark Theater,
Dilsukh Nagar,
Hyderabad - 500 060.
Telangana State, INDIA.

Landline:

040 - 6625 2272
040 - 6625 2273
040 - 6625 2274

Mobile:

+91 - 93999 74756
+91 - 903 006 1377
+91 - 939 249 1377

E-Mail:

info.svgroups@gmail.com
team@svinfotech.in
jobs@svinfotech.in
director@svinfotech.in