Categories

Oracle Database Training for Oracle DBA-Fundamentals and Advanced


Summary

Almost in every organization, you will find Database Administrator's (DBA's) to maintain the organization's database. Becoming a good DBA depends on the knowledge you have in the overall architecture of Oracle Database.

Oracle DBA certification is associated with the relational database management system. The role of Database Administrators includes managing huge volumes of data in large enterprises. Hence, Oracle DBA professionals are in great demand. This training course will provide you with the necessary skills to take on jobs as Database Administrators in top companies.

Objectives and target group

Who should attend? 

  • Software Developers and IT Professionals.
  • Database Analysts and Administrators.
  • SQL Programmers and Architects.
  • Project Managers.
  • Those aspiring for a career in Oracle DBA.

How attendees will benefit? 

After completion of the course, delegates will learn: 

  • Core database concepts.
  • Role of a Database Administrator.
  • SQL and PL/SQL concepts.
  • Physical and logical structure of a database.
  • Introduction to table space.
  • Configuring and managing Oracle Network.
  • Database configuration and programming.
  • Installation and harnessing cloud and storage management.
  • Database best practices and scripts.
  • Preparing for Oracle DBA certification.

Course Content

  • Oracle Database Explorer.
  • Oracle SQL Explorer.
  • Oracle Database 19c: Administration Learning Path:
    • UNIX and Linux Essentials.
    • Fundamentals for Devs and SysAdmins.
    • Administration Workshop.
    • Backup and Recovery.
    • Multitenant Architecture.
  • Oracle Database 19c: High Availability:
    • Clusterware Administration
    • ASM Administration Workshop
    • RAC Administration Workshop
    • Data Guard Administration Workshop
  • Oracle Database 19c: Performance Management:
    • SQL Workshop
    • SQL Tuning Workshop
    • Performance Management and Tuning
  • Oracle Database 19c: Partitioning in Data Warehouse
  • Oracle Database 19c: Security:
    • Security Fundamentals
    • Data Confidentiality
    • Data Encryption
    • Monitoring and Maintaining a Secure Environment
  • Oracle Database: New Features
  • Application Server:
    • Weblogic Server 12c: Administration I
    • Weblogic Server 12c: Administration II
  • Enterprise Manager Cloud Control
  • Deploy, Patch and Upgrade
  • Detective Controls
  • Preventive Controls
  • Oracle Golden Gate
  • Selected topics from OCM Courses
  • Big Data: Getting Started
  • Data Analysis and Machine Learning
  • Credentials:
    • Oracle Database SQL Certified Associate.
    • Oracle Database Admin (OCA).
    • Oracle Database Admin (OCP).

Course Date

2024-07-15

2024-10-14

2025-01-13

2025-04-14

Course Cost

Note / Price varies according to the selected city

Members NO. : 1
£4600 / Member

Members NO. : 2 - 3
£3680 / Member

Members NO. : + 3
£2852 / Member

Related Course

Istanbul
Approved

SAP Fiori Element Development

2024-06-24

2024-09-23

2024-12-23

2025-03-24

£4600 £4600

$data['course']