Data Base Administrator (DBA)


Book this course Online now & get 10% Discount on Course Fee


Course contents:


ORACLE DBA – CORE


PART -1 ( Fundamental – 1)


  • Creating an Oracle Database
  • Database Architecture
  • Exploring the Storage Structure
  • Control Files
  • Redo Log Files
  • Tablespaces and Datafiles
  • Segments, Extents, and Blocks
  • Oracle Instance Management
  • Oracle Memory Structures
  • Oracle Processes
  • Data Dictionary
  • Database Control
  • Grid Control
  • Database Configuration Assistant (DBCA) Overview
  • Creating a Database
  • Passwords and Storage
  • File Locations and Backup Recovery
  • Content and Initialization Parameters
  • Other Actions with DBCA
  • Managing the Database
  • Starting and Stopping iSQL*Plus
  • Starting and Stopping Database Control
  • Accessing Database Control
  • SYSOPER and SYSDBA
  • Database Home Page
  • Changing the Listener Status
  • NOMOUNT MOUNT OPEN States
  • SHUTDOWN Options
  • Initialization Parameter Files
  • Viewing the Alert Log
  • Net Services
  • Oracle Net Services
  • Oracle Net Listener
  • Monitoring the Listener
  • Listening Addresses
  • Static Database Registration
  • Listener Control Utility
  • Oracle Net Connections
  • Directory Naming
  • Advanced Connections
  • Oracle Net Manager
  • Configuring Service Aliases with Net Manager
  • Managing Schema Objects
  • Schemas
  • Accessing Schema Objects
  • Schema Object Namespaces
  • Specifying Data Types in Tables
  • Other Data Types
  • Creating and Modifying Tables
  • Understanding Data Integrity
  • Defining Constraints
  • Viewing the Attributes of a Table
  • Viewing the Contents of a Table
  • Creating Indexes
  • Creating Views
  • Using a Sequence
  • Storage Structures
  • Tablespaces and Data Files
  • Space Management in Tablespaces
  • Storage for Locally Managed Tablespaces
  • Altering a Tablespace
  • Actions with Tablespaces
  • Dropping Tablespaces
  • Viewing Tablespace Information
  • Administering Users
  • Database User Accounts
  • Creating a User
  • Profiles and Users
  • Authenticating Users
  • Database Users and Schemas
  • Privileges : System and Object
  • Roles
  • Assigning Quota to Users
  • Assigning Roles to Users
  • Data Pump Export
  • Data Pump Import
  • DIRECTORY Objects
  • SQL*Loader
  • The SQL*Loader Control File
  • Control File Syntax Considerations
  • Input Data and Data Files
  • Loading Methods
  • Comparing Direct and Conventional Path Loads
  • Loading Data with SQL*Loader
  • External Tables
  • Undo Management


ENQUIRY FORM