Managing a Database Instance

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

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

CHANNEL Oracle Database 12c Administrator Certified Associate
Likes 111 Likes 111  
COURSE Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Likes 28 Likes 28  
COURSE Database Fundamentals: Working with SQL Commands

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

BOOK Introduction to SQL and PL/SQL
COURSE SQL*Plus Commands
Likes 90 Likes 90  
COURSE Connecting to & Configuring a Database Instance
Likes 19 Likes 19