MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Oracle Database 12c Fundamentals

Course Summary

If you want or need to understand Oracle Database 12c, then you've come to the right place. In this course, we have three purposes. We want to (1) Get you up to speed with how Oracle Database works in general from the perspective of the database administr

  • +

    Course Syllabus

    ● Exploring the Oracle Database 12c Architecture: Part 1
        ◦ Overview
        ◦ Goals of This Course and Learning Path
        ◦ What is Oracle Database 12c?
        ◦ A Bit of Oracle Version History
        ◦ Understanding Oracle Client/Server Architecture
        ◦ Database and Instance
        ◦ Oracle Database 12c Memory Structures
        ◦ Program Global Area Components
        ◦ Managing Memory in Oracle Database 12c
        ◦ Summary
    ● Exploring the Oracle Database 12c Architecture: Part 2
        ◦ Overview
        ◦ Oracle Database 12c Background Processes
        ◦ Mandatory Background Processes
        ◦ Optional Background Processes
        ◦ Linking the Background Processes to the Memory Structures
        ◦ Demo: Background Processes
        ◦ Oracle Database 12c Physical Storage Structures
        ◦ Oracle File Storage Options
        ◦ Oracle Database 12c Logical Storage Structures
        ◦ Oracle Storage Structures - A Conceptual View
        ◦ Demo: Physical Storage Structures
        ◦ Introducing the Oracle Management Tools
        ◦ Demo: Oracle Management Tools
        ◦ Summary
    ● Introducing the Oracle Database 12c Instance
        ◦ Overview
        ◦ Understanding Initialization Parameter Files
        ◦ Some Key Initialization Parameters
        ◦ Server Parameter File Tips and Tricks
        ◦ Demo 1: Working With Initialization Parameters
        ◦ Phases of Oracle Database Startup
        ◦ Shutdown Modes
        ◦ Demo 2: Starting Up and Shutting Down Oracle Database 12c
        ◦ About the Oracle Database 12c Alert Log
        ◦ Dynamic Performance Views
        ◦ Demo 3: Viewing the Alert Log
        ◦ Summary
    ● Configuring the Oracle Database 12c Network Environment
        ◦ Overview
        ◦ What is Oracle Net Services?
        ◦ The Oracle Net Listener
        ◦ Configuring LISTENER.ORA
        ◦ Managing the Listener
        ◦ Demo 1: Configuring the Oracle Database 12c Listener
        ◦ Oracle Naming Methods
        ◦ Oracle Net Management Tools
        ◦ Installing the Oracle Database Client
        ◦ Demo 2: Working With the Oracle Database Client
        ◦ Summary
    ● Managing Oracle Database 12c Storage Structures
        ◦ Overview
        ◦ Review: How Data is Stored in Oracle Database 12c
        ◦ What is a Tablespace?
        ◦ More Tablespace Fun Facts
        ◦ Demo 1: Investigating Tablespaces
        ◦ PDBs, Tablespaces, and You
        ◦ Database Files in a CDB
        ◦ A Quick Word About Initialization Parameters
        ◦ Demo 2: Creating Tablespaces
        ◦ Summary
    ● Creating Common Database Objects in Oracle Database 12c
        ◦ Overview
        ◦ About Schemas in Oracle Database 12c
        ◦ Tables in the Relational Database Model
        ◦ Integrity Constraints
        ◦ Table Relationships
        ◦ Table Types in Oracle Database 12c
        ◦ Demo 1: Creating Tables
        ◦ How B-Tree Indexes Work
        ◦ Demo 2: Creating Indexes and Table Relationships
        ◦ Summary
    ● Oracle Database 12c User Administration Basics
        ◦ Overview
        ◦ The User in Oracle Database 12c
        ◦ The Wonderful Oracle Documentation
        ◦ Demo 1: Touring the Oracle Documentation
        ◦ Creating Users
        ◦ Predefined Accounts and Roles
        ◦ Demo 2: Creating Users
        ◦ Operating System Authentication
        ◦ The General User Creation Workflow
        ◦ Demo 3: Managing Users With Enterprise Manager DB Express 12c

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top