Oracle

SV Infotech Offers Oracle Training in Dilsukhnagar Hyderabad. Oracle PL,SQL Course training institute in Dilsukhnagar Hyderabad Telangana

1. Introduction to RDBMS

  1. Approach to Data Management Database Management:
  2. An evolution Phenomenon Introduction to DBMS Database Models
  3. Hierarchical Model Network Model Relational Model
  4. The 12 Rules for an RDBMS (CODD’s
  5. Rule) Zero rule
  6. Need for an Extended Service form an
  7. RDBMS
  8. Why Oracle?
  9. New Features of Oracle
  10. Oracle as an Object Relational Database Management System (ORDBMS) Networking Computing Architecture (NCA)
  11. Oracle Products

2. Introduction to SQL * Plus

  1. Introduction to SQL *Plus
  2. Oracle Data types
  3. Information Representation
  4. Starting SQL *Plus
  5. Querying database Tables
    • Guaranteed Access
    • Systematic Treatment of Null
    • Systematic Treatment of Null Conditional Retrieval of Rows
    • Values
  6. Working with NULL Values4.Database Description Rule
  7. Matching a pattern with a5.Comprehensive Data Sub- Language
  8. Column from a table6.View Updating
  9. Summarizing data with Aggregate7.High-Level Update, Insert, Delete
  10. Functions8.Physical Data Independence
  11. Ordering the Result of a Query9.Logical Data Independence
  12. Command Summary of SQL *Plus Editor10.The Distribution Rule

3.Querying Multiple Table

  1. Collating Information
  2. E-R Modeling
  3. Degree of Relationship
  4. Normalization
  5. Need for Normalization
  6. Steps in Normalization
  7. Present Scenario for Data Management Relational Database
  8. Management System
  9. Features of Oracle
  10. Equi Joins
  11. Cartesian Joins
  12. Outer Joins
  13. Self Joins
  14. SET Operators Union Intersect Minus
  15. Nested Queries
  16. Correlated Sub query
  17. Using Special Operators in Sub
  18. Defining Header, Footer and Column
  19. queries
  20. Headings
  21. Column Functions
  22. Formatting the Columns
  23. Arithmetic Functions
  24. Control Break Reports
  25. Data Functions

4.PL/SQL

  1. General Functions
  2. Introduction
  3. PL/SQL Block Structure
  4. PL/SQL Architecture
  5. Variables and Constants

5.Data Manipulation and Control -1

  1. Conditional and Iterative Control
  2. Creating tables
  3. Writing the PL/SQL Code
  4. Applying column constraints
  5. Cursor Management in PL/SQL
  6. Introduction to VIEWS
  7. Explicit Cursor Attributes
  8. Inserting Values into a Table
  9. Implicit Cursor Attributes
  10. Inserting the result of a query
  11. Composite Data types
  12. Inserting through Parameter

6.Advanced PL/SQL

  1. SQL *Plus Reporting
  2. DETAbase triggers nad how to create them
  3. Stored Packege
  4. Using stored Function in SQL Statement