Oracle 18c DBA Fundamentals in Columbia

Home

Courses

Oracle Training

Oracle 18c DBA Fundamentals

Columbia

Learn how to create and manage storage structures
Create and manage database cloud service database deployments
Get an understanding of how to manage Oracle cloud users, privileges, and roles

Dates & Prices Dates & Prices

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 Initialization Parameters
Managing Initialization 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

Memoptimized 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

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 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 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.

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 Columbia 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.

Columbia is a community based in Maryland, USA. It is in Howard County and has a population of around 100,000 people. It is repeatedly voted as one of the ‘best places to live in America’ by CCN Money. There are a range of public schools in Columbia, the majority of which are operated by Howard County Public School System. The high schools include Hammond High School and River Hill High School. There are no traditional universities or colleges in Columbia but there is a community college; Howard Community College and several further education establishments have facilities in the area such as University of Phoenix and American Career Institute. Howard Community College was established in 1966 and enrols around 28,000 students a year. It offers programs over a range of seven academic subjects; arts and humanities, business and computers, workforce development, languages, health sciences, mathematics, science and engineering and teacher education. The unemployment rate in Columbia is at 4.7%. This has improved slightly since last year’s rate of 5.5%.

Address

8160 Maple Lawn Blvd
Suite 200
Fulton
Maryland
20759

T: +1 7204454674

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Oracle 18c DBA Fundamentals in Columbia. 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.

Learn more in our FAQs

Unlock your potential with The Knowledge Academy's Oracle 18c DBA Fundamentals in Columbia, 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.

Learn more in our FAQs

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

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

Maximise your training budget

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

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 employees progress

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

Learn more in our FAQs

What our customers are saying

Oracle 18c DBA Fundamentals in Columbia FAQs

What is Oracle 18c DBA Fundamentals?

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.

What is the significance of Oracle 18c DBA Fundamentals Training?

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.

What are the pre-requisites for taking this Oracle 18c DBA Fundamentals Course?

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.

Who should attend this course?

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.

Do you offer 24/7 support for the Oracle 18c DBA Fundamentals Online Course?

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.

What is included in the course?

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.

What is the duration of this course?

This course takes 2-day to complete during which delegates participate in intensive learning sessions that cover various course topics.

How long until I receive the course confirmation details?

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.

Is the Oracle 18c DBA Fundamentals course suitable for beginners?

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.

What will I learn in this Oracle 18c DBA Fundamentals Training Course?

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.

Will I receive a certificate upon completing this training?

Yes, after completing this course you will receive a certificate of completion to validate your achievement and demonstrate your proficiency in the course material.

What are the benefits of taking this Oracle 18c Database Administration Fundamentals Training?

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.

Do you provide self-paced learning for this Oracle 18c DBA Fundamentals Online Course?

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.

Do you provide corporate training for this course?

Yes, we provide corporate training for this course, tailored to fit your organisation’s requirements.

Whom should I contact if I am unable to access this course?

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.

What kind of jobs can I expect after completing this training?

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.

What is the difficulty level for this Oracle 18c DBA Fundamentals Certification Training?

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.

Why choose The Knowledge Academy in Columbia over others?

The Knowledge Academy in Columbia 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.

What is the cost/training fees for Oracle 18c DBA Fundamentals in Columbia?

The training fees for Oracle 18c DBA Fundamentalsin Columbia starts from $3195

Which is the best training institute/provider of Oracle 18c DBA Fundamentals in Columbia?

The Knowledge Academy is the Leading global training provider for Oracle 18c DBA Fundamentals.

What are the best Oracle Training courses in Columbia?

Please see our Oracle Training courses available in Columbia

Why choose us

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.

Many delivery methods

Flexible delivery methods are available depending on your learning style.

High quality resources

Resources are included for a comprehensive learning experience.

"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

Looking for more information on Oracle Training?

Back to course information

Upcoming classes
Package deals

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 +1 7204454674 and speak to our training experts, we should be able to help you with your requirements.

Book now