Oracle Database 12c: Fundamentals for Developers and System Administrators | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Oracle Database 12c: Fundamentals for Developers and System Administrators

  • On Demand Class Icon
    On Demand
    • HRDF SBL Claimable
    • Certificate of Attendance available
    • 90 days of access from date of activation
    Starting From
    RM 2010.00
    16 Hours
  • Private Class Icon
    Private Class
    • All of our private classes are customized to your organization's needs.

      Click on the button below to send us your details and you will be contacted shortly.
    2 Days

Course Details

Expand All

This course is specially design for Support Engineer, Database Administrators, Technical Consultant and Technical Administrator

Required Prerequisites:

  • Basic understanding of the Linux operating system

Recommended Related Training Courses:

  • Using Java - for PL/SQL and Database Developers

This Java for PL/SQL and Developers training teaches you to access Oracle Database using JDBC , UCP, Java stored procedures and SQLJ technologies. Learn to create, load, resolve and publish Java classes in the Database and more.

  • Using Java - for PL/SQL and Database Developers

Learn to use Java in Oracle Database programming. This course includes the use of JDBC, Java stored procedures, and SQLJ technologies in accessing data.

This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises

Upon completion of this program, participants should be able to :

  • Install Oracle Database 12c
  • Create a Database
  • Use Enterprise Manager Database Express to manage the database
  • Manage database storage structures and schema objects
  • Administer users and security
  • Backup and recover the Oracle database
  • Monitor the database and use the Advisors

This course is ideal for Database Administrators of small to medium sized businesses. This Oracle Database 12c: Fundamentals for Developers and System Administrators course helps you perform basic Oracle Database 12c administration tasks needed to keep the database operational.

Learn To:

  • Install Oracle Database 12c software and create a database.
  • Use Enterprise Manager Database Express to manage the database.
  • Manage database storage structures and schema objects.
  • Administer users and security.
  • Backup and recover the Oracle Database.
  • Monitor the database and use the Advisors

Benefits To You:

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service.

Install and Manage Oracle Database 12c

The goal of this course is to teach you how to install the Oracle Database 12c software and perform the tasks required to manage an Oracle database. You will start with installation of the Oracle Software and reviewing installation configuration details.

Self-Managing Capabilities and Automatic Features of Oracle Database 12c

Throughout this course, expert Oracle instructors will teach you how to quickly accomplish required tasks using Enterprise Manager. This training places particular emphasis on the self-managing capabilities and automatic features of Oracle Database 12c.

Modules

Expand All
  • Course Objectives
  • Course Agenda
  • Course Environment
  • Additional Resources
  • Relational Databases: Introduction
  • Relational Database Terminology
  • Relating Multiple Tables
  • Structured Query Language (SQL)
  • SQL Statements
  • Using SQL to Access the Database
  • Development Tools for Oracle Database
  • Oracle Instance and Database: Overview
  • Installation Workflow
  • Oracle Universal Installer
  • Installation Prerequisites
  • Setting Environment Variables
  • Installation Steps
  • Configuring Security Updates
  • Downloading Software Updates
  • Specifying Installation Options
  • Management Framework
  • Enterprise Manager Database Express: Overview
  • Configuring the HTTPS Port for EM Express
  • Accessing EM Express
  • Using the Database Home Page
  • Navigating Through EM Express
  • Granting Access to EM Express
  • SQL*Plus
  • Network Configuration: Overview
  • Oracle Net Listener: Configuration and Management
  • Tools for Configuring and Managing the Oracle Network
  • Using the Listener Control Utility
  • Connecting to an Oracle Database
  • Name Resolution
  • Oracle Net: Naming Methods
  • Oracle Instance Management
  • Initialization Parameters
  • Oracle Processes
  • Oracle Memory Structures
  • Starting and Shutting Down an Instance
  • States of an Instance
  • Stopping and Starting an Instance by Using SQL*Plus
  • Stopping and Starting an Instance by Using SQL Developer
  • Oracle Database Structures
  • Exploring the Storage Structure of the Oracle Database
  • Control File
  • Redo Log Files
  • Multiplexing the Redo Log
  • Tablespaces and Data Files
  • Tablespaces in the Preconfigured Database
  • Enlarging the Database
  • Overview of Users and Security
  • Oracle-Defined Users
  • Creating Users
  • Modifying Users
  • Dropping Users
  • Locking and Unlocking Accounts
  • Unlocking a User Account and Resetting the Password
  • Setting the Password Policy
  • What Is a Schema?
  • Schemas
  • Accessing Schema Objects
  • Specifying Data Types in Tables
  • Creating and Modifying Tables
  • Modifying a Table
  • Understanding Data Integrity
  • Defining Constraints
  • Oracle Recovery Features
  • Backup File Types
  • Types of Backups
  • Media Recovery Options
  • Media Recovery Step
  • Configuring the Database for Backup and Recovery
  • Configuring the Fast Recovery Area
  • Credentials Required to Perform Backup and Recovery
  • Proactive Database Monitoring
  • Monitoring General Database State and Workload
  • Monitoring Performance
  • Diagnosing Performance Problems
  • Types of ADDM Findings
  • Viewing a Summary of ADDM Performance Findings
  • Responding to Findings
  • Using Advisors
  • Understanding Software Management and Patch Releases
  • Patching Oracle Database Software
  • Using the Database Upgrade Assistant to Upgrade the Database
  • Removing Oracle Database Software

Trainers

Reviews

0
based on 0 ratings reviews