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
Level
Beginner
Updated
Jun 28, 2014
Duration
3h 42m
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
Description
Course info
Level
Beginner
Updated
Jun 28, 2014
Duration
3h 42m
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.
About the author
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
More courses by Tim Warner