Course Description
In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to install, administer and maintain an Oracle 12c database in an effective and efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture and user management are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.
Once you have completed Oracle 12c: Database Administration I Part 1 the next course is this series is Oracle 12c: Database Administration I Part 2. The Oracle 12c: Database Administration I Part 2 course will continue to build your knowledge in shared server, database performance monitoring, database maintenance, how to use the undo management feature, how to deal with locking conflicts and finishing up with backups and database recovery. Click here to learn more about Oracle 12c: Database Administration I Part 2.
In This Course You Will Learn:
- Explain Oracle's architectural components
- Demonstrate how to use Oracle's universal installer and configuration assistants
- Identify the different interfaces to an Oracle database
- Define the differences between Container Databases and Pluggable Databases
- Define Oracle’s Multitenant environment
- Describe the different database control and storage structures
- Explain how to use schema and user management tools
- Contrast the different techniques for importing data to an Oracle database and exporting data from an Oracle database
- Describe PL/SQL declarations, code and exceptions
- Discuss Oracle's password security and database auditing features
- Configure Oracle's default user account features
- Configure and tune Oracle's Listener and Net Services features
- Learn how to establish, tune and monitor Oracle's Shared Server configuration
- Explain how to manually and automatically monitor the performance of an Oracle database
- Describe how to use Oracle's advisors to help tune and monitor database performance
- Show how to tune and administer Oracle's database undo management
- Discover how Oracle detects and resolves locking conflicts
- Learn the roles of control files, data files and redo log files in database backup and recovery
- Describe the implications of running your database in NOARCHIVELOG mode and ARCHIVELOG mode on database backup and recovery
Prerequisites
In order to successfully complete Oracle 12c Database Administraion 1 Part 1 you will need to have equivalent experience in or have taken:
Outline
Module 00: Course Introduction - Oracle 12c: Database Administration I Part 1
Module 01: Database Architecture
- Oracle Architecture
- Memory Components
- Background Processes
- Quiz: Database Architecture
Module 02: Oracle Physical and Logical Structures
- Oracle Logical Storage Structures
- Oracle Physical Storage Structures
Module 03: Oracle and ASM
- ASM Instance
- ASM parameters
- ASM Components
- Quiz: Oracle and ASM
Module 04: Container Databases and Pluggable Databases
- Define Container databases
- Define Pluggable databases
Module 05: Oracle 12c Installing ASM
- Define ASM
- Install ASM
- Lab Exercise: Create and Install ASM
- Lab Exercise Solution: Create and Install ASM Demo
Module 06: Installing the Database Software
- Define database software requirements
- Install Oracle database Software
- Lab Exercise: Installing the Database Software
- Lab Exercise Solution: Installing the Database Software Demo
Module 07: Creating a Container Database
- Define Database Requirements
- Create a Container Database using DBCA
Module 08: Creating a Traditional Database
- Define Database Requirements
- Create a Traditional Database using DBCA
- Lab Exercise: Create a Database
- Lab Exercise Solution: Create a Database Demo
Module 09: Oracle 12c Database Tools
- Define SQLPLUS
- Use Enterprise Manager Express
- Demo: Use Enterprise Manager Express
Module 10: Manage your Database with SQL Developer
- Manage Database with SQL Developer
- Understanding SQL Developer
- Demo: Use SQL Developer
Module 11: Manage your Database with Cloud Control
- Manage your database with Cloud Control
- Cloud Control Architecture
- Demo: Use Cloud Control
Module 12: Managing the Database Instance
- Define the components of the SGA
- Identify initialization parameters
Module 13: Start/Stop the Database
- Start/Stop the database
- Identify the Location of the Alert.log file
- Use Dynamic Performance Views
- Quiz: Managing the Database Instance
Module 14: Maintaining Data Files
- Create tablespaces
- Create Container Databases
- Create Pluggable databases
- Lab Exercise: Create Container Databases, Pluggable Database and Tablespaces
Module 15: Container Database Architecture
- Identify CDB_* views
- Utilize CDB security
Module 16: Database Security
- Identify Oracle Default accounts
- Create Database Users
- Create database Roles
- Assign database privileges
- Lab Exercise: Create DB Users
Module 17: Database Profiles
- Identify Database Profiles
- Uses for Database Profiles
- Create Database Profiles
Module 18: Database Undo Components
- Identify Oracle's Undo Segments
- Identify Undo Parameters
- How Undo and Flashback Query Work Together
- Quiz: Database Undo Components
Module 19: Database Networking Components Part 1
- Identify the networking components
- Set up a Listener
Module 20: Database Networking Components Part 2
- Create a tnsnames files
- Use Oracle's EZ Connect
Module 21: Oracle Database Concurrency
- Identify Oracle's Locking Mechanism
- Monitor Row Locks
- Resolve Row Locks
Certification
Oracle 12c: Database Administration I Part 1 online training is part of a two-course series that helps you to prepare for Oracle's Certified Associate. In order to become a Certified Associate, you will need to first pass one of the SQL Exams below:
Then you must pass the Oracle Database 12c: Installation and Administration 1Z0-062 exam.
For more information about the certification requirements, pricing, and locations select the link in the related training section.