Read more
2Month/20 Hours Price:90,000
80,000
Oracle Database 12c Admin Training – Complete DBA Course
Benefits To You
You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
COURSE DETAILS:
Module1:Getting Started
Course ObjectivesExploring Oracle Database Architecture
Introducing Oracle Database
Relation Database Models
Oracle SQL and PL/SQL
Oracle Database Server Architecture
Connecting to Oracle Databases
Oracle Database Tools
Oracle-Supplied User Accounts
Querying the Oracle Data Dictionary
Module2:Managing Database Instances
Initialization Parameter FilesStarting Up Oracle Databases
Shutting Down Oracle Databases
Opening and Closing PDBs
Working with the Automatic Diagnostic Repository (ADR)
Querying Dynamic Performance Views
Module3:Creating PDBs
Methods and Tools to Create PDBsCreating PDBs from Seed with SQL*Plus
Cloning PDBs with SQL*Plus
Unplugging and Pluggin In PDBs with SQL*Plus
Dropping PDBs with SQL*Plus
Module4:Configuring the Oracle Network Environment
Oracle Net ServicesHow Listeners Work
Configuring Listeners for Dynamic Service Registration
Configuring Listeners for Static Service Registration
Configuring Local Naming for Connections
Testing Oracle Net Connectivity with tnsping
Configuring Communidation Between Databases
Dedicated Versus Shared Server Configurations
Module5:Administering User Security
Creating UsersGranting Privileges
Creating and Granting Roles
Revoking Privileges and Roles
Creating and Assigning Profiles
Authenticating Users
Assigning Quotas to Users
Applying the Principal of Least Privilege
Module6:Creating and Managing Tablespaces
How Table Data is StoredCreating Tablespaces in SQL*Plus
Altering and Dropping Tablespaces in SQL*Plus
Viewing Tablespace Information in SQL*Plus
Implementing Oracle Managed Files
Moving and Renaming Online Data Files in SQL*Plus
Module7:Managing Storage Space
Oracle Database Space Management FeaturesBlock Space Management
Row Chaining and Migration
Free Space Management Within Segments
Types of Segments
Allocating Extents
Understanding Deferred Segment Creation
Space-Saving Features
Module8:Managing UNDO Data
Undo Data: OverviewTransactions and Undo Data
Storing Undo Information
Comparing Undo Data and Redo Data
Managing Undo
Local Undo Mode Versus Shared Undo Mode
Configuring Undo Retension
Categories of Undo
Module9:Moving Data
Moving Data: General ArchitectureOracle Data Pump: Overview
Oracle Data Pump: Benefits
Data Pump Export and Import Clients
Data Pump Utility: Interfaces and Modes
Data Pump Import: Transformations
SQL*Loader Overview
Loading Methods
Module10:Backup and Recovery Concepts
DBA ResponsibilitiesCategories of Failure
Understanding Instance Recovery
Understanding Types of Backups
Comparing Complete and Incomplete Recovery
Oracle Data Protection Solutions
Flashback Technology
Module11:Monitoring and Tuning Database Performance
Managing Performance ActivitiesPerformance Planning Considerations
Database Maintenance
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor
Performance Monitoring
Performance Tuning Methodology
Database Server Statistics and Metrics
Module12:SQL Tuning
SQL Tuning ProcessOracle Optimizer
Optimizer Statistics
SQL Plan Directives
Adaptive Execution Plans
SQL Tuning Advisor
SQL Access Advisor
SQL Performance Analyzer
Module13:Oracle Database Resource Manager
Oracle Database Resource Manager: OverviewResource Manager Elements
Using Resource Manager to Allocate Resources
Creating a Simple Resource Plan
Creating a Complex Resource Plan
Using the Active Session Pool Feature
Limiting CPU Utilization at the Database Level
Limiting CPU Utilization at the Server Level
Module14:Enterprise Manager Cloud Control
Controlling the Enterprise Manager Cloud Control FrameworkStarting the Enterprise Manager Cloud Control Framework
Stopping the Enterprise Manager Cloud Control Framework
Module15:Introduction to Oracle Database Cloud Service
Oracle Cloud: OverviewDatabase Cloud Service Offerings
DBCS Architecture
Features and Tooling
Additional Database Configuration Options
Module16:Creating DBCS Database Deployments
Automated Database ProvisioningCreating a Database Deployment
How SSH Key Pairs are Used
Creating an SSH Key Pair
Storage Used for Database Files
Module17:Managing DBCS Database Deployments
Cloud ToolingAccessing Tools and Features from the DBCS Console
Managing the Compute Node Associated With a Database Deployment
Managing Network Access to DBCS
Enabling Access to a Compute Node Port
Scaling a Database Deployment
Module18:Backing Up and Restoring DBCS Database Deployments
Backing Up and Recovering Databases on DBCSBackup Destination Choices
Backup Configuration
Creating an On-Demand Backup
Customizing the Backup Configuration
Performing Recovery by Using the Console
Performing Recovery by Using the dbaascli Utility
Module19:Patching DBCS Database Deployments
Patching DBCSUsing the DBCS Console to Manage Patches
Using the dbaascli Utility to Manage Patches
Creating Master Encryption Keys for PDBs
CDB and PDB Master Encryption KeysDetermining Whether You Need to Create and Activate and Encryption Key for a PDB
Creating and Activating an Encryption Key
Module20:Tablespace Encryption by Default
Tablespace Encryption by Default in DBCSTransparent Data Encryption (TDE) Overview
Components of TDE
Using TDE
Defining the Keystore Location
Controlling Tablespace Encryption by Default
Managing the Software Keystore and Master Encryption Key
Managing the Keystore in CDBs and PDBs
Oracle Fusion Cloud Job Interview Preparation
- Oracle DBA Interview Questions and Answers
- Oracle Fusion Cloud Technical Interview Questions
- Oracle Fusion Cloud Techno Functional Interview Questions
- Oracle Fusion Financials Cloud Interview Questions
Oracle SOA Suite 12c Essentials Free Exam Practise Test
International Students Fee : 930 USD |
Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview Questions
What to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Stay connected even when you’re apart
Join our WhatsApp Channel – Get discount offers
500+ Free Certification Exam Practice Question and Answers
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Hire an Intern
Flexible Class Option
Week End Classes For Professionals SAT | SUN
Corporate Group Training Availables Options
Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Oracle Database 11g Admin-I DBA Training Course
Oracle Database 11g Admin-II DBA Training Course
Oracle Fusion Sales and Service – Engagement Cloud Training
Oracle Fusion Financials Cloud Training
0 Reviews