Oracle Database 19C Administration Workshop


Request for price


Length: 5 day (40 hours)

 

  • Through a blend of hands-on labs and interactive lectures you will learn how to create database storage structures appropriate for the business applications supported by your database.
  • In addition, you learn how to create users and administer database security to meet your business requirements.
  • Basic information on backup and recovery techniques is presented in this course.
  • This Oracle Database 19c Administration course is for anyone who needs to administer, monitor and support an Oracle database.
  • Should have an understanding of relational database concepts and good operating system knowledge.
  • Should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. 

Start with the customer – find out what they want and give it to them.

Course objectivesCourse outlines

Course objectives

After completing this course, students will be able to:

    • After completing this course, you will be able to you have knowledge required to maintain successful and efficient day-to-day operations of an Oracle database.
    • The delegate will gain practical experience in administering and monitoring an Oracle database.

Course outlines

    • Module 1: Introduction to Oracle Database
    • Module 2: Accessing an Oracle Database
    • Module 3: Creating an Oracle Database by Using DBCA
    • Module 4: Creating an Oracle Database by Using a SQL Command
    • Module 5: Starting Up and Shutting Down a Database Instance
    • Module 6: Managing Database Instances
    • Module 7: Oracle Net Services: Overview
    • Module 8: Configuring Naming Methods
    • Module 9: Configuring and Administering the Listener
    • Module 10: Configuring a Shared Server Architectur
    • Module 11: Configuring Oracle Connection Manager for Multiplexing and Access Control
    • Module 12: Creating PDBs from Seed
    • Module 13: Using Other Techniques to Create PDBs
    • Module 14: Managing PDBs
    • Module 15: Database Storage Overview
    • Module 16: Creating and Managing Tablespaces
    • Module 17: Improving Space Usage
    • Module 18: Managing Undo Data
    • Module 19: Creating and Managing User Accounts
    • Module 20: Configuring Privilege and Role Authorization
    • Module 21: Configuring User Resource Limits
    • Module 22: Implementing Oracle Database Auditing
    • Module 23: Introduction to Loading and Transporting Data
    • Module 24: Loading Data
    • Module 25: Transporting Data
    • Module 26: Using External Tables to Load and Transport Data
    • Module 27: Automated Maintenance Tasks: Overview
    • Module 28: Automated Maintenance Tasks: Managing Tasks and Windows
    • Module 29: Database Monitoring and Tuning Performance Overview
    • Module 30: Monitoring Database Performance
    • Module 31: Database Processes
    • Module 32: Managing Memory
    • Module 33: Analyzing SQL and Optimizing Access Paths