| Courses Software Training / Hardware Training | Locality Mahadevapura |
Placement Assistance Oracle DBA Training institute
-Introduction to database management systems and databases
What is a database?
Popular database management system (DBMS) software and why Oracle DBMS
History and Current trends of DBMS and Database Administration
Tasks of a Database Administrator
Introduction to DBA
Tasks of an Oracle Database Administrator
Installation of Oracle Database Software
Optimal Flexible Architecture (OFA)
Oracle Universal Installer
Prerequisite Checks
Installation
Configuration Assistants
Creating an Oracle Database
Database Architecture
Exploring the Storage Structure
Control Files
Redo Log Files
Table spaces and Data files
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
Managing Data
Data Pump Export
Data Pump Import
DIRECTORY Objects
Control File Syntax Considerations
Input Data and Data Files
Loading Methods
Comparing Direct and Conventional Path Loads
Loading Data with SQL*Loader
External Tables
Transportable tablespace
Undo Management
Undo Data
Transactions and Undo Data
Storing Undo Information
Monitoring Undo
Administering Undo
Configuring Undo Retention
Guaranteeing Undo Retention
Thanks&Regards
Elegant IT Services,
#352, 2nd Floor,Aswath Nagar
Varthur main road,Near Railway Fly Over
Maratha halli,Land mark : Chemmunar Jewellers,
Bangalore - 560037.Ph:-9886541264/87