Oracle Database 12c Fundamentals

By Tim Warner
This course will get you up to speed with the Oracle Database platform in general and the Oracle Database 12c release in particular. You'll also get prepared to pass the Oracle Certified Administrator (OCA) certification exam.
Course info
Rating
(322)
Level
Beginner
Updated
Jun 28, 2014
Duration
3h 41m
Table of contents
Exploring the Oracle Database 12c Architecture: Part 1
Overview 1m Goals of This Course and Learning Path 3m What is Oracle Database 12c? 3m A Bit of Oracle Version History 3m Understanding Oracle Client/Server Architecture 3m Database and Instance 5m Oracle Database 12c Memory Structures 6m Program Global Area Components 2m Managing Memory in Oracle Database 12c 3m Summary 2m
Exploring the Oracle Database 12c Architecture: Part 2
Overview 2m Oracle Database 12c Background Processes 2m Mandatory Background Processes 4m Optional Background Processes 2m Linking the Background Processes to the Memory Structures 2m Demo: Background Processes 2m Oracle Database 12c Physical Storage Structures 2m Oracle File Storage Options 2m Oracle Database 12c Logical Storage Structures 4m Oracle Storage Structures - A Conceptual View 1m Demo: Physical Storage Structures 1m Introducing the Oracle Management Tools 3m Demo: Oracle Management Tools 3m Summary 1m
Introducing the Oracle Database 12c Instance
Overview 1m Understanding Initialization Parameter Files 2m Some Key Initialization Parameters 1m Server Parameter File Tips and Tricks 2m Demo 1: Working With Initialization Parameters 5m Phases of Oracle Database Startup 2m Shutdown Modes 2m Demo 2: Starting Up and Shutting Down Oracle Database 12c 3m About the Oracle Database 12c Alert Log 2m Dynamic Performance Views 1m Demo 3: Viewing the Alert Log 2m Summary 1m
Configuring the Oracle Database 12c Network Environment
Overview 1m What is Oracle Net Services? 2m The Oracle Net Listener 3m Configuring LISTENER.ORA 2m Managing the Listener 1m Demo 1: Configuring the Oracle Database 12c Listener 5m Oracle Naming Methods 3m Oracle Net Management Tools 2m Installing the Oracle Database Client 1m Demo 2: Working With the Oracle Database Client 7m Summary 1m
Managing Oracle Database 12c Storage Structures
Overview 2m Review: How Data is Stored in Oracle Database 12c 2m What is a Tablespace? 5m More Tablespace Fun Facts 3m Demo 1: Investigating Tablespaces 6m PDBs, Tablespaces, and You 1m Database Files in a CDB 1m A Quick Word About Initialization Parameters 1m Demo 2: Creating Tablespaces 3m Summary 2m
Creating Common Database Objects in Oracle Database 12c
Overview 2m About Schemas in Oracle Database 12c 4m Tables in the Relational Database Model 4m Integrity Constraints 1m Table Relationships 2m Table Types in Oracle Database 12c 2m Demo 1: Creating Tables 9m How B-Tree Indexes Work 1m Demo 2: Creating Indexes and Table Relationships 4m Summary 1m
Oracle Database 12c User Administration Basics
Overview 2m The User in Oracle Database 12c 3m The Wonderful Oracle Documentation 1m Demo 1: Touring the Oracle Documentation 2m Creating Users 3m Predefined Accounts and Roles 3m Demo 2: Creating Users 7m Operating System Authentication 0m The General User Creation Workflow 1m Demo 3: Managing Users With Enterprise Manager DB Express 12c 5m Summary 1m
Managing Space and Undo Data in Oracle Database 12c
Overview 2m What is Undo Data and Why Should I Care? 2m The ACID Model 2m Elements of Undo Space Management 3m Demo 1: Working With Undo Data 7m Managing Space 3m Demo 2: Managing Undo Data With EM Cloud Control 12c 2m Demo 3: About the Oracle Cloud 1m Summary 2m
Description
Course info
Rating
(322)
Level
Beginner
Updated
Jun 28, 2014
Duration
3h 41m
Description

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 administrator (DBA); (2) Acquaint you with the new features and enhancements included in the latest 12c release of Oracle Database; and (3) Prepare you to pass the Oracle Certified Administrator (OCA) certification exam. To get the most benefit from this course, you should already have a basic understanding of relational database management systems, the relational model, and using SQL to query databases.

Course FAQ
Course FAQ
What is Oracle Database 12c?

Oracle Database 12c is a powerful database intended for enterprises and designed for the cloud. It has hundreds of useful features, including pluggable databases and multitenant architecture.

What will I learn in this course?

In this course you well learn about the Oracle Database platform and Oracle Database 12c. Topics include:

  • Oracle Database 12c architecture
  • What is Oracle Databse 12c?
  • Memory structures in Oracle
  • Oracle database 12c background processes
  • Physical storage structures
  • File storage options
  • Oracle Databse 12c Instance
  • Configuring Oracle Database 12c network environment
  • Much more
Who is this course for?

This course is for anyone who wants to learn Oracle database 12c fundamentals and/or prepare for the Oracle Certified Administrator (OCA) certification exam.

Are there prerequisites to this course?

Before taking this course it would be most beneficial for you to already understand relational database management systems, the relational model, and SQL query databases.

What is Oracle Software?

The Oracle software is a database server that helps make information management much easier. The software gives access to Oracle databases which treat data as a unit, allowing for more efficient storing and retrieving of related information.

About the author
Tim Warner
About the author

Timothy Warner is a Microsoft Most Valuable Professional (MVP) in Cloud and Datacenter Management who is based in Nashville, TN.

More from the author
Microsoft Azure Network Engineer: Secure and Monitor Networks
Intermediate
2h 37m
Sep 3, 2021
Microsoft Azure Network Engineer: Design and Implement Private Access to Azure Services
Intermediate
1h 26m
Aug 26, 2021
Microsoft Azure Network Engineer: Design and Implement Core Networking Infrastructure
Intermediate
1h 56m
Aug 18, 2021
More courses by Tim Warner

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT