Course information

Oracle 18c DBA Fundamentals​ Course Outline

Module 1: Getting Started with Database Administration

  • Types of Oracle Database Users
  • Tasks of a Database Administrator
  • SQL Statements
  • Identifying Your Oracle Database Software Release
  • About Database Administrator Security and Privileges
  • Database Administrator Authentication
  • Creating and Maintaining a Database Password File
  • Data Utilities

Module 2: Creating and Configuring an Oracle Database

  • About Creating an Oracle Database
  • Considerations Before Creating the Database
  • Creating a Database with DBCA
  • Creating a Database with the CREATE DATABASE Statement
  • Specifying CREATE DATABASE Statement Clauses
  • Specifying Initialisation Parameters
  • Managing Initialisation Parameters Using a Server Parameter File
  • Managing Application Workloads with Database Services
  • Considerations After Creating a Database
  • Cloning a Database
  • Dropping a Database
  • Database Data Dictionary Views
  • Database Configuration Assistant Command Reference for Silent Mode

Module 3: Starting Up and Shutting Down

  • Starting Up a Database
  • Altering Database Availability
  • Shutting Down a Database
  • Quiescing a Database
  • Suspending and Resuming a Database
  • Delaying Instance Abort

Module 4: Managing Processes and Memory

  • About
    • Dedicated and Shared Server Processes
    • Database and Proxy Resident Connection Pooling
  • Configuring
    • Oracle Database for Shared Server
    • Database Resident Connection Pooling
  • Managing
    • Prespawned Processes
    • Processes for Parallel SQL Execution
    • Processes for External Procedures
    • Terminating Sessions
  • Process and Session Data Dictionary Views
  • What is Memory Management and its Architecture?
  • Using Automatic Memory Management
  • Configuring
    • Memory Manually
    • Database Smart Flash Cache
  • Improving Query Performance
    • Memoptimised Rowstore
    • Oracle Database In-Memory

Module 5: Managing Users and Securing the Database

  • Importance of Establishing a Security Policy for Your Database
  • Managing Users and Resources
  • User Privileges and Roles
  • Auditing Database Activity
  • Predefined User Accounts

Module 6: Monitoring the Database and Managing Diagnostic Data

  • Monitoring
    • Errors and Alerts
    • Performance
    • Quarantined Objects
  • Oracle Database Fault Diagnosability Infrastructure
  • Investigating, Reporting, and Resolving a Problem
  • Viewing Problems with the Support Workbench
  • Adding Problems Manually to the Automatic Diagnostic Repository
  • Viewing the Alert Log
  • Finding Trace Files
  • Running Health Checks with Health Monitor
  • Repairing SQL Failures with the SQL Repair Advisor
  • Repairing Data Corruptions with the Data Recovery Advisor
  • Creating, Editing, and Uploading Custom Incident Packages

Module 7: Managing Control Files

  • What Is a Control File?
  • Guidelines for Control Files
  • Creating Control Files
  • Troubleshooting After Creating Control Files
  • Backing Up Control Files
  • Recovering a Control File Using a Current Copy
  • Dropping Control Files
  • Control Files Data Dictionary Views

Module 8: Managing the Redo Log

  • What Is the Redo Log?
  • Planning the Redo Log
  • Creating Redo Log Groups and Members
  • Relocating and Renaming Redo Log Members
  • Dropping Redo Log Groups and Members
  • Forcing Log Switches
  • Verifying Blocks in Redo Log Files
  • Clearing a Redo Log File
  • Precedence of FORCE LOGGING Settings
  • Redo Log Data Dictionary Views

Module 9: Managing Archived Redo Log Files

  • What Is the Archived Redo Log?
  • Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
  • Controlling Archiving
  • Specifying Archive Destinations
  • About Log Transmission Modes
  • Managing Archive Destination Failure
  • Controlling Trace Output Generated by the Archivelog Process
  • Viewing Information About the Archived Redo Log

Module 10: Managing Tablespaces

  • Guidelines for Managing Tablespaces
  • Creating Tablespaces
  • Consider Storing Tablespaces in the In-Memory Column Store
  • Specifying Nonstandard Block Sizes for Tablespaces
  • Controlling the Writing of Redo Records
  • Altering Tablespace Availability
  • Using Read-Only Tablespaces
  • Altering and Maintaining Tablespaces
  • Renaming Tablespaces
  • Dropping Tablespaces
  • Managing Lost Write Protection with Shadow Tablespaces
  • Managing the SYSAUX Tablespace
  • Correcting Problems with Locally Managed Tablespaces
  • Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
  • Viewing Information About Tablespaces

Module 11: Managing Data Files and Temp Files

  • Guidelines for Managing Data Files
  • Creating Data Files and Adding Data Files to a Tablespace
  • Changing Data File Size
  • Altering Data File Availability
  • Renaming and Relocating Data Files
  • Dropping Data Files
  • Verifying Data Blocks in Data Files
  • Copying Files Using the Database Server
  • Mapping Files to Physical Devices
  • Data Files Data Dictionary Views

Module 12: Transporting Data and Managing Undo

  • About Transporting Data
  • Transporting Databases
  • Transporting Tablespaces Between Databases
  • Transporting Tables, Partitions, or Subpartitions Between Databases
  • Converting Data Between Platforms
  • Guidelines for Transferring Data Files
  • What Is Undo?
  • Introduction to Automatic Undo Management
  • Managing Undo Tablespaces
  • Migrating to Automatic Undo Management
  • Managing Temporary Undo
  • Undo Space Data Dictionary Views

Module 13: Using Oracle Managed Files

  • About Oracle Managed Files
  • Enabling the Creation and Use of Oracle Managed Files
  • Creating Oracle Managed Files
  • Operation of Oracle Managed Files
  • Scenarios for Using Oracle Managed Files

Module 14: Managing Views, Sequences, and Synonyms

  • Managing Views
  • Managing Sequences
  • Managing Synonyms
  • Views, Synonyms, and Sequences Data Dictionary Views

Module 15: Managing Automated Database Maintenance Tasks

  • About Automated Maintenance Tasks and Maintenance Windows
  • Configuring
    • Automated Maintenance Tasks
    • Maintenance Windows
    • Resource Allocations for Automated Maintenance Tasks
  • Automated Maintenance Tasks Reference

Module 16: Managing a Distributed Database

  • Managing Global Names in a Distributed System
  • Creating Database Links
  • Using Shared Database Links
  • Managing Database Links
  • Viewing Information About Database Links
  • Creating Location Transparency
  • Managing Statement Transparency

Show moredowndown

Who should attend this Oracle 18c DBA Fundamentals Training Course?

The Oracle 18c DBA Fundamentals Training Course is designed for individuals seeking to enhance their Database Management skills using Oracle 18c. This Oracle Training Course will benefit various professionals, including:

  • System Administrators
  • Database Administrators
  • Application Developers
  • IT Professionals
  • Business Analysts
  • Technical Consultants
  • IT Team Leaders

Prerequisites of the Oracle 18c DBA Fundamentals Course

There are no formal prerequisites to attend this Oracle 18c DBA Fundamentals Training Course. However, a basic understanding of Database concepts, SQL fundamentals, and operating systems would be beneficial for the delegates.

Oracle 18c DBA Fundamentals Course Overview

Oracle 18c DBA Fundamentals is a comprehensive 1-day training course designed to provide aspiring and experienced Database Administrators with the essential skills and knowledge to manage and maintain Oracle 18c databases effectively. This training covers various topics, including database creation and configuration, storage management, user administration, security, backup and recovery, and performance tuning.

Proficiency in Oracle 18c DBA Fundamentals is essential for Database Administrators who want to ensure the optimal performance, availability, and security of their Oracle 18c databases. This training is particularly beneficial for IT professionals new to Oracle database administration and those looking to refresh their skills and stay up-to-date with the latest features and functionality of Oracle 18c.

This intensive 2-day Oracle Training offered by The Knowledge Academy will help delegates understand the fundamental concepts and principles of Oracle 18c database administration. They will learn how to install and configure Oracle 18c databases, manage storage structures, create and manage users and privileges, implement security measures, perform backups and recoveries, and monitor and tune database performance.

Course Objectives

  • To understand the fundamentals of Oracle 18c database administration
  • To gain hands-on experience with Oracle 18c features and functionalities
  • To learn how to create and configure Oracle Courses
  • To manage Oracle 18c users, privileges, and roles
  • To implement effective performance monitoring strategies
  • To employ backup and recovery techniques for Oracle 18c databases
  • To troubleshoot common Oracle 18c database issues
  • To prepare for the Oracle Certified Professional (OCP) exam

Upon completion of an Oracle 18c DBA Fundamentals Course, delegates will have a solid foundational understanding of Oracle Database administration, enabling them to efficiently manage and support Oracle 18c databases.

Show moredowndown

What’s included in this Oracle 18c DBA Fundamentals Course?

  • World-Class Training Sessions from Experienced Instructors   
  • Oracle 18c DBA Fundamentals Certificate
  • Digital Delegate Pack

Why choose us

Our Fleet venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

Fleet is a town located in Hampshire, England, around 30 miles from London. The population stands at about 38,000 people. The term Fleet usually includes the villages of Ancells Park, Elvetham Health, Pondtail, Crookham Village and Church Crookham. The Hart district, Fleet being the main town of this, has been voted the best place to live in the UK by the Halifax Quality of Life study on numerous occasions. This is thought to be due to the better health and weather conditions compared to other areas of the country and the high amount of leisure space and countryside. There are thirteen schools in Fleet, most of which are Infant and Primary schools, including Tweseldown Infants, Church Crookham Juniors, Elvetham Heath Primary School and Heatherside Juniors. There is one independent school which is the girls-only St Nicholas’ School. 

Nearby Locations include:

  • church crookham
  • crookham village

Show moredown

Address

Fleet

T: 01344203999

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Oracle 18c DBA Fundamentals in Fleet. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

Unlock your potential with The Knowledge Academy's Oracle 18c DBA Fundamentals in Fleet, accessible anytime, anywhere on any device. Enjoy 90 days of online course access, extendable upon request, and benefit from the support of our expert trainers. Elevate your skills at your own pace with our Online Self-paced sessions.

Experience the most sought-after learning style with The Knowledge Academy's Oracle 18c DBA Fundamentals in Fleet. Available in 490+ locations across 190+ countries, our hand-picked Classroom venues offer an invaluable human touch. Immerse yourself in a comprehensive, interactive experience with our expert-led Oracle 18c DBA Fundamentals in Fleet sessions.

best_trainers

Highly experienced trainers

Boost your skills with our expert trainers, boasting 10+ years of real-world experience, ensuring an engaging and informative training experience

venues

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

small_classes

Small class sizes

Our Classroom courses with limited class sizes foster discussions and provide a personalised, interactive learning environment

value_for_money

Great value for money

Achieve certification without breaking the bank. Find a lower price elsewhere? We'll match it to guarantee you the best value

Streamline large-scale training requirements with The Knowledge Academy's In-house/Onsite at your business premises. Experience expert-led classroom learning from the comfort of your workplace and engage professional development.

tailored_learning_experience

Tailored learning experience

Leverage benefits offered from a certification that fits your unique business or project needs

budget

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

team_building

Team building opportunity

Our offers a unique chance for your team to bond and engage in discussions, enriching the learning experience beyond traditional classroom settings

monitor_progress

Monitor employees progress

The course know-how will help you track and evaluate your employees' progression and performance with relative ease

What our customers are saying

Oracle 18c DBA Fundamentals in Fleet FAQs

Oracle 18c DBA Fundamentals is a foundational training course designed to equip database administrators with the knowledge and skills required to manage Oracle 18c databases. It covers essential topics such as database architecture, installation, configuration, backup, recovery, and performance tuning, enabling professionals to administer Oracle 18c environments efficiently.
The Oracle 18c DBA Fundamentals Training is significant as it equips you with critical knowledge to manage Oracle databases efficiently, ensuring optimal performance, data security, and system reliability. This foundational training is crucial for aspiring database administrators and IT professionals.
There are no formal prerequisites for this Oracle 18c DBA Fundamentals Training Course. However, delegates should have a basic understanding of Database concepts, SQL fundamentals, and operating systems.
This course is ideal for aspiring Database Administrators, IT Professionals, and System Administrators who want to gain foundational knowledge in Oracle 18c database management and enhance their skills in database administration and performance tuning.
Yes, The Knowledge Academy offers 24/7 support via phone & email before attending, during, and after the course. Our customer support team is available to assist and promptly resolve any issues.
In this training course, delegates will have intensive training with our experienced instructors, a digital delegate pack consisting of important notes related to this course, and a certificate after course completion.
This course takes 2-day to complete during which delegates participate in intensive learning sessions that cover various course topics.
You should receive the confirmation details for the course within 24-48 hours after registration. If you haven't received it by then, please check your spam folder or contact our support team for assistance.
Yes, the Oracle 18c DBA Fundamentals course is suitable for beginners. It provides a comprehensive introduction to database administration, covering foundational concepts and practical skills necessary for managing Oracle 18c databases effectively.
In the Oracle 18c DBA Fundamentals Training Course, you'll gain essential database architecture, installation, configuration, backup, recovery, and performance tuning skills, empowering you to effectively manage and maintain Oracle 18c databases within your organisation.
Yes, after completing this course you will receive a certificate of completion to validate your achievement and demonstrate your proficiency in the course material.
Taking the Oracle 18c Database Administration Fundamentals Training offers a comprehensive understanding of database management, enhancing your installation, configuration, and maintenance skills. This course boosts your career prospects by equipping you with essential, industry-relevant expertise.
The Knowledge Academy provides flexible self-paced training for this course. Self-paced training is beneficial for individuals who have an independent learning style and wish to study at their own pace and convenience.
Yes, we provide corporate training for this course, tailored to fit your organisation’s requirements.
If you face any issues accessing the course materials, you can reach out to our customer support team who will provide you with quick assistance to resolve the issue.
After completing the Oracle 18c DBA Fundamentals training, you can pursue roles such as Oracle Database Administrator, Database Analyst, Data Architect, or IT Consultant, where you'll manage, optimise, and secure Oracle databases in various organisational settings.
The Oracle 18c DBA Fundamentals Certification Training is designed for beginners and intermediate-level professionals, making it accessible to those new to database administration while still offering valuable insights and skills for those with some prior experience.
The Knowledge Academy in Fleet stands out as a prestigious training provider known for its extensive course offerings, expert instructors, adaptable learning formats, and industry recognition. It's a dependable option for those seeking this course.
The training fees for Oracle 18c DBA Fundamentals certification in Fleet starts from £2495
The Knowledge Academy is the Leading global training provider for Oracle 18c DBA Fundamentals.
Please see our Oracle Training courses available in Fleet
Show more down

Why choose us

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo

Looking for more information on Oracle Training?

backBack to course information

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on 01344203999 and speak to our training experts, we should be able to help you with your requirements.

cross

OUR BIGGEST SUMMER SALE!

Special Discounts

red-starWHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.