RKCP Information Technology




Oracle
Home » Courses   » Oracle

Oracle

Overview

How to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL).

Introduction to Oracle 11g database features and tools.


Objective

  • Write SELECT statements
  • Use Scalar functions
  • Join tables
  • Use aggregate functions
  • Manipulate data
  • Create and use transactions
  • Use data definition and control statements

  • Prerequisites

    No prior experience is presumed.


    Syllabus

    Expand All
    • 1.Relational Databases & SQL
      • About Relational Databases
      • Elements of SQL
    • 2. Choosing A SQL & PL/SQL Interface
      • About Database Connections
      • About Bind Variables
      • Using SQL Developer
      • Using SQL*PLUS
      • Using Application Express
    • 3. Building A Statement
      • About the Select Statement
      • Using Alias Names
    • 4. Restricting Data with the Where Clause
      • About Logical Operators
      • Equality Operator
      • Boolean Operators
      • Null & Between Operators
      • Is [Not] Null Operator
      • [Not] Between Operator
      • Finding Text Strings
      • [Not] Like Operator
      • Regexp_Like()
      • In Operator
    • 5. Sorting Data with the Order By Clause
      • About the Order By Clause
      • Multiple Column Sorts
      • Specifying the Sort Sequence
      • About Null Values within Sorts
      • Using Column Aliases
    • 6. Pseudo Columns & Functions
      • Using Rowid
      • Using Rownum
      • Using the Functions
      • Sysdate
      • User & Uid
      • Using the Dual Table
      • Sessiontimezone Function
    • 7. Joining Tables
      • About Joins
      • Inner Join
      • Reflexive Join
      • Non-Key Join
      • Outer Join
    • 8. Using the Set Operators
      • About the Set Operators
      • Set Operator Examples
    • 9. Summary Functions
      • About Summary Functions
      • Summary Functions with Distinct
    • 10. Using Sub-Queries
      • About Sub-Queries
      • Standard Sub-Queries
      • Correlated Sub-Queries
    • 11. Aggregating Data within Groups
      • About Summary Groups
      • Finding Groups within the Base Tables
      • Selecting Data from the Base Tables
      • Selecting Groups from the Result Table
    • 12. Build Simple SQL*PLUS Reports
      • Format Column Output with Column
      • Defining Report Breaks with Break
      • Produce Subtotals with Compute
    • 13. Use Data Definition Language to Create & Manage Tables
      • Create Table Statement
      • Not Null
      • Default
      • Alter Table Statement
      • Drop Table Statement
      • Supportive Statements
      • Describe
      • Rename
    • 14. Use Data Manipulation Language to Manipulate Data
      • About the Insert Statement
      • About the Delete Statement
      • About the Update Statement
      • About Transactions
      • Rollback
      • Commit
      • Savepoint
      • Set Transaction
      • Truncate Table
      • Complex Table References
    • 15. SQL99 Join Techniques
      • Cross Joins
      • Natural Joins
      • Inner Joins
      • Outer Joins
      • Anti Joins
      • Using Named Subqueries
    • 16. Enhancing Groups with Rollup & Cube
      • Using Rollup
      • Using Cube
    • 17. SQL Functions: Character
      • String Formatting Functions
      • Ascii Codes Functions
      • Pad & Trim Functions
      • String Manipulation Functions
      • String Comparison Functions
      • Phonetic Search Functions
    • 18. SQL Functions: Numeric
      • About the Numeric Functions
      • Null Value Functions
    • 19. SQL Functions: Date
      • Date Format Functions
      • Date Arithmetic Functions
    • 20. Database Objects: Relational Views
      • About Database Objects
      • About Relational Views
      • Updating View Data
      • Maintaining View Definitions
      • Alter View
      • Drop View
    • 21. Database Objects: Data Dictionary Storage
      • About the Data Dictionary
      • Object-Specific Dictionary Views
      • User_Updatable_Columns
      • Understanding the Data Dictionary Structure
    • 22. Database Objects: Indexes
      • About Indexes
      • Use B-Tree Indexes
    • 23. Database Objects: Other Objects
      • More About Creating Tables
      • About Sequences
      • Alter Sequence & Drop Sequence
      • Alter Sequence
      • Drop Sequence
      • About Synonyms
      • Drop Synonym
      • Create Schema Authorization
    • 24. Database Objects: Security
      • User Passwords
      • Object Security
    • 25. Data Using Constraints
      • About Constraints
      • Not Null Constraint
      • Check Constraint
      • Unique Constraint
      • Primary Key Constraint
      • References Constraint
      • Defining Constraints On Existing Tables
    • 26. Managing Constraint Definitions
      • Renaming & Dropping Constraints
      • Enabling & Disabling Constraints
      • Deferred Enforcement
      • Set Constraints
      • Handling Constraint Exceptions
      • Constraints with Views
      • Data Dictionary Storage
    • 27. Advanced SQL*PLUS Reports
      • Break
      • Compute
      • Column
      • Ttitle & Btitle