Managing a Database Instance

Oracle 12c
  • 14 Videos | 1h 20m 32s
  • Includes Assessment
  • Earns a Badge
Likes 18 Likes 18
Discover how to get started with Oracle Database 12c, configure initialization parameters, start up a database instance, work with log files, and use the various database views.

WHAT YOU WILL LEARN

  • describe the Oracle Database 12c database management tools, SQL*Plus and SQL Developer
    access Enterprise Manager (EM) Database Express and provide an overview of the options it provides for managing Oracle Database 12c
    start Oracle Enterprise Manager Cloud Control and describe its core components in Oracle Database 12c
    use Enterprise Manager Cloud Control in Oracle Database 12c
    identify types of initialization parameters and the files that contain them in Oracle Database 12c
    configure key initialization parameters in Oracle Database 12c
    describe how to use SQL*Plus to view and configure initialization parameters for Oracle Database 12c
  • explain the steps that occur when you start up a database instance in Oracle Database 12c
    explain what occurs when you shut down a database instance, as well as the available shutdown modes, in Oracle Database 12c
    view the alert log and find and use trace files in Oracle Database 12c
    administer the DDL log file and use the debug log file in Oracle Database 12c
    describe and use dynamic performance views in Oracle Database 12c
    describe and use the data dictionary views in Oracle Database 12c
    configure initialization parameters, start a database instance, and use different views in Oracle Database 12c

IN THIS COURSE

  • Locked
    1. 
    SQL*Plus and SQL Developer
    6m 27s
  • Locked
    2. 
    Introduction to Enterprise Manager Database Express
    5m 42s
  • Locked
    3. 
    Using Oracle Enterprise Manager Cloud Control
    4m 39s
  • Locked
    4. 
    Working with Oracle Enterprise Manager Cloud Control
    3m 57s
  • Locked
    5. 
    Overview of Initialization Parameters
    6m 58s
  • Locked
    6. 
    Configuring Key Initialization Parameters
    7m 15s
  • Locked
    7. 
    Using SQL*Plus to View and Configure Parameters
    5m 48s
  • Locked
    8. 
    Starting a Database Instance
    5m 14s
  • Locked
    9. 
    Shutting Down a Database Instance
    5m
  • Locked
    10. 
    The Alert Log and Trace Files
    5m 21s
  • Locked
    11. 
    DDL and Debug Log Files
    3m 27s
  • Locked
    12. 
    Dynamic Performance Views
    4m 41s
  • Locked
    13. 
    Data Dictionary Views
    4m 36s
  • Locked
    14. 
    Exercise: Configure, Start, and View a Database
    4m 56s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 54 Likes 54  
Likes 19 Likes 19  
Likes 19 Likes 19