Database Application Development using Oracle

Course Overview/Objective
  • To Develop web based application software using Oracle Database and Oracle Developer Suite platform Oracle SQL PL/SQL
  • To perform the ability to Design Database backup, Restoring, recovery, security ,Maintaining etc. using  the database structure for application
  • To Manage Oracle database Server
  • To achieve the ability to Designing the database  structure for application
Requirements

Graduate; Experience in  the  use  database management

Course Project
Yes
Used Tools
Oracle
Course Outline

SQL:

  • Retrieving data using the SQL select statement]
  • Restricting and sorting data
  • Using single row function to customize output.
  • Reporting aggregated data using the grout function.
  • Displaying data from multiple tables –I
  • Displaying data from multiple tables-II
  • Using sub queries to solve problems
  • Using set operators
  • Manipulating data
  • Using DDL statements to create and manage tables
  • Creating other schema objects
  • Managing objects with data dictionary
  • Controlling User access
  • Managing schema objects
  • Manipulating large data sets
  • Generating report by grouping related data
  • Managing data in different time zones
  • Retrieving data using sub queries
  • Hierarchical retrieval
  • Regular expression support

PL/SQL:

  • Introduction
  • Declaring Variables
  • Writing Executable Statements
  • Interacting with Oracle Server
  • Writing Control Structures
  • Working with Composite Data Types
  • Writing Explicit Cursors
  • Writing Implicit Cursors
  • Handling Exceptions
  • Creating Procedures
  • Creating Functions
  • Managing Subprograms
  • Creating Packages
  • More Package concepts
  • Oracle supplied Packages
  • Manipulating Large Objects
  • Creating Database Triggers
  • More Trigger concepts
  • Managing Dependents

Course II:

  1. SQL:
    • Retriving data using the SQL select statement]
    • Restricting and sorting data
    • Using single row function to customize output.
    • Reporting aggregated data using the grout function.
    • Displaying data from multiple tables –I
    • Displaying data from multiple tables-II
    • Using sub queries to solve problems
    • Using set operators
    • Manipulating data
    • Using DDL statements to create and manage tables
    • Creating other schema objects
    • Managing objects with data dictionary
    • Controlling User access
    • Managing schema objects
    • Manipulating large data sets
    • Generating report by grouping related data
    • Managing data in different time zones
    • Retrieving data using sub queries
    • Hierarchical retrieval
    • Regular expression support
  1. Admin I:
    • Introduction
    • Installing the Oracle Database Structure
    • Creating an Oracle Instance
    • Managing the Oracle Instance
    • Managing Database Storage Structure
    • Oracle managed file(OMF)
    • Creating a table space
    • Administering security
    • Managing Schema Objects
    • Types of Indexes
    • Managing Data and Concurrency
    • Locking Mechanism
    • Managing Undo Data
    • Implementing Oracle Database Security
    • Configuring the Oracle Network environment
    • Proactive Maintenance
    • ADDM
    • Performance Management
    • Backup and Recovery Concept
    • Hot Backup
    • Cold Backup
    • Hands on practice
    • Performing Database Backups
    • Performing Database Recovery
    • Performing Flashback
    • Hands on practice
    • Flashback version query
    • Moving Data
    • Oracle Data pump
  1. Admin II:
  • Introduction
  • Oracle managed files
  • Configuring recovery manager
  • Using recovery manager
  • RMAN backup types
  • Hands on practice
  • Recovering from non critical loses
  • Database recovery
  • Types of incomplete recovery
  • Flashback
  • Dealing with database corruption
  • Hands on practice
  • Monitoring and managing memory
  • Automatic shared memory management
  • Automatic performance management
  • Automatic workload repository
  • Managed schema objects
  • Hands on practice
  • Clusters
  • Managing storage
  • Automatic storage management
  • ASM disk group
  • Portioning a disk
  • Managing resources
  • Automatic task with schedule