Videos: Oracle Database 11gR2 Workshop I Course

Oracle Database 11g: Workshop I Release 2

I would like to share oracle database workshop I course, you can download and enjoy.

Asking Allah to accept it and people get benefit from that.

Course Objectives

Exploring the Oracle Database Architecture
Installing your Oracle Software
Creating an Oracle Database
Managing the Oracle Database Instance
Manage the ASM Instance
Configuring the Oracle Network Environment
Managing Database Storage Structures
Administering User Security
Managing Data Concurrency
Managing Undo Data
Implementing Oracle Database Auditing
Database Maintenance
Performance Management
Backup and Recovery Concepts
Performing Database Backups
Performing Database Recovery
Moving Data
Working with Support

Course Contents :

17 Videos cover course from chapter 1 to 18

YouTube:  http://www.youtube.com/playlist?list=PLbybFqHGEZ9FESAy_rC_kAE7Ej_7m-q33

Note: Course in Arabic 

Thanks,
Ahmed Fathi

Video & PDF : Oracle Multitenant 12c (Pluggable Database) - Online Session

Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a container database to hold many pluggable databases. And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application.

Session topics :

- Oracle Multitenant Overview
- Benefits of the Multitenant Architecture
- Pluggable database architecture
- Data Dictionary Architecture in a CDB
- Creating CDB & Pluggable Database within a CDB
- Methods to migrating pre-12.1 or 12.1 non-CDB to CDB
- Common and Local Users & Roles
- Listener and Services in a Pluggable Database Environment
- Starting/Stopping CDB Instance and Pluggable Database
- Tablespaces in PDBs
- Using the ALTER SYSTEM Statement to Modify a PDB
- Dropping a Pluggable Database
- Backup, Recovery, Flashback CDB and PDBs 

- Viewing Information About CDBs and PDBs with SQL*Plus

URL: Oracle Multitenant 12c 
YouTube:  http://www.youtube.com/watch?v=hPM4PjGKXxA&feature=share&list=PLbybFqHGEZ9GVgDvUft9y6MWW36S44V7d

Note: Video in Arabic  

Thanks,
Ahmed Fathi

Videos: Oracle Database 11gR2 Security Course

Oracle Database 11g: Security Release 2

I would like to share my last oracle database security course, you can download and enjoy.

Asking Allah to accept it and people get benefit from that.

Course Objectives

• Use basic Oracle Database security features
• Choose a user authentication model
• Secure the database and the listeners
• Use the Enterprise Security Manager tool
• Manage users using proxy authentication
• Implement Enterprise User Security
• Describe the benefits and requirements associated with the Oracle Advanced Security option
• Manage secure application roles
• Implement fine-grained access control
• Manage Virtual Private Database
• Implement fine-grained auditing
• Use Transparent Data Encryption
• Use file encryption
• Encrypt and decrypt table columns
• Set up Oracle Label Security policies

Course Contents :

5 Videos cover course from chapter 2 to 21

zip file contains practice scripts that used in course and some documents that help you to go in-depth.

URL : Oracle Database 11gR2 Security
YouTube:  http://www.youtube.com/playlist?list=PLbybFqHGEZ9FvFKjn3pkTsO0pA0XrjWos

Note: Course in Arabic 

Thanks,
Ahmed Fathi