Oracle Database 12c: Fundamentals for Developers and System Administrators
Duration : 2 Days (16 Hours)
Oracle Database 12c: Fundamentals for Developers and System Administrators Course Overview:
The Oracle Database 12c Fundamentals for Developers and System Administrators is a comprehensive training course designed for IT professionals responsible for implementing, managing, and administering Oracle databases. The course covers essential topics like database installation and configuration, backup and recovery techniques, database security, user and object management, performance tuning, and database features. Through instructor-led sessions and hands-on labs, students gain practical experience and knowledge to effectively operate and administer Oracle databases. By course completion, students will be proficient in tasks such as installing and configuring Oracle databases, managing database objects, securing the database, monitoring performance, implementing backup and recovery procedures, and scheduling jobs. Moreover, students will be adept at configuring the Database Service to achieve optimal functionality.
Intended Audience:
- Database Administrators: Professionals responsible for managing and administering Oracle databases.
- System Administrators: IT personnel responsible for the overall management and maintenance of IT systems.
- Cloud Developers: Developers involved in building and deploying applications on cloud platforms.
- Storage Administrators: Professionals responsible for managing storage systems and infrastructure.
Learning Objectives of Oracle Database 12c: Fundamentals for Developers and System Administrators:
By the end of this Oracle Database Appliance Release 12.1 Overview Ed 1 Training, learners should know:
1. What a database appliance is and what are its key benefits.
2. The technical specifications and components of the Oracle Database Appliance Release 12.1.
3. How to install, configure and deploy the Oracle Database Appliance.
4. Different ways to monitor and maintain the Oracle Database Appliance.
5. Performance tuning, replications and backup strategies for the Oracle Database Appliance.
6. The best practices to optimize the performance and security of the Oracle Database Appliance.
Module 1: Course Overview
- Additional Resources
- Course Objectives
- Course Agenda
- Course Environment
Module 2: Oracle Database: Overview
- Oracle Instance and Database: Overview
- Relating Multiple Tables
- Relational Databases: Introduction
- SQL Statements
- Structured Query Language (SQL)
- Relational Database Terminology
- Using SQL to Access the Database
- Development Tools for Oracle Database
Module 3: Installing and Creating a Database
- Configuring Security Updates
- Specifying Installation Options
- Installation Workflow
- Installation Steps
- Setting Environment Variables
- Oracle Universal Installer
- Downloading Software Updates
- Installation Prerequisites
Module 4: Using Oracle Enterprise Manager Database Express and SQL-Based Management Tools
- Granting Access to EM Express
- Management Framework
- Accessing EM Express
- Enterprise Manager Database Express: Overview
- Navigating Through EM Express
- Using the Database Home Page
- SQL * Plus
- Configuring the HTTPS Port for EM Express
Module 5: Configuring the Oracle Network Environment
- Network Configuration: Overview
- Oracle Net Listener: Configuration and Management
- Tools for Configuring and Managing the Oracle Network
- Oracle Net: Naming Methods
- Name Resolution
- Connecting to an Oracle Database
- Using the Listener Control Utility
Module 6: Managing the Oracle Instance
- Oracle Processes
- Oracle Memory Structures
- Initialization Parameters
- Oracle Instance Management
- Starting and Shutting Down an Instance
- States of an Instance
- Stopping and Starting an Instance by Using SQL Developer
- Stopping and Starting an Instance by Using SQL * Plus
Module 7: Managing Database Storage Structures
- Tablespaces and Data Files
- Tablespaces in the Preconfigured Database
- Exploring the Storage Structure of the Oracle Database
- Enlarging the Database
- Control File
- Multiplexing the Redo Log
- Redo Log Files
- Oracle Database Structures
Module 8: Administering Users and Security
- Unlocking to User Account and Resetting the Password
- Setting the Password Policy
- Creating Users
- Dropping Users
- Locking and Unlocking Accounts
- Overview of Users and Security
- Oracle-Defined Users
- Modifying Users
Module 9: Managing Schema Objects
- Modifying a Table
- Schemas
- Creating and Modifying Tables
- Understanding Data Integrity
- What Is a Schema?
- Accessing Schema Objects
- Specifying Data Types in Tables
- Defining Constraints
Module 10: Performing Backup and Recovery
- Oracle Recovery Features
- Configuring the Fast Recovery Area
- Backup File Types
- Types of Backups
- Media Recovery Step
- Media Recovery Options
- Configuring the Database for Backup and Recovery
- Credentials Required to Perform Backup and Recovery
Module 11: Monitoring the Database and Using the Advisors
- Types of ADDM Findings
- Proactive Database Monitoring
- Responding to Findings
- Viewing a Summary of ADDM Performance Findings
- Diagnosing Performance Problems
- Monitoring Performance
- Using Advisors
- Monitoring General Database State and Workload
Module 12: Managing the Software
- Patching Oracle Database Software
- Understanding Software Management and Patch Releases
- Using the Database Upgrade Assistant to Upgrade the Database
- Removing Oracle Database Software
Module 13: Oracle Database Cloud Service: Overview
- Software Editions: Included Database Options and Management Packs
- Automated Database Provisioning
- Using the Oracle Database Cloud Service Console to Manage Patches
- Managing the Compute Node Associated with a Database Deployment
- Database as a Service Architecture, Features and Tooling
- Scaling to Database Deployment & Patching Database as a Service
- Enabling Access to a Compute Node Port
- Managing Network Access to Database as a Service
Oracle Database 12c: Fundamentals for Developers and System Administrators Course Prerequisites:
Prior experience working with Oracle Database technology.
• Basic understanding of Oracle Database architecture, backup recovery, and disaster recovery concepts.
• Familiarity with Oracle Database 19c Administration.
• Knowledge of SQL, PL/SQL, and UNIX/Linux.
• Familiarity with Oracle RMAN and Data Guard environments.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!
Request More Details
