Managing a Database Instance

Oracle 12c    |    Intermediate
  • 14 videos | 1h 14m 2s
  • Includes Assessment
  • Earns a Badge
Likes 32 Likes 32
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
    Upon completion of this video, you will be able to describe the Oracle Database 12c database management tools: SQL*Plus and SQL Developer. FREE ACCESS
  • Locked
    2.  Introduction to Enterprise Manager Database Express
    5m 42s
    In this video, you will access Enterprise Manager Database Express and provide an overview of the options it provides for managing Oracle Database 12c. FREE ACCESS
  • Locked
    3.  Using Oracle Enterprise Manager Cloud Control
    4m 39s
    Learn how to start Oracle Enterprise Manager Cloud Control and describe its core components in Oracle Database 12c. FREE ACCESS
  • Locked
    4.  Working with Oracle Enterprise Manager Cloud Control
    3m 57s
    In this video, you will use Oracle Database 12c Enterprise Manager Cloud Control. FREE ACCESS
  • Locked
    5.  Overview of Initialization Parameters
    6m 58s
    During this video, you will learn how to identify types of initialization parameters and the files that contain them in Oracle Database 12c. FREE ACCESS
  • Locked
    6.  Configuring Key Initialization Parameters
    7m 15s
    Find out how to configure key initialization parameters in Oracle Database 12c. FREE ACCESS
  • Locked
    7.  Using SQL*Plus to View and Configure Parameters
    5m 48s
    After completing this video, you will be able to describe how to use SQL*Plus to view and configure initialization parameters for Oracle Database 12c. FREE ACCESS
  • Locked
    8.  Starting a Database Instance
    5m 14s
    After completing this video, you will be able to explain the steps that occur when you start up a database instance in Oracle Database 12c. FREE ACCESS
  • Locked
    9.  Shutting Down a Database Instance
    5m
    After completing this video, you will be able to explain what occurs when you shut down a database instance, as well as the available shutdown modes, in Oracle Database 12c. FREE ACCESS
  • Locked
    10.  The Alert Log and Trace Files
    5m 21s
    In this video, you will view the alert log and find and use trace files in Oracle Database 12c. FREE ACCESS
  • Locked
    11.  DDL and Debug Log Files
    3m 27s
    In this video, learn how to administer the DDL log file and use the debug log file in Oracle Database 12c. FREE ACCESS
  • Locked
    12.  Dynamic Performance Views
    4m 41s
    Upon completion of this video, you will be able to describe and use dynamic performance views in Oracle Database 12c. FREE ACCESS
  • Locked
    13.  Data Dictionary Views
    4m 36s
    After completing this video, you will be able to describe and use the data dictionary views in Oracle Database 12c. FREE ACCESS
  • Locked
    14.  Exercise: Configure, Start, and View a Database
    4m 56s
    In this video, you will learn how to configure initialization parameters, start a database instance, and use different views in Oracle Database 12c. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Oracle Database 12c R2 SQL: Creating Other Schema Objects
Likes 23 Likes 23  
Channel Oracle Database 12c: Performance Management and Tuning
Likes 60 Likes 60  
Channel SQL Database Administration
Likes 398 Likes 398  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Top 10 List Items
Likes 2025 Likes 2025  
Course Introduction to Artificial Intelligence
Likes 673 Likes 673  
Course Backing Up & Recovering Data
Likes 20 Likes 20