ORACLE CORE DBA ONLINE TRAINING - Online Training for SAP|Oracle|JAVA|Microsoft|Mobile Apps|Testing|SAS|Hadoop - Acutesoft Solutions
India:+91 (0)9848346149, USA: +1 973-619-0109, UK: +44 207-993-2319 Santosh@acutesoft.com
Select Page

ORACLE CORE DBA

ORACLE CORE DBA ONLINE TRAINING

ORACLE CORE DBA ONLINE TRAINING IN INDIA, USA & UK

ORACLE CORE DBA ONLINE TRAINING IN CANADA

ORACLE CORE DBA ONLINE TRAINING IN AUSTRALIA

ORACLE CORE DBA ONLINE TRAINING

ORACLE DBA COURSE CURRICULUM

Download [PDF]

  • Overview of the Oracle Core DBA
      Introduction (Database Architecture)
      Describe course objectives
      Explore the Oracle 10g database architecture
      Installing the Oracle Database Software
      Explain core DBA tasks and tools
      Plan an Oracle installation
      Use optimal flexible architecture
      Install software with the Oracle Universal Installer (OUI)
      Creating an Oracle Database
      Create a database with the Database Configuration Assistant (DBCA)
      Create a database design template with the DBCA
      Generate database creation scripts with the DBCA
      Managing the Oracle Instance
      Start and stop the Oracle database and components
      Use Enterprise Manager (EM)
      Access a database with SQL*Plus and iSQL*Plus
      Modify database initialization parameters
      Understand the stages of database startup
      View the Alert log
      Use the Data Dictionary
      Managing Database Storage Structures
      Describe table data storage (in blocks)
      Define the purpose of tablespaces and data files
      Understand and utilize Oracle Managed Files (OMF)
      Create and manage tablespaces
      Obtain tablespace information
      Describe the main concepts and functionality of
  • Automatic Storage Management (ASM)
      Administering User Security
      Create and manage database user accounts
      Authenticate users
      Assign default storage areas (tablespaces)
      Grant and revoke privileges
      Create and manage roles
      Create and manage profiles
      Implement standard password security features
      Control resource usage by users
  • Managing Schema Objects
      Define schema objects and data types
      Create and modify tables
      Define constraints
      View the columns and contents of a table
      Create indexes, views and sequences
      Explain the use of temporary tables
      Use the Data Dictionary
      Manage data through SQL
      Monitor and resolve locking conflicts
  • Managing Undo Data
      Explain DML and undo data generation
      Monitor and administer undo
      Describe the difference between undo and redo data
      Configure undo retention
      Guarantee undo retention
      Use the undo advisor
      Implementing Oracle Database Security
      Describe DBA responsibilities for security
      Apply the principal of least privilege
      Enable standard database auditing
      Specify audit options
      Review audit information
      Maintain the audit trail
  • Incomplete Recovery
      Recovery Steps
      Server and User Managed Recovery commands
      Recovering a Control File Autobackup
      Creating a New Control File
      Incomplete Recovery Overview
      Incomplete Recovery Best Practices
      Simplified Recovery Through RESETLOGS
      Point-in-time recovery using RMAN
  • Flashback
      Flashback Database Architecture
      Configuring and Monitoring Flashback Database
      Backing Up the Flash Recovery Area
      Using V$FLASH_RECOVERY_AREA_USAGE
      Flashback Database Considerations
      Using the Flashback Database RMAN interface
      Using Flashback Database EM Interface
  • Managing and monitoring Flashback Database operations
      Dealing with Database Corruption
      Block Corruption Symptoms: ORA-1578
      DBVERIFY Utility and the ANALYZE command
      Initialization parameter DB_BLOCK_CHECKING
      Segment Metadata Dump and Verification
      Using Flashback for Logical Corruption and using DBMS_REPAIR
      Block Media Recovery
      RMAN BMR Interface
      Dumping and Verifying Segment Metadata
      Monitoring and Managing Storage I
      Database Storage Structures
      Space Management Overview
      Oracle-Managed Files (OMF)
      Row Chaining and Migrating
      Proactive Tablespace Monitoring
      Managing Resumable Space Allocation
      SYSAUX Tablespace
      Monitoring table and index space usage
      Monitoring and Managing Storage II
      Automatic Undo Management
      Redo Log Files
      Table Types
      Partitioned Tables
      Index-Organized Tables (IOT)
      Managing index space with SQL
      Configure optimal redo log file size
      View “Automatic Tuning of Undo Retention”
      VLDB Support
      Creating Big file Table spaces
      Packages and data dictionary changes to support VLDB
      Creating and maintaining temporary table space groups (TTG)
      Partitioning and Partitioned Indexes
      Skipping unusable indexes
      DML Error Logging
      Interpreting Big file ROWIDs
      Automating Tasks with the Scheduler
      Scheduler Concepts
      Creating a Job Class and a Window
      Managing Jobs, Programs, Chains, Events, Schedules, priority
      Viewing and Purging Job Logs
      Creating a program and a schedule
      Creating a job that uses a program and a schedule
  • Configuring the Oracle Network Environment
      Create additional listeners
      Create Net Service aliases
      Configure connect-time failover
      Control the Oracle Net Listener
      Test Oracle Net connectivity
      Identify when to use shared versus dedicated servers
      Backup and Recovery Concepts
      Identify the types of failure that may occur in an Oracle Database
      Describe ways to tune instance recovery
      Identify the importance of checkpoints, redo log files, and archived log files
      Configure ARCHIVELOG mode
      Performing Database Backups
      Create consistent database backups
      Back your database up without shutting it down
      Create incremental backups
      Automate database backups
      Monitor the flash recovery area
      Performing Database Recovery
      Recover from loss of a control file
      Recover from loss of a redo log file
      Perform complete recovery following the loss of a data file
      Performing Flashback
      Describe Flashback database
      Restore the table content to a specific point in the past with Flashback Table
      Recover from a dropped table
      View the contents of the database as of any single point in time with Flashback Query
      See versions of a row over time with Flashback Versions Query
      View the transaction history of a row with Flashback Transaction Query
      Moving Data
      Describe available ways for moving data
      Create and use directory objects
      Use SQL*Loader to load data from a non-Oracle database (or user files)
      Explain the general architecture of Data Pump
      Use Data Pump Export and Import to move data between Oracle databases
      Use external tables to move data via platform-independent files
      Configuring Recovery Manager
      Recovery Manager Features and Components
      Using a Flash Recovery Area with RMAN
      Configuring RMAN
      Control File Autobackups
      Retention Policies and Channel Allocation
      Using Recovery Manager to connect to a target database in default NOCATALOG mode
      Displaying the current RMAN configuration settings
      Altering the backup retention policy for a database
      Altering the program and schedule for the job and observing the behavior change of the job
      Monitoring job runs
  • Using Recovery Manager
      RMAN Command Overview
      Parallelization of Backup Sets
      Compressed Backups
      Image Copy
      Whole Database and Incremental Backups
      LIST and REPORT commands
      Enable ARCHIVELOG mode for the database
      Use Recovery Manager
      Recovering from Non-critical Losses
      Recovery of Non-Critical Files
      Creating New Temporary Tablespace
      Recreating Redo Log Files, Index Tablespaces, and Indexes
      Read-Only Tablespace Recovery
      Authentication Methods for Database Administrators
      Loss of Password Authentication File
      Creating a new temporary tablespace
      Altering the default temporary tablespace for a database

ORACLE DBA COURSE CURRICULUM


INTRODUCTION

As business operations become more complex, the demand for change in IT increases accordingly, as do the associated risks that must be mitigated. Todays IT professionals are asked to manage more information and deliver it to their users, with ever-increasing quality of service, in a timely manner. And in todays economic climate, IT must also reduce budgets and derive greater value out of existing investments.

Oracle Database 11g Release 2, the latest release of the award-winning Oracle Database 11g, enables IT professionals to deliver more information with higher quality of service, make more-efficient use of their budgets, and reduce the risk of change in datacenters. By deploying Oracle Database 11g Release 2 as their data management foundation, organizations can utilize the full power of the worlds leading database to

    • Reduce server costs by a factor of 5
    • Reduce storage requirements by a factor of 10
    • Improve mission-critical system performance by a factor of 10
    • Increase DBA and developer productivity by a factor of 2
    • Maximize availability and eliminate idle redundancy
    • Maximize security and enable compliance
    • Simplify their overall IT software portfolio

Oracle Database Appliance

The Oracle Database Appliance is a new way to take advantage of the world’s most popular database Oracle Database 11g in a single, easy-to-deploy and manage system. It’s a complete package of software, server, storage, and networking that’s engineered for simplicity; saving time and money by simplifying deployment, maintenance, and support of database workloads.

A fully integrated and redundant system of software, servers, storage and networking in a single box that delivers high-availability database services for a wide range of homegrown and packaged online transaction processing (OLTP) and data warehousing applications Saves up to 2000 hours of labor over a three year period with simple deployment, maintenance, and support of database workloads, all supported by a single vendor Oracle
Pay-As-You-Grow software licensing allows you to quickly scale from 2 processor cores to 24 processor cores without incurring the costs and downtime usually associated with hardware upgrades Allows businesses to consolidate OLTP and data warehousing databases up to 4 terabytes in size, making it ideal for midsize companies and departmental systems

An Oracle core database as nothing more than a large electronic filing cabinet, a place to store and retrieve information. At the computer level, Oracle is a computer program that manages an electronic filing cabinet.

Oracle Platform Concepts

One reason that Oracle has become the world dominant database is because it runs on just about every platform imaginable, from a mainframe to a Macintosh.

Today, most shops run Oracle in UNIX, Linux, and Windows.

Oracle runs on almost every computer ever made, with over 60 diverse platforms such as Intel (like your PC does), Sun Solaris, old IBM mainframes, and many, many others.

Conceptually, Oracle is considered the worlds most powerful, flexible and robust database. Along with this power comes complexity.

Oracle flexibility concepts database and it stores much more than text and numbers. An Oracle database support video, audio and complex spatial applications that are used to build jet fighters and submarines.

Unlike simpler databases, you can control every aspect of Oracles behavior. You can control how rows are placed on the data blocks and you can control how Oracle performs hundreds of resource management issues.

Oracle Database 11g helps customers lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds and engineered systems like Oracle Exadata and Oracle Database Appliance. It’s proven to be fast, reliable, secure and easy to manage for all types of database workloads including enterprise applications, data warehouses and big data analysis.

Feature

Simplifies deployment, maintenance, and support of high-availability database workloads

An engineered system of software, server, storage, and networking Simple one-button Installation, full-stack integrated patching and diagnostics Built using the worlds #1 database Unique Pay-As-You-Grow software licensing

Benefit

Saves significant time and effort throughout the database administration lifecycle High availability for a wide range of custom and packaged OLTP and data warehousing application databases Reduces planned and unplanned downtime by automatically monitoring and logging service requests with Oracle Support Protects databases from server and storage failures with Oracle Real Application Clusters and Automatic Storage Management Reduces cost with flexibility to adjust your software spend as your business grows without the need for any hardware upgrades

Oracle Core DBA Responsibilities

  • (1) Creates and maintains all databases required for development, testing, education and production usage.
  • (2) Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.
  • (3) Performs ongoing tuning of the database instances.
  • (4) Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
  • (5) Plans and implements backup and recovery of the Oracle database.
  • (6) Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
  • (7) Implements and enforces security for all of the Oracle Databases.
  • (8) Performs database re-organisations as required to assist performance and ensure maximum uptime of the database.
  • (9) Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
  • (10) Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
  • (11) Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation.
  • (12) Enforces and maintains database constraints to ensure integrity of the database.
  • (13) Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
  • (14) Assists with impact analysis of any changes made to the database objects.
  • (15) Troubleshoots with problems regarding the databases, applications and development tools.
  • (16) Create new database users as required.
  • (17) Manage sharing of resources amongst applications.
  • (18) The DBA has ultimate responsibility for the physical database design.

DEMOS VIDEOS

UPCOMING DEMOS

For updated Schedules please contact

calls