Oracle Database Administration

This hands-on course provides students with the fundamental skills to create, maintain and manage an Oracle database. The class will focus on day-to-day duties of an Oracle DBA, such as managing users and security, space management, creating database objects (tablespaces, tables, indexes) and backup and recovery. The Oracle database architecture is discussed in great detail. This course provides the foundation of knowledge for new Oracle DBAs but does not cover database tuning.

0 STUDENTS ENROLLED

    • Introduction to the Oracle data dictionary
    • Oracle Database architecture
    • Creating administrative users
    • Starting and shutting down an Oracle instance
    • Initialization parameter files
    • Creating and managing users
    • Introduction to auditing
    • Managing security
    • Creating and managing Tablespaces
    • Creating and managing Tables
    • Creating and managing Constraints
    • Creating and managing Indexes
    • Managing Undo Space
    • Managing Redo Logs
    • Managing Control Files
    • Introduction to Backup and Recovery
    • Introduction to Oracle Utilities
    • Introduction to Oracle Networking
    • Creating a new database

    Before beginning this course, students should have a working knowledge of both SQL and PL/SQL.

     

    Before beginning this course, students should have a working knowledge of both SQL and PL/SQL.

    Students will learn how to create and manage an Oracle database.

    • PC Workstation for use during training
    • Student Manual

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    © Euler. All rights reserved.
    X
    Contact Us to Register