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:
The Oracle Database 18c: Administration Workshop Ed 1 course provides you with a firm foundation in administration of an Oracle database. In this course, you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner.
Audience profile:
This course is intended for:
- Administrator
- Architect
- Database Administrator
Course objectives:
After completing this course, students will be able to:
- Describe Oracle Database architecture
- Explain 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
Lesson 1: Introduction |
Lesson 2: Oracle Database Architecture |
Lesson 3: Introduction to Oracle Database Cloud |
Lesson 4: Creating Oracle Database Cloud Service (DBCS) Deployments |
Lesson 5: Accessing an Oracle Database |
Lesson 6: Managing DBCS Database Deployments |
Lesson 7: Managing Database Instances |
Lesson 8: Oracle Net Services |
Lesson 9: Administering User Security |
Lesson 10: Creating PDBs |
Lesson 11: Creating Master Encryption Keys for PDBs |
Lesson 12: Creating and Managing Tablespaces |
Lesson 13: Managing Storage Space |
Lesson 14: Managing Undo Data |
Lesson 15: Moving Data |
Lesson 16: Backup and Recovery Concepts |
Lesson 17: Backup and Recovery Configuration |
Lesson 18: Creating Database Backups |
Lesson 19: Performing Database Recovery |
Lesson 20: Monitoring and Tuning Database Performance |
Lesson 21: SQL Tuning |
Torque IT specializes in providing our Clients with Vendor authorized instructor-led training, enablement IT courses, and certification solutions.
Associated certifications and exam:
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.