Oracle 19c DBA

Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Part I : Oracle19c SQL
  1. Identify the major structural components of the Oracle Database 19c
  2. Write Basic SELECT statements
  3. Sorted and restricted data
  4. Multiple table JOIN
  5. Single Row Function
  6. Multiple Row Function
  7. Sub-queries
  8. Data manipulation statements (DML)
  9. Create tables to store data
  10. Utilize views to display data
  11. Create INDEX, Synonyms, Sequences objects
Part II :Administration I
  1. Understand Oracle Database Architecture
  2. Manage and monitor Oracle Database instance, network connections
  3. Manage tablespaces and undo data
  4. Manage data concurrency and auditing
  5. Importance of proactive database maintenance, and how to implement it

 

Part III :Administration II
  1. Use Data Recovery Advisor to diagnose and repair failures
  2. Use Oracle Flashback Technologies  to recover data
  3. Perform database backup and restore.
  4. Perform tablespace point-in-time recovery
  5. Oracle Database backup methods and recovery operations to resolve database failure.
  6. Oracle Database architecture components related to backup and recovery operations
  7. Plan effective backup and recovery procedures.
  8. Configure the database for recoverability
  9. Use Recovery Manager (RMAN) to create backups and perform recovery operations

 

Show More

What Will You Learn?

  • Part I :Oracle19c SQL
  • Part II :Administration I
  • Part III :Administration II

Student Ratings & Reviews

No Review Yet
No Review Yet

Join Our Community

Enter your email address to register to our newsletter subscription delivered on regular basis!
Scroll to Top