best oracle DBA online training classes in us,uk - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

best oracle DBA online training classes in us,uk

Description:

Ithubonlinetraining facility offers finest Oracle DBA online Training. Pupils who attended Training regard as the best training in World our Oracle DBA online Training. All our pupils were able and happy to find Occupations rapidly in Europe, and USA, UK, Singapore, Japan. Every week, Oracle DBA Online Training batches begin and we adapt your flexible timings. Contact: India: 8121311133 contact@ithubonlinetraining.com – PowerPoint PPT presentation

Number of Views:22

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: best oracle DBA online training classes in us,uk


1
ORACLEDBA ONLINE TRAINING
2
Overview of Oracle Database Administration
  • What is SQL?
  • Roles Responsibilities of DBA
  • Oracle Architecture
  • Process Architecture
  • Physical and Logical structures of Database
  • Types of files(Control file,Data file)
  • Different types of Data files

3
Database Creation
  • Using Oracle Universal Installer
  • Installation Prerequisites
  • Setting Environment Variables
  • Installing the Oracle Database Software Steps
  • Using the Database Configuration Assistant (DBCA)
  • Different Startup Modes
  • Different Shutdown Modes
  • Types of Database Creation

4
Configuring the Oracle Network Environment 
  • Tools for Configuring and Managing the Oracle
    Network
  • Using the Listener Control Utility
  • Connecting to an Oracle Database
  • Oracle Net Naming Methods
  • Using Oracle Net Manager to Configure Local
    Naming
  • Tnsnames.ora
  • Network default location
  • Introduction to Database Links

5
(No Transcript)
6
Managing the Oracle Instance
  • Oracle Instance Management
  • Oracle Processes
  • Oracle Memory Structures
  • Starting the Instance and Opening the Database
  • Shutting Down an Oracle Database Instance
  • Viewing and Modifying Initialization Parameters
  • Managing Memory Components
  • Viewing the Alert Log

7
Storage Parameters
  • Oracle Database Structures
  • Exploring the Storage Structure of the Oracle
    Database
  • What are segments?
  • What are extents?
  • What is Blocks?
  • Dictionary Managed Table space
  • Locally Managed Table space
  • Storage Parameters(Initial, Next, Min Extents,
    Pctincrease)
  • Managing Undo Data

8
(No Transcript)
9
SPFile PFile Managment
  • What is sp file?
  • Difference between sp file and p file
  • Advantages of sp file

10
CONTACTINDIA8121311133 http//www.ithubonlinetr
aining.com/oracle-dba-online-training/ CONTACT_at_ITH
UBONLINETRAINING
About PowerShow.com