Təlimə qatılmaq üçün tələblər
- Başlanğıc ( texniki ) səviyyə ingilis və rus dili biliyi
Təlimin müddəti
- Oracle Database SQL Adminsitration kursunun ümumi tədris müddəti: 5 ay həftədə 2 dəfə 2 saat olmaqla keçirilir.(Qeyd: Əhatə edir -Fundamental,Administrator səviyyəsi -1,Administrator səviyyəsi-2)
Kimlər iştirak edə bilər?
- Tələbələr,hazırda işləyənlər
1.Introduction to the Oracle Server Technologies
2.Exploring the Database Architecture
3.Preparing the Database Environment
4.Creating an Oracle Database
5.Managing the Oracle Instance
6.Configuring the Oracle Network Environment
7.Managing Database Storage Structures
8.Administering User Security
9.Managing Schema Objects
10.Managing Data and Concurrency
11.Managing Undo Data
12.Implementing Oracle Database Security
13.Database Maintenance
14.Performance Management
15.Backup and Recovery Concepts
16.Performing Database Backups
17.Performing Database Recovery
18.Moving Data
19.Intelligent Infrastructure Enhancements
1.Using Oracle ASM
What Is ASM?
Working with the ASM Instance
Overview of ASM Data Dictionary Views
Using ASM Storage
Using RMAN with ASM
2.Performing Oracle User-Managed Backups
Understanding the Oracle Database as It Relates to Backup and Recovery
Configuring the Database for Backup and Recovery
Performing Oracle Offline Backups
Performing Oracle Online Backups
Backing Up the Control File
3.Performing Oracle User-Managed Database Recoveries
Performing a Recovery in NOARCHIVELOG Mode
Performing a Full Database Recovery in ARCHIVELOG Mode
Performing Incomplete Recoveries
Performing Other Types of Recoveries
4.Configuring and Backing Up Using RMAN
Why Use RMAN?
Exploring the RMAN Architecture
Connecting to RMAN
Configuring RMAN for Use
Backing Up Your Database with RMAN
5.Using the RMAN Recovery Catalog
Introducing the Recovery Catalog
Creating the Recovery Catalog User and Schema Objects
Using a Recovery Catalog
Using Scripts in the RMAN Recovery Catalog
Maintaining the Recovery Catalog
Using the RMAN Virtual Private Catalog
6.Recovering Databases with RMAN
RMAN Database-Recovery Basics
Recovering a Database in NOARCHIVELOG Mode
Recovering a Database in ARCHIVELOG Mode
Recovering a Database Using Incomplete Recovery
Using Image Copies to Recover Your Database
Other Basic Recovery Topics
7.Reporting, Monitoring, and Tuning with RMAN
Overview of the RMAN Report and List Commands
Monitoring, Administering, and Tuning RMAN
8.Performing Oracle Advanced Recovery
Switching Between RMAN Incarnations
Overview of RMAN Database Duplication
Performing an RMAN Tablespace Point-in-Time Recovery
9.Understanding Flashback Technology
Overview of Flashback Technology
Using Automatic Undo Management
Using Flashback Technologies
Using Additional Flashback Operations
10.Diagnosing the Database and Managing Performance
Diagnosing the Database
Managing Database Performance
11.Managing Database Resources
Managing Memory
Managing Space
Managing Resources
12.Using the Scheduler to Automate Tasks
Automating Tasks with the Scheduler
Exploring the Scheduler Architecture
Exploring Common Administration Tools
Using Scheduler Jobs
13.Implementing Globalization Support
An Overview of Globalization Support
Using NLS Parameters
Using Datetime Datatypes
Using Linguistic Sorts and Searches
14.Oracle Utilities
Moving Data, Performing Security Operations, and Interacting with Other Oracle Products
Using Data Pump
15.Creating Oracle Multitenant Databases
Multitenant Container and Pluggable Database Architecture
Creating Multitenant Container Databases and Pluggable Databases
16.Managing Oracle Multitenant Databases
Establishing Connections to CDB/PDB
Start Up and Shut Down a CDB and Open and Close PDBs