best oracle DBA online training | oracle DBA training Tutorial - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

best oracle DBA online training | oracle DBA training Tutorial

Description:

Ithubonlinetraining offers oracle DBA online training. Our testing gear path content designed as in line with the modern-day IT industry requirement. We’ve trained many college students on testing tools. We’ve completed more than two hundred batches on testing gear on oracle DBA online training internationally. We will give Resume guidance and Placements in United States, Canada, and Singapore. Contact: India: 8121311133 contact@ithubonlinetraining.com – PowerPoint PPT presentation

Number of Views:113

less

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

Title: best oracle DBA online training | oracle DBA training Tutorial


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