Course Description
This course delivers detailed information on the architecture of an Oracle Database instance and database, allowing you to effectively control your database resources. You understand how to make database storage structures suitable for the business applications supported by your database. In addition, you know how to develop users & administer database security to meet your business necessities. Basic information on backup & recovery techniques is presented in this course.
- To provide an adequate response time to users & manage resources effectively, you understand how to monitor your database & manage performance.
- After accomplishment of this course, you will be able to-
- Describe Oracle Database architecture
- Describe Oracle Database Cloud Service (DBCS) architecture and features
- Create and manage DBCS database deployments
- Configure the database to support your applications
- Manage database security and implement auditing
- Implement basic backup and recovery procedures
- Move data between databases and files
- Employ basic monitoring procedures and manage performance
Prerequisites
No prerequisites are needed for this course
Target Audience
Database Administrator, Database Developer, System Administrator
Content Outline
- Introduction to Oracle Database
- Accessing an Oracle Database
- Creating an Oracle Database by Using DBCA
- Creating an Oracle Database by Using a SQL Command
- Starting Up & Shutting Down a Database Instance
- Managing Database Instances
- Oracle Net Service- Overview
- Configuring Naming Methods
- Configuring and Administering the Listener
- Configuring a Shared Server Architecture
- Configuring Oracle Connection Manager for Multiplexing and Access Control
- Creating PDBs from Seed
- Using Other Techniques to Create PDBs
- Managing PDBs
- Database Storage Overview
- Creating and Managing Tablespaces
- Improving Space Usage
- Managing Undo Data
- Creating and Managing User Accounts
- Configuring Privilege and Roles Authorization
- Configuring User Resource Limits
- Implementing Oracle Database Auditing
- Introduction Loading and Transporting Data
- Loading Data
- Transporting Data
- Using External Tables to Load and Transport Data
- Automated Maintenance Tasks- Overview
- Automated Maintenance Tasks- Managing Tasks and Windows
- Database Monitoring and Performance Tuning Overview
- Monitoring Database Performance
- Analyzing SQL and Optimizing Access Paths
FAQs
Radiant Techlearning is headquartered in the Electronic city & technology hub of Northern India, Noida, which is surrounded by several large multinational, medium & small Software companies.
We have offices located all across the country and partners across the globe.
Radiant Techlearning has a data centre containing the Virtual Training environment for the purpose of participant hand-on-practice.
Participants can easily access these labs over Cloud with the help of a remote desktop connection.
Radiant virtual labs provide you the flexibility to learn from anywhere in the world and in any time zone.
The learners will be enthralled as we engage them the real-world and industry Oriented projects during the training program. These projects will improve your skills and knowledge, and you will gain a better experience. These real-time projects will help you a lot in your future tasks and assignments.
To know about the fees details, you can email us at training@radianttechlearning.com with your requirement in detail containing the below information
In the case of Self/ Individual
- Training Program
- Training Mode (Online/ Classroom)
- Location (in case of the classroom)-
- Background (Education/ Technology/ Year of experience, etc. )
- Training Timeline
In the case of Corporate Training
- Training Program
- of Participants
- Training Mode (Online/ Classroom)
- Location (in case of the classroom)-
- Participant’s Background (Education/ Technology/ Year of experience, etc.)
- Training Timeline
- Expectations from the training program
No. These training programs are helping to improve your skills & knowledge of the technology which would help you to land your dream job by learning them.
Our training program will maximize your ability and chances of getting a successful job. You have to select a job according to your convenience. Your performance in the training program and interview is crucial for getting a good job.
Yes, your employer can pay your fees.
The learners will be enthralled as we engage them the real-world and industry Oriented projects during the training program. These projects will improve your skills and knowledge, and you will gain a better experience. These real-time projects will help you a lot in your future tasks and assignments.