Oracle Database 12c Fundamentals
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.
What you'll learn
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.
Table of contents
- 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
- 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
- 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
- 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
- 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
- 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
Course FAQ
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.
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
This course is for anyone who wants to learn Oracle database 12c fundamentals and/or prepare for the Oracle Certified Administrator (OCA) certification exam.
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.
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
Timothy Warner is a Microsoft Most Valuable Professional (MVP) in Cloud and Datacenter Management who is based in Nashville, TN. His professional specialties include Microsoft Azure, cross-platform PowerShell, and all things Windows Server-related. You can reach Tim via Twitter (@TechTrainerTim), LinkedIn or his blog, AzureDepot.com.