Are you looking for best DBA training to begin your career as Oracle DBA? This course will help you to learn basics of Oracle database administration. It covers SQL fundamentals, Linux basics and Administration-I theoretical concepts and practical’s.

Get hands-on experience on standalone Oracle Database environment now.

  • Install and Implement yourself.
  • Simple and easy to understand.
  • Meet industry standards.

System requirements:

  • Laptop/Desktop with at least 3GB RAM.
  • Minimum of Dual Core processor.
  • 40 GB of disk space.

Training details:

  • 31 Sessions.
  • Trainer: Pawan Kumar Yaddanapudi.
  • Includes supporting documents, software’s and Log files.
  • Anytime assistance.

Demo Video:

Pick your mode of learning:

Video tutorials:

  • Learn at your own pace.
  • Saves 50% of your money.
  • Revise any number of times for 6 months.
  • Assured quality and content as classroom/online training.

Online training:

  • One scheduled session per day.
  • Good internet connectivity required.
  • Batch of minimum 5 students.

Click Here for Online Training Schedule

Course Content

SQL Fundamentals-I

  1. Introduction
    • Oracle XE installation for SQL practice
    • Oracle account creation
    • Connecting to XE instance
  2. Retrieving Data Using the SQL SELECT Statement
    • Basic SELECT statement
    • Arithmetic expressions and NULL values in the SELECT statement
    • Column aliases
    • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
    • Remove DUPLICATE rows
    • DESCRIBE command
  3. Restricting and Sorting Data
    • Limit the rows that are retrieved by a query
    • Sort the rows that are retrieved by a query
    • Use ampersand substitution to restrict and sort output at run time
  4. Using Single-Row Functions to Customize Output
    • Describe various types of functions available in SQL
    • Use character, number, and date functions in SELECT statements
  5. Using Conversion Functions and Conditional Expressions
    • Implicit and explicit data type conversion
    • TO_CHAR, TO_DATE, TO_NUMBER functions
    • Nesting functions
    • General functions
    • Conditional expressions
  6. Group functions
    • Types and syntax
    • Use AVG, SUM, MIN, MAX, COUNT
    • Use DISTINCT keyword within group functions
    • NULL values in a group function
    • Grouping rows:
    • GROUP BY clause
    • HAVING clause
    • Nesting group functions
  7. Displaying Data from Multiple Tables
    • Types of JOINS and its syntax
    • Natural join:
    • USING clause
    • ON clause
    • Self-join
    • Nonequijoins
    • OUTER join:
    • LEFT OUTER join
    • RIGHT OUTER join
    • FULL OUTER join
    • Cartesian product
    • Cross join
  8. Using Subqueries to Solve Queries
    • Subquery: Types, syntax, and guidelines
    • Single-row subqueries:
    • Group functions in a subquery
    • HAVING clause with subqueries
    • Multiple-row subqueries
    • Use ALL or ANY operator
    • Null values in a subquery
  9. Set Operators
    • Types and guidelines
    • Tables used in this lesson
    • UNION and UNION ALL operator
    • INTERSECT operator
    • MINUS operator
    • Matching the SELECT statements
    • Using the ORDER BY clause in set operations
  10. Manipulating Data
    • Adding new rows in a table
    • INSERT statement
    • Changing data in a table
    • UPDATE statement
    • Removing rows from a table:
    • DELETE statement
    • TRUNCATE statement
    • Database transactions control using COMMIT, ROLLBACK, and SAVEPOINT
    • Read consistency
    • FOR UPDATE clause in a SELECT statement
  11. Using DDL Statements to Create and Manage Tables
    • Database objects
    • Naming rules
    • CREATE TABLE statement:
    • Access another user’s tables
    • DEFAULT option
    • Data types
    • Overview of constraints: NOT NULL, PRIMARY KEY
    • FOREIGN KEY, CHECK constraints
    • Creating a table using a subquery
    • ALTER TABLE
    • Read-only tables
    • DROP TABLE statement
  12. Other Database objects
    • Overview of views
    • Creating, modifying, and retrieving data from a view
    • DML operations on a view
    • Dropping a view
    • Overview of sequences
    • Creating, using, and modifying a sequence
    • Cache sequence values
    • NEXTVAL and CURRVAL pseudocolumns
    • Overview of indexes
    • Creating, dropping indexes
    • Overview of synonyms
    • Creating, dropping synonyms

LINUX – BASICS

  1. Linux Installation
    • Installation of software to install virtual servers.
    • Installation of Enterprise Linux – Compatible to Oracle.
    • Configure Putty.
  2. Linux Commands
    • List all the LINUX/UNIX commands DBA needs.
    • Understand the functionality of each command.

ORACLE DATABASE ADMINISTRATION

  1. Install Oracle database
  • Softwares introduction
  • Network configuration
  • Install OS – pre requisites
  • Install Oracle software
  • Install oracle network configuration
  • Install oracle database
  • purpose of oraenv and /etc/oratab
  • purpose of /etc/oratab file
  1. Oracle database Architecture
  • Connecting to a Server
  • Oracle Database Architecture: Overview
  • Connecting to the Database
  • Interacting with an Oracle Database
  • Oracle Database Server Structures
  • Oracle Database Memory Structures
  • Database Buffer Cache
  • Redo Log Buffer
  • Shared Pool
  • Allocation and Reuse of Memory in the Shared Pool
  • Large Pool
  • Java Pool and Streams Pool
  • Process Architecture
  • Oracle Background processes in DETAIL
  • Redo Cycle
  • Other background processes
  • Server process and buffer cache
  1. Storage Architecture
  • Introduction to Storage architecture
  • Logical and Physical Database Structures
  • Tablespaces and Data Files
  • SYSTEM and SYSAUX Tablespaces
  • Segments, Extents, and Blocks
  1. Initialization Parameter Files
  • Simplified Initialization Parameters
  • SPFILE
  • PFILE
  • Change dynamic and static parameters with SPFILE
  • Change dynamic and static parameters with PFILE
  • Create spfile from pfile
  • create pfile from spfile
  1. Start/Stop and Log files
  • Database Startup and Shutdown
  • Startup Options: Examples
  • Shutdown Options
  • Shutdown Options: Examples
  • Viewing the Alert Log
  • Using Trace Files
  • Dynamic Performance Views
  • Data Dictionary
  1. Configuring the Oracle Network Environment
  • Oracle Net Services
  • Oracle Net Listener
  • Establishing Net Connections
  • Establishing a Connection
  • User Sessions
  • Tools for Configuring and Managing the Oracle Network
  • Listener Control Utility
  • Changing Listener NAME
  • Database Service Registration
  • Naming methods
  • Local Naming
  • Directory Naming
  • External Naming Method
  • Testing Oracle Net Connectivity
  • User Sessions: Dedicated Server
  • Configuring Communication Between Databases
  1. Managing Database Storage Structures
  • Storage Structures
  • How Table Data Is Stored
  • Database Block: Contents
  • Tablespaces and Data Files
  • Space Management in Tablespaces
  • Creating a New Tablespace
  • Tablespaces in the Preconfigured Database
  • Altering a Tablespace
  • SMALLFILE and BIGFILE TABLESPACES
  • Actions with Tablespaces
  • Dropping Tablespaces
  • Viewing Tablespace Information
  • Gathering Storage Information
  • Viewing Tablespace Contents
  • Oracle Managed Files (OMF)
  • Enlarging the Database
  • Automatic Storage Management
  • ASM: Key Features and Benefits
  1. Administering User Security
  • Database User Accounts
  • Predefined Accounts: SYS and SYSTEM
  • Creating and drop a User
  • Administrator Authentication
  • Unlocking a User Account and Resetting the Password
  • Reset password with HASH value
  • System Privileges
  • Object Privileges
  • Revoking System Privileges
  • Revoking Object Privileges
  • Benefits of Roles
  • Creating a Role and Assigning Roles to Users
  • Profiles and Users
  • Implementing Password Security Features
  • Creating a Password Profile
  • Supplied Password Verification Function:VERIFY_FUNCTION_11G
  • Assigning Quotas to Users
  1. Managing Data and Concurrency
  • Manipulating Data by Using SQL
  • COMMIT and ROLLBACK Commands
  • PL/SQL
  • Administering PL/SQL Objects
  • PL/SQL Objects
  • Functions
  • Procedures
  • Packages
  • Built-in Packages
  • Triggers
  • Triggering Events
  • Locks
  • Locking Mechanism
  • Data Concurrency
  • DML Locks
  • Enqueue Mechanism
  • Lock Conflicts
  • Possible Causes of Lock Conflicts
  • Detecting Lock Conflicts
  • Resolving Lock Conflicts
  • Deadlocks
  1. Managing Undo Data
  • Data Manipulation
  • Undo Data
  • Transactions and Undo Data
  • Storing Undo Information
  • Undo Data Versus Redo Data
  • Managing Undo
  • Configuring Undo Retention
  • Guaranteeing Undo Retention
  • Changing an Undo Tablespace to a Fixed Size
  1. Database Maintenance & Performance Management
  • Terminology
  • Oracle Optimizer: Overview
  • Optimizer Statistics
  • Statistic Levels
  • Preferences for Gathering Statistics
  • Automatic Workload Repository(AWR)
  • AWR Infrastructure
  • Baselines
  • Managing the AWR
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework
  • Automated Maintenance Tasks
  • Performance Monitoring
  • Managing Memory Components
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects
  1. Backup and Recovery Concepts
  • Part of Your Job
  • Categories of Failure
  • Statement Failure
  • User Process Failure
  • Network Failure
  • User Error
  • Instance Failure
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Media Failure
  • Configuring for Recoverability
  • Configuring the Flash Recovery Area
  • Multiplexing Control Files
  • Redo Log Files
  • Archive Log Files
  • Enabling ARCHIVELOG Mode
  1. Performing Database Backups
  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Terminology
  • Differential Incremental level 1
  • Cumulative Incremental level 1
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Managing Backups
  • Viewing Backup Reports
  • Monitoring the Flash Recovery Area
  1. Performing Database Recovery
  • Keeping a Database Open
  • Data Recovery Advisor
  • Data Failure: Examples
  • Data Recovery Advisor Views
  • Loss of a Control File
  • Loss of a Redo Log File
  • Loss of a Data File in NOARCHIVELOG Mode
  • Loss of a Noncritical Data File in ARCHIVELOG Mode
  • Loss of a System-Critical Data File in ARCHIVELOG Mode
  1. Moving Data
  • Moving Data: General Architecture
  • Directory Objects: Overview
  • Creating Directory Objects
  • SQL*Loader: Overview
  • Loading Data with SQL*Loader
  • SQL*Loader Control File
  • Loading Methods
  • External Table Population
  • Using External Tables
  • Oracle Data Pump: Overview
  • Oracle Data Pump: Benefits
  • Data Pump Export and Import: Overview
  • Data Pump Utility: Interfaces and Modes
  • Data Pump Import
  • Data Pump Import: Transformations
  • Data Pump: Performance Considerations
  • Performance Initialization Parameters
  1. Working With Support
  • Using the Support Workbench
  • Creating a Service Request
  • Packaging and Uploading Diagnostic Data to Oracle Support
  • Working with Oracle Support
  • MetaLink Integration
  • Using MetaLink
  • Researching an Issue
  • Logging Service Requests
  • Managing Patches
  • Applying a Patch Release – SPU patch example
  • Identify list of patches installed
  • Find OPatch version