Verify Affiliation

Oracle Database SQL (1Z0-071)

This course teaches you the fundamentals of SQL using Oracle Database SQL technology. Learn essential SQL skills to query single & multiple tables, manipulate data, and more.

  • Develop SQL skills for writing queries against tables
  • Create database objects
  • Use single row functions to customize output
  • Work with group functions to report aggregated data
  • Use conversion functions and conditional expressions
  • Manipulate queries to return required data
  • Perform calculations on data
  • Administer database objects

Oracle Database 11g: Program with PL/SQL (1Z0-144)

This training teaches you to develop stored procedures, functions, packages, and database triggers. Learn how to manage PL/SQL program units and dependencies.

  • Conditionally control code flow (loops, control structures)
  • Use PL/SQL packages to group and contain related constructs
  • Create triggers to solve business challenges
  • Use Oracle supplied PL/SQL packages for screen and file output
  • Create anonymous PL/SQL blocks, functions, and procedures
  • Declare PL/SQL variables

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms (1Z0-151)

This course teaches how to build scalable, high-performance web applications using Oracle Forms Builder 11g. Develop an order entry application and incorporate advanced features.

  • Use Oracle Forms Builder 11g
  • Enhance applications with various GUI controls
  • Add functionality by writing triggers
  • Use Forms Debugger to troubleshoot applications
  • Validate user input and display meaningful error messages
  • Use WebUtil to interact with client machines
  • Control navigation and display messages to users
  • Replace or supplement default transaction processing

Oracle Fusion Middleware 11g: Build Reports with Oracle Reports Builder

This course focuses on using Oracle Reports Builder to design and build a variety of reports for web and paper formats, enhancing enterprise-level reporting capabilities.

  • Use report parameters and customize runtime parameter forms
  • Enhance reports with graphs and PL/SQL trigger code
  • Maximize report performance with OracleAS Reports Services
  • Publish reports on the web and manage templates
  • Create mailing labels and letters
  • Create and modify basic tabular and matrix reports
  • Access data from various data sources for report creation
  • Publish reports in multiple languages
  • Add dynamic data to existing HTML pages

 

 

Click on Semester for more detail.

Oracle Database 11g: Administration I (1Z0-052)
Oracle Database 11g Administration Course

Oracle Database 11g Administration Course

Topic Details
Exploring the Oracle Database Architecture
  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structures
  • Logical and physical storage structures
  • ASM storage components
Heading
  • Installing your Oracle Software
  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • Installing Oracle Grid Infrastructure
  • Installing Oracle Database Software
  • Silent Install
Creating an Oracle Database
  • Planning the Database
  • Using the DBCA to Create a Database
  • Password Management
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database
Managing the Oracle Database Instance
  • Start and stop the Oracle database and components
  • Use Oracle Enterprise Manager
  • Access a database with SQLPlus
  • Modify database installation parameters
  • Describe the stages of database startup
  • Describe database shutdown options
  • View the alert log
  • Access dynamic performance views
Manage the ASM Instance
  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups
Configuring the Oracle Network Environment
  • Use Enterprise Manager to create and configure the Listener
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers
Managing Database Storage Structures
  • Storage Structures
  • How Table Data Is Stored
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Tablespaces in the Preconfigured Database
  • Actions with Tablespaces
  • Oracle Managed Files (OMF)
Administering User Security
  • Database User Accounts
  • Predefined Administrative Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Profiles
Managing Data Concurrency
  • Data Concurrency
  • Enqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks
Managing Undo Data
  • Data Manipulation
  • Transactions and Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention
Implementing Oracle Database Auditing
  • Describe DBA responsibilities for security
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail
Database Maintenance
  • Manage optimizer statistics
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • Use server-generated alerts
  • Use automated tasks
Performance Management
  • Performance Monitoring
  • Managing Memory Components
  • Enabling Automatic Memory Management (AMM)
  • Automatic Shared Memory Advisor
  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects
Backup and Recovery Concepts
  • Part of Your Job
  • Statement Failure
  • User Error
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Using the MTTR Advisor
  • Media Failure
  • Archive Log Files
Performing Database Backups
  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Terminology
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area
Performing Database Recovery
  • Opening a Database
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Data Failures
  • Listing Data Failures
  • Data Recovery Advisor Views
Moving Data
  • Create and use directory objects
  • Use SQL*Loader to move data
  • Use external tables to move data
  • General architecture of Oracle Data Pump
  • Use Data Pump export and import to move data
Working with Support
  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches

Oracle Database Administration Course

Oracle Database Administration Course

Topic Details
Core Concepts and Tools of the Oracle Database
  • The Oracle Database Architecture: Overview
  • ASM Storage Concepts
  • Connecting to the Database and the ASM Instance
  • DBA Tools Overview
Configuring for Recoverability
  • Backup and Recovery (BR): purpose, typical tasks and terminology
  • Using the Recovery Manager (RMAN)
  • Configuring the database for BR operations
  • Configuring Archivelog mode
  • Configuring backup retention
  • Configuring and using a Flash Recovery Area (FRA)
Using the RMAN Recovery Catalog
  • Tracking and storing backup information
  • Setting up a Recovery Catalog
  • Recording backups
  • Using RMAN Stored Scripts
  • Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)
Configuring Backup Settings
  • Configuring and managing persistent settings for RMAN
  • Configuring Autobackup of control file
  • Backup optimization
  • Advanced Configuration Settings: Compressing Backups
  • Configuring Backup and Restore for very large files (Multisection)
Creating Backups with RMAN
  • Backup types
  • Create and Use
  • Backup Sets and Image Copies
  • Whole Database Backup
  • Fast Incremental Backup
  • Configure Backup Destinations
  • Duplexed Backup Sets
  • Archival Backups
Restore and Recovery Task
  • Restoring and recovering
  • Causes of file loss
  • Automatic Tempfile Recovery
  • Recovering from the loss of a Redo Log Group
  • Recovering from a Lost Index Tablespace
  • Re-creating a Password Authentication File
  • Complete and Incomplete Recovery
  • Other Recovery Operations
Using RMAN to Perform Recovery
  • Complete Recovery after loss of a Critical or Noncritical Data File
  • Recovering image copies and switching files
  • Restore and Recovery of a Database in NOARCHIVELOG Mode
  • Incomplete Recovery
  • Performing Recovery with a Backup Control File
  • Restoring from Autobackup: Server Parameter File and Control File
  • Restoring and Recovering the Database on a New Host
Monitoring and Tuning RMAN
  • Monitoring RMAN Jobs
  • Balance Between Speed of Backup Versus Speed of Recovery
  • RMAN Multiplexing
  • Synchronous and Asynchronous I/O
  • Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION
Using Flashback Technology I
  • Overview and Setup
  • Using Flashback Technology to query data
  • Flashback Table
  • Flashback transaction query
  • Performing Flashback Transaction Backout
  • Oracle Total Recall
  • Flashback Drop and the Recycle Bin
Diagnosing the Database
  • Data Recovery Advisor (DRA)
  • Block corruption
  • Automatic Diagnostic Repository (ADR)
  • Health monitor
  • The ADR Command-Line Tool, ADRCI
Performing Flashback Database
  • Configuring Flashback Database
  • Performing Flashback Database Operations
  • Monitoring Flashback Database
Managing Memory
  • Oracle Memory Structures
  • Oracle Database Memory Parameters
  • Using Automatic Memory Management
  • Automatic Shared Memory Management
  • Using Memory Advisors
  • Using Data Dictionary Views
Managing Database Performance
  • Tuning activities
  • Using statistic preferences
  • Optimizer statistics collection
  • Monitor the performance of Sessions and Services
  • Automatic Workload Repository (AWR)
  • Describing the Benefits of Database Replay
Managing Performance by SQL Tuning
  • SQL Tuning and SQL Advisors
  • Using SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer Overview
Managing Resources
  • Overview and Concepts
  • Accessing and creating resource plans
  • Creating Consumer Group
  • Specifying Resource Plan Directives, including:
    • Limiting CPU Utilization at the Database Level
    • Instance Caging
  • Activating a Resource Plan
  • Monitoring the Resource Manager
Automating Tasks with the Scheduler
  • Simplifying management tasks
  • Creating a Job, Program, and Schedule
  • Using Time-Based, Event-Based, and Complex Schedules
  • Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups
  • Multi-Destination Jobs
Managing Space in Blocks
  • Free Space Management
  • Monitoring space
  • Compressing data
Managing Space in Segments
  • Segment Creation on Demand
  • Additional Automatic Space-Saving Functionality
  • Shrinking Segments
  • Segment Advisor
  • Managing Resumable Space Allocation
Managing Space for the Database
  • Using 4 KB-Sector Disks
  • Transporting Tablespaces
  • Transporting Databases
Duplicating a Database
  • Purpose and Methods of Cloning a Database
  • Using RMAN to Create a Duplicate Database
  • Cloning a Database from a Backup
  • Duplicate a Database Based on a Running Instance
  • Targetless Duplicating a Database

Fees and Durations

Fee: Rs.24,000/- (Twenty Four Thousand only)

Breakup of Fee: Rs.12,000/- per month

Duration: Two and a half Months

Days: Three Days a Week (Alternate Days)

 

OraSoft Training Institute, Copyright © 1999 - 2025, All rights reserved.

Design By Visual Innovative

Open chat
Powered by Joinchat
Hello
Can we help you?