Kurset e trajnimit‎ > ‎Oracle‎ > ‎

1Z0-052 Oracle Database 11g : Administration 1


Permbajtja






Kohezgjatja e kursit

Kursi eshte i organizuar ne 24 ore mesimore dhe zhvillohet ne nje periudhe 1-2 Muaj.

Zhvillohet dy deri ne tre here ne jave,me nga dy ore, kryesisht ne oraret e pasdites. 

 

Organizimi i kursit

Kursi zhvillohet ne laborator dhe eshte i orientuar nga praktika. 

Zhillohet me nje numer te kufizuar pjesemarresish, ku secili punon ne nje kompjuter te vetem.

Leksionet e trajnimit jane edhe on-line.

 

Certifikimi

  • ICT Education

 

Provim nr

  • 1Z0-052



Programi i kursit


Module1: Exploring the Oracle Database Architecture

  • Explain the Memory Structures
  • Describe the Process Structures
  • Overview of Storage Structures

Module 2: Preparing the Database Environment

  • Identify the tools for Administering an Oracle Database
  • Plan an Oracle Database installation
  • Install the Oracle software by using Oracle Universal Installer (OUI)

Module 3: Creating an Oracle Database

  • Create a database by using the Database Configuration Assistant (DBCA)

Module 4: Managing the Oracle Instance

  • Setting database initialization parameters
  • Describe the stages of database startup and shutdown
  • Using alert log and trace files
  • Using data dictionary and dynamic performance views

Module 5: Configurin the Oracle Network Environment

  • Configure and Manage the Oracle Network
  • Using the Oracle Shared Server architecture

Module 6: Managing Database Storage Structures

  • Overview of tablespace and datafiles
  • Create and manage tablespaces
  • Space management in tablespaces

Module 7: Administering User Security

  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles

Module 8 : Managing Data and Concurrency

  • Monitor and resolve locking conflicts

Module 9 : Managing Undo Data

  • Overview of Undo
  • Transactions and undo data
  • Managing undo

Module 10 : Implementing Oracle Database Security

  • Database Security and Principle of Least Privilege
  • Work with Standard Database Auditing

Module 11 :Database Maintenance

  • Use Automatic Memory Management
  • Use Memory Advisors
  • Troubleshoot invalid and unusable objects

Module 12 : Intelligent Infrastructure Enhancments

  • Use the Enterprise Manager Support Workbenxh
  • Managing Patches

Module 13: Backup and Recovery Concepts

  • Identify the types of failure that can occur in an Oracle Database.
  • Describe ways to tune instance recovery
  • Identify the importance of checkpoints,redo log files and archived log files
  • Overview of flash recovery area
  • Configure ARCHIVELOG mode

Module 14: Performing Database Backups

  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Automate database backups
  • Manage backups, view backup reports and monitor the flash recovery area

Module 15: Performing Database Recovery

  • Overview of Data Recovery Advisor
  • Use Data Recovery Advisor to Perform Recovery (control file, Redo log file and Data file)

Module 16 : Moving Data

  • Use Data Pump Export and Import to move data between Oracle databases
  • Explain the general architecture of Oracle Data Pump
  • Describe and use methods to move data (Directory abjects,SQL* Loader,External Tables)