Oracle DBA (Database Administration)

Uplatz offers end-to-end training on Oracle DBA. This is video-based online course (self-paced training). You will be awarded Course Completion Certificate at the end of the course.

Databases form the backbone of every modern organization's information infrastructure.

The Oracle Database, one of the most widely adopted relational database systems globally, plays a critical role in storing, processing, and securing enterprise data. As organizations increasingly rely on Oracle to handle mission-critical operations, the demand for skilled Oracle Database Administrators (DBAs) continues to grow.

This Oracle 12c Database Administration course by Uplatz provides a comprehensive, self-paced video-based training designed to equip you with the foundational skills and hands-on experience needed to configure, manage, and support Oracle 12c databases. Whether you're starting out in database administration or looking to upskill in Oracle environments, this course will guide you through core DBA responsibilities and best practices.

Oracle 12c (12 Cloud) introduced major innovations in multi-tenancy, cloud integration, and performance optimization. It is widely used by mid-to-large enterprises for its scalability, reliability, and security features. Oracle DBAs are essential in maintaining the health and performance of enterprise data systems across virtually every industry sector.

By the end of this training, you will be able to:

• Create and configure Oracle 12c databases from scratch

• Manage users, roles, and privileges to ensure data security

• Implement backup and recovery strategies, including Flashback operations

• Monitor and optimize database performance using Oracle tools

• Administer storage structures for efficient data handling

• Automate tasks using Oracle Enterprise Manager (OEM) Cloud Control 12c

• Implement partitioning techniques for managing large datasets and indexes

This course is ideal for:

• Aspiring Database Administrators

• IT professionals seeking Oracle DBA certification

• System Administrators transitioning to a database role

• Developers who want a stronger understanding of Oracle database environments

• Anyone interested in enterprise data management and infrastructure

Certificate of completion

Digital certificate - Included

Oracle DBA - Course Syllabus

• Overview of RDBMS and Oracle architecture

• Key features and enhancements in Oracle 12c

• Understanding multi-tenant architecture (CDB & PDB)

• Installation of Oracle Database software

• Oracle tools: SQL*Plus, RMAN, Enterprise Manager, DBCA

• Database components: Instance, SGA, Background Processes

• Logical storage structures: Tablespaces, Segments, Extents, Blocks

• Physical storage structures: Datafiles, Redo logs, Control files

• CDB and PDB structure and management

• Creating a database using DBCA and SQL commands

• Managing initialization parameters and server configuration files

• Startup and shutdown procedures

• Using Oracle Enterprise Manager Cloud Control 12c

• Managing database users, roles, and profiles

• System and object privileges

• Password management and account policies

• Auditing user activity and database access

• Creating and managing tablespaces

• Managing datafiles and tempfiles

• Using Automatic Storage Management (ASM)

• Resizing and relocating datafiles

• Tablespace monitoring and space management

• Backup strategies: full, incremental, and archive log backups

• Using Recovery Manager (RMAN)

• Performing complete and incomplete recovery

• Flashback Technology: Flashback Query, Table, and Database

• Configuring Archivelog mode and retention policies

• Database performance diagnostics tools

• Managing memory and CPU usage

• Using AWR, ADDM, and ASH reports

• Monitoring locks, waits, and resource contention

• SQL tuning basics and optimizer statistics

• Configuring Oracle Net Services

• Managing listener and tnsnames.ora

• Database connectivity using SQL Developer

• Establishing secure database connections

• Managing tables, indexes, and constraints

• Implementing table and index partitioning

• Benefits of partitioning large datasets

• Maintenance and query optimization with partitions

• Cloning databases using RMAN and DBCA

• Managing software patches using OPatch utility

• Overview of Oracle Data Pump for export/import

• Working with transportable tablespaces and data movement

• Design and deploy a secure Oracle 12c database

• Implement backup/recovery for a multi-tenant database

• Performance tuning case study using AWR/ADDM reports

• Scenario-based exercises for day-to-day DBA tasks

• Aspiring Database Administrators (DBAs)
  Individuals aiming to start a career in database administration using Oracle technologies.

• System and Network Administrators
  Looking to transition into database roles or gain cross-functional expertise in managing enterprise systems.

• IT Professionals and Support Engineers
  Who manage infrastructure and want to add Oracle DBA skills to their portfolio.

• Software Developers and Application Engineers
  Interested in understanding how databases are configured, maintained, and tuned for performance.

• Students and Graduates in Computer Science/IT
  Seeking hands-on, job-ready skills in Oracle and enterprise database management.

• Data Analysts and Data Engineers
  Wanting to build foundational knowledge in relational databases and backend data handling.

• Technical Project Managers / Team Leads
  Overseeing Oracle database projects or deployments, needing functional knowledge of Oracle 12c.

• Freelancers and Consultants
  Offering Oracle DBA services or managing database projects for clients.

Passion and determination to achieve your goals!

• Oracle Database Administrator
• Oracle Developer
• Data Engineer
• Database Administrator
• Application Developer
• Data Architect
• Oracle Engineer
• Cloud Database Engineer

Currently there are no Q&As for this course. Be the first to ask a question.