Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle Database Administration for JuniorDBA/Oracle cloud.
Rating: 3.6 out of 5(128 ratings)
667 students

Oracle Database Administration for JuniorDBA/Oracle cloud.

To get skill how to do Oracle Database Administration ,Learn Oracle Cloud and prepare Oracle Certification exam
Created byZulqarnain Hayat
Last updated 3/2020
English

What you'll learn

  • After completing this course you will have fundamentals required for installation, configuration, and administration of an Oracle 12c database
  • To learn Database instance and storage,Instance memory pools
  • PGA,SGA
  • backup and recovery

Course content

17 sections • 64 lectures • 9h 22m total length

  • Welcome2:53
  • Target Audience1:57

    Target beginners who want to become Oracle database administrators by covering basic requirements and vm access. Gain Linux fundamentals, relational database concepts, and hands-on Oracle installation on your box.

Requirements

  • Oracle Linux operating system RAM 8GB , CPU Two Cores
  • Labtop and Oracle virtual box, Oracle Linux 7

Description

Oracle Database 12c is the world's leading relational database management system.After completing this course you will have fundamentals required for installation, configuration, and administration ,Architecture of an Oracle 12c database including hand on all exercise files are  attached with respective chapter.

Topics Covered

  1. Database instance and storage

  2. Instance memory pools

  3. Instance background processes

  4. Client connections

  5. Database storage file types

  6. Control files and backup files

  7. Multi-tenant databases

  8. Starting and stopping the database

  9. Installing Oracle 12c software

  10. Using the developer tools

  11. Database management

    Oracle Backup (RMAN) Hands-On Demo and Concepts

  12. Starting and connecting to database

  13. How to backup database in Archivelog and NoArchivelog mode with RMAN

  14. Oracle database incremental backup using RMAN

    Oracle Backup (User-Managed Backup) Hands-On Demo and Concepts

  15. How to take cold backup and Restore

  16. How to take Hot backup

  17. How to restore Hot backup


  18. Oracle DBA interview questions

  19. Oracle DBA terminology

  20. Oracle Basic Concepts


  21. QUICK REVIEW VERY Useful for DBA

    Install oracle 18c Demo 

    Install Oracle enterprise manager(OEM) in steps Demo

    Oracle Migration from Non-RAC to RAC database  Demo

    Oracle Database clone in RAC enviroment  Demo

    Convert oracle database from windows to Linux Demo

    Duplicate Oracle Database using RMAN Demo

    =========================================

  22. Oracle Database 19c installation in Oracle Linux 7

    Action Plan:

    1.  Preparing the Oracle Linux 7.6 Operating System for Database 19c installation.

    2.  Virtual Box Settings for Oracle Linux 7 VM.

    3.  Setting the static ip address

    4.  kernel parameters configuration

    5.  Resource limit configuration and stopping the Firewall

    6.  dependencies installation

    7.  oracle database installation

    8.  Host name configuration for Oracle Linux VM.

    9.  Oracle listener configuration after installation.

    10.  Starting the Database in SQL Plus

    11. Create one Common user called "scott"

    12. SQL Developer 19.1 Connectivity with Oracle database 19c

    13. Mounting the pluggable database orclpdb and check connectivity on SQL Developer.

    14. Access the Oracle Enterprise Manager on host machine browser.

Who this course is for:

  • Oracle Database Administrator ,Oracle Developer
  • anyone who wants to start his career as Oracle Database administrator role with all basic to expert level

Report abuse