Oracle Database 12c Fundamentals

Pluralsight

Course Summary

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 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 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 Syllabus

Exploring the Oracle Database 12c Architecture: Part 1
- 30m 25s

—Overview 1m 23s
—Goals of This Course and Learning Path 2m 59s
—What is Oracle Database 12c? 3m 22s
—A Bit of Oracle Version History 2m 37s
—Understanding Oracle Client/Server Architecture 2m 37s
—Database and Instance 4m 53s
—Oracle Database 12c Memory Structures 5m 52s
—Program Global Area Components 1m 52s
—Managing Memory in Oracle Database 12c 2m 32s
—Summary 2m 14s

Exploring the Oracle Database 12c Architecture: Part 2
- 30m 2s

—Overview 1m 49s
—Oracle Database 12c Background Processes 2m 13s
—Mandatory Background Processes 4m 2s
—Optional Background Processes 1m 35s
—Linking the Background Processes to the Memory Structures 1m 35s
—Demo: Background Processes 2m 28s
—Oracle Database 12c Physical Storage Structures 1m 40s
—Oracle File Storage Options 1m 42s
—Oracle Database 12c Logical Storage Structures 4m 17s
—Oracle Storage Structures - A Conceptual View 0m 42s
—Demo: Physical Storage Structures 1m 3s
—Introducing the Oracle Management Tools 2m 34s
—Demo: Oracle Management Tools 3m 12s
—Summary 1m 5s

Introducing the Oracle Database 12c Instance
- 25m 22s

—Overview 1m 22s
—Understanding Initialization Parameter Files 2m 14s
—Some Key Initialization Parameters 0m 49s
—Server Parameter File Tips and Tricks 2m 1s
—Demo 1: Working With Initialization Parameters 5m 26s
—Phases of Oracle Database Startup 1m 57s
—Shutdown Modes 2m 12s
—Demo 2: Starting Up and Shutting Down Oracle Database 12c 3m 8s
—About the Oracle Database 12c Alert Log 1m 53s
—Dynamic Performance Views 1m 1s
—Demo 3: Viewing the Alert Log 1m 56s
—Summary 1m 19s

Configuring the Oracle Database 12c Network Environment
- 27m 57s

—Overview 1m 2s
—What is Oracle Net Services? 2m 18s
—The Oracle Net Listener 2m 46s
—Configuring LISTENER.ORA 1m 38s
—Managing the Listener 1m 16s
—Demo 1: Configuring the Oracle Database 12c Listener 4m 40s
—Oracle Naming Methods 3m 29s
—Oracle Net Management Tools 1m 43s
—Installing the Oracle Database Client 1m 26s
—Demo 2: Working With the Oracle Database Client 6m 38s
—Summary 0m 55s

Managing Oracle Database 12c Storage Structures
- 26m 46s

—Overview 2m 10s
—Review: How Data is Stored in Oracle Database 12c 2m 6s
—What is a Tablespace? 4m 38s
—More Tablespace Fun Facts 3m 7s
—Demo 1: Investigating Tablespaces 6m 28s
—PDBs, Tablespaces, and You 1m 23s
—Database Files in a CDB 0m 47s
—A Quick Word About Initialization Parameters 1m 12s
—Demo 2: Creating Tablespaces 3m 3s
—Summary 1m 48s

Creating Common Database Objects in Oracle Database 12c
- 29m 45s

—Overview 2m 7s
—About Schemas in Oracle Database 12c 3m 41s
—Tables in the Relational Database Model 4m 16s
—Integrity Constraints 1m 4s
—Table Relationships 1m 42s
—Table Types in Oracle Database 12c 1m 48s
—Demo 1: Creating Tables 8m 34s
—How B-Tree Indexes Work 1m 12s
—Demo 2: Creating Indexes and Table Relationships 4m 15s
—Summary 1m 1s

Oracle Database 12c User Administration Basics
- 27m 47s

—Overview 2m 22s
—The User in Oracle Database 12c 2m 31s
—The Wonderful Oracle Documentation 1m 3s
—Demo 1: Touring the Oracle Documentation 2m 5s
—Creating Users 2m 37s
—Predefined Accounts and Roles 3m 0s
—Demo 2: Creating Users 7m 9s
—Operating System Authentication 0m 22s
—The General User Creation Workflow 0m 42s
—Demo 3: Managing Users With Enterprise Manager DB Express 12c 4m 42s
—Summary 1m 8s

Managing Space and Undo Data in Oracle Database 12c
- 24m 12s

—Overview 2m 21s
—What is Undo Data and Why Should I Care? 2m 29s
—The ACID Model 1m 46s
—Elements of Undo Space Management 2m 32s
—Demo 1: Working With Undo Data 6m 52s
—Managing Space 2m 36s
—Demo 2: Managing Undo Data With EM Cloud Control 12c 2m 22s
—Demo 3: About the Oracle Cloud 1m 21s
—Summary 1m 49s

Course Fee:

USD 29

Course Type:	Self-Study
Course Status:	Active
Workload:	1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course? Write a Review

Course Fee:

USD 29

Course Type:	Self-Study
Course Status:	Active
Workload:	1 - 4 hours / week

IT Career Development Platform

Oracle Database 12c Fundamentals

Pluralsight

Course Summary

Course Description

Course Description

Course Syllabus

Course Type:

Course Status:

Workload:

Oracle

DOT NET (.NET)

Workflow

SQL (Structured Query Language)

Database administrator (DBA)

B-tree

Attended this course? Write a Review

Course Type:

Course Status:

Workload: