Managing a Database Instance

Oracle 12c    |    Intermediate
  • 14 videos | 1h 14m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 27 users Rating 4.6 of 27 users (27)
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

Channel SQL Database Administration
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Channel Wintellect SQL Server

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Backing Up & Recovering Data
Rating 4.6 of 25 users Rating 4.6 of 25 users (25)
Course Oracle Database Instance Overview
Rating 4.5 of 97 users Rating 4.5 of 97 users (97)
Course Performing & Managing Backups
Rating 4.4 of 26 users Rating 4.4 of 26 users (26)