Type
Virtual
Classroom ILT
Skill Level

Available dates
Learning Path
Virtual
Duration
1 Day

TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL

DURATION
AVAILABLE DATES
Introduction
This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. 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. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
Audience profile
Data Warehouse Administrators, Database Administrators, Database Designers, Support Engineers and Administrators
Pre-requisites
Before attending this course, students must have:
- Working knowledge of SQL and use of PL/SQL packages
- Basic knowledge of Linux Operating System
Course objectives
After completing this course, students 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
Course content
Lesson 1: Introduction to Oracle Database |
Lesson 2: Accessing an Oracle Database |
Lesson 3: Creating an Oracle Database by Using DBCA |
Lesson 4: Creating an Oracle Database by Using a SQL Command |
Lesson 5: Starting Up and Shutting Down a Database Instance |
Lesson 6: Managing Database Instances |
Lesson 7: Oracle Net Services: Overview |
Lesson 8: Configuring Naming Methods |
Lesson 9: Configuring and Administering the Listener |
Lesson 10: Configuring a Shared Server Architecture |
Lesson 11: Configuring Oracle Connection Manager for Multiplexing and Access Control |
Lesson 12: Creating PDBs from Seed |
Lesson 13: Using Other Techniques to Create PDBs |
Lesson 14: Managing PDBs |
Lesson 15: Database Storage Overview |
Lesson 16: Creating and Managing Tablespaces |
Lesson 17: Improving Space Usage |
Lesson 18: Managing Undo Data |
Lesson 19: Creating and Managing User Accounts |
Lesson 20: Configuring Privilege and Role Authorization |
Lesson 21: Configuring User Resource Limits |
Lesson 22: Implementing Oracle Database Auditing |
Lesson 23: Introduction to Loading and Transporting Data |
Lesson 24: Loading Data |
Lesson 25: Transporting Data |
Lesson 26: Using External Tables to Load and Transport Data |
Lesson 27: Automated Maintenance Tasks: Overview |
Lesson 28: Automated Maintenance Tasks: Managing Tasks and Windows |
Lesson 29: Database Monitoring and Tuning Performance Overview |
Lesson 30: Monitoring Database Performance |
Lesson 31: Analyzing SQL and Optimizing Access Paths |
Associated certifications and exam
This course prepares students to write Exam 1Z0-082
On successful completion of this course students will receive an Oracle University attendance certificate.

Oracle Overview
Torque IT considers authorised Oracle training to be an integral part of any Oracle Solaris, Oracle Enterprise Linux, Oracle Applications, Java development, or Oracle Database implementation. Oracle authorized training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve.
Our instructor led training provides customers with a hands-on experience to match job role requirements and prepares delegates for Oracle Certification exams. From in-class demonstrations to hands-on-labs, Torque IT’s authorised Oracle instructor led training provides our customers with a comprehensive and dynamic learning experience.
Oracle certifications are universally recognized as demonstrating a high level of expertise and credibility for individuals and the organizations that employ them. Authorised Oracle training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, developing and managing Solaris, Java, and Oracle Database solutions.
Torque IT is recognised by Oracle as an Oracle University Training Centre which means that we offer our clients internationally recognised and globally accredited Oracle training and certification. These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise.
Torque is recognised by Oracle, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in technology that will prepare the next generation of IT industry professionals to exploit Oracle Solutions.