Oracle 11g DBA Training Course Content

Spread the love

Oracle 11g DBA Training Course Content Details

What is Oracle 11g DBA

In this Oracle information oneg DBA 1 1Z0-052 course, trainer Tim Warner can teach you the way to put in and administer Oracle 11g informationbases from scratch and make sure the integrity and security of your organization’s data.
Every organization has data that it should store and manage to fulfill its needs. as an example, a companyshould collect and maintain human resources records for its staff. This data should be out there to those thatwant it. AN system could be a formal system for storing and process data.

Oracle database 11g training in hyderabd kukatpally

Oracle database 11g training in hyderabd kukatpally

An system might be a collection of cardboard boxes containing manila folders beside rules for the way to store and retrieve the folders. However, most corporations these days use a information to change their data systems. A information is AN organized assortment of data treated as a unit. the aim of a information is to gather, store, and retrieve connected data to be used by information applications.
Become your company’s information immortal. Tim Warner’s course even shows you the way to use your existing SQL Server, MySQL, or DB2 skills on to Oracle platforms! when looking, you will be able to pass the Oracle 1Z0-052 test, and you will have the vocab, expertise and confidence you wish to impress hiring managers and purchasers. for more info click here



Oracle 11g DBA Course Content

01.ENTERPRISE EDITION INSTALLATION

  • IDENTIFY SYSTEM REQUIREMENTS
  • THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
  • ORACLE_BASE
  • ORACLE_HOME
  • CONFIGURE THE INSTALLATION ENVIRONMENT
  • ENTERPRISE EDITION INSTALLATION • DBCA

02.THE ADMINISTRATOR INTERFACE

  • ENTERPRISE MANAGER TOUR
  • USING EM SQL WORKSHEET
  • DUTIES OF A DATABASE ADMINISTRATOR
  • EXPLORING THE ORACLE DATABASE
  • ARCHITECTURE: GENERAL
  • THE ORACLE ENTERPRISE ARCHITECTURE

03.EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY

  • WHAT IS AN ORACLE DATABASE INSTANCE?
  • MORE ABOUT THE SYSTEM GLOBAL AREA (SGA)
  • ABOUT THE PGA
  • MANAGING MEMORY

04.EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES

  • INSTANCE BACKGROUND PROCESSES
  • SQL EXECUTION PROCESSES

05.CREATING AN ORACLE DATABASE

  • CREATE A NEW DATABASE
  • CONFIGURE AN EXISTING DATABASE
  • DROP A DATABASE
  • MANAGE DBCA TEMPLATES
  • MANUALLY CREATE A DATABASE

06.MANAGING THE DATABASE INSTANCE

  • CONFIGURING A LINUX ENVIRONMENT
  • STARTING & STOPPING DATABASE CONTROL
  • STARTING & STOPPING THE DATABASE LISTENER
  • STARTING & STOPPING THE DATABASE INSTANCE
  • MORE ABOUT THE DATABASE FILES

    07.MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES

  • ABOUT TABLESPACES
  • TABLESPACE MANAGEMENT
  • DROP TABLESPACE
  • ALTER TABLESPACE

08.MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACEs

  • MORE ABOUT TEMPORARY TABLESPACES
  • ABOUT TEMPORARY TABLESPACE GROUPS
  • MORE ABOUT PERMANENT TABLESPACES
  • MORE ABOUT BIGFILE TABLESPACES
  • MORE ABOUT THE SYSAUX TABLESPACE

09.MANAGE DATABASE STORAGE STRUCTURES

  • DATA FILES & TEMP FILES
  • MANAGING DATA FILES
  • MANAGING TEMP FILES
  • ENABLE ORACLE-MANAGED FILES (OMF)




10.MANAGING UNDO DATA

  • ABOUT UNDO SPACE MANAGEMENT
  • CONFIGURE AUTOMATIC UNDO MANAGEMENT
  • UNDO_MANAGEMENT
  • UNDO_TABLESPACE
  • UNDO_RETENTION
  • GUARANTEE UNDO RETENTION
  • MONITOR UNDO SPACE
  • USE THE UNDO ADVISOR

11.NETWORK ENVIRONMENT: ORACLE SHARED SERVERS

  • SHARED SERVERS ARCHITECTURE
  • CONFIGURE SHARED SERVERS
  • MONITOR SHARED SERVERS
    V$SHARED_SERVER
  • V$SHARED_SERVER_MONITOR
  • V$SESSION
  • V$CIRCUIT
  • V$DISPATCHER & V$DISPATCHER_CONFIG
  • V$QUEUE

12.SECURITY: IMPLEMENTING DATABASE SECURITY

  • DATABASE SYSTEM PRIVILEGES
  • DATABASE OBJECT PRIVILEGES
  • ADMINISTRATOR AUDITING OF DATABASE ACTIVITY
  • ENHANCED DEFAULT SECURITY SETTINGS

13.SECURITY: ADMINISTERING USER SECURITY

  • CREATE & MANAGE DATABASE ACCOUNTS
  • GRANT & REVOKE DATABASE PRIVILEGES
  • RESOURCE LIMITS VIA PROFILES
  • ALTER PROFILE
  • DROP PROFILE
  • PASSWORD MANAGEMENT VIA PROFILES
  • ABOUT ROLE-BASED SECURITY
  • WITH ADMIN OPTION
  • ALTER USER…DEFAULT ROLE
  • SET ROLE
  • ENHANCED DEFAULT SECURITY SETTINGS

14.MOVING DATA: SQL LOADER

  • LOADER CONCEPTS
  • CONTROL FILE OPTIONS
  • LOAD METHODS
  • USING THE EM INTERFACE

15.MOVING DATA: EXPORT & IMPORT

  • MANAGE DIRECTORY OBJECTS
  • ABOUT THE DATA PUMP ARCHITECTURE
  • DATA PUMP EXPORT
  • DATA PUMP IMPORT
  • DATA PUMP DATA DICTIONARY VIEWS
  • USING THE EM INTERFACE MANAGEMENT

16.DATABASE MAINTENANCE & PERFORMANCE

  • THE MANAGEMENT & ADVISORY FRAMEWORK
  • MANAGE THE AUTOMATIC WORKLOAD REPOSITORY
  • AUTOMATIC DATABASE DIAGNOSTIC MONITOR
  • USE METRICS & ALERT THRESHOLDS
  • AUTOMATIC MAINTENANCE TASKS

17.MANAGING CONCURRENCY & LOCKS

  • ABOUT LATCHES & LOCKS
  • MANAGE & MONITOR LATCHES
  • MANAGE & MONITOR LOCKS
  • V$LOCK
  • V$LOCKED_OBJECT
  • V$SESSION
  • V$SESSION_WAIT
  • DBA_BLOCKERS & DBA_WAITERS
  • DBA_DML_LOCKS & DBA_DDL_LOCKS
  • DML_LOCKS

18.BACKUP & RECOVERY CONCEPTS & CONFIGURATION

  • ABOUT DATABASE BACKUP & RECOVERY STRUCTURES
  • MANAGING REDO DATA
  • MANAGING ARCHIVAL DATA
  • AUTOMATIC CRASH RECOVERY
  • CREATING A BASIC BACKUP STRATEGY




Oracle 11g DBA Training Demo

Contact Us for Oracle 11g DBA Online and classroom training

venkat: 9059868766
email:[email protected]
Address: PlotNo 126/c,2nd floor,Street Number 4, Addagutta Society, Jal Vayu Vihar, Kukatpally, Hyderabad, Telangana 500085

Sharing is caring!

Updated: May 11, 2017 — 10:13 am

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.