1Z0-052 Oracle Database 11g : Administration 1

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)