logo-img

Seat reservation

Oops! No seats reserved yet.
loading..



(603) 852 79 35 akasi-commercial@akasigroup.com 1, Tara boulevard # 101, Nashua NH 03062 United States
(603) 852 79 35 akasi-commercial@akasigroup.com 1, Tara boulevard # 101, Nashua NH 03062 United States
0

Course details

Optimising And Protecting Oracle Databases

Course 00172
Beginner
3 days
PDF
Wishlist:
Share
Category: Oracle Database

Description

Among the best database management systems (DBMS), Oracle Database is recognised for its performance, scalability and security, both on site and in the Cloud. both on site and in the Cloud. It also stands out for its ability to manage very large volumes of data. This level of technical This level of technical performance has been achieved through extensive research and expertise at Oracle. Nevertheless, to get the most out of Oracle Database, it is important to know how to optimise and secure it. In this training course, you will learn the skills you need to optimise and protect optimise and protect your databases and master database administration.

What you'll learn

  • Optimising and protecting Oracle databases
  • Optimising SQL queries
  • Choosing the right infrastructure for Oracle databases
  • Know how to optimise the server and its resources (storage and diagnostic processes)
  • Know the solutions available for optimising and protecting Oracle databases
  • Have the right database administration attitude
  • Make good use of performance measurement tools

Targeted audience

  • • Database and system administrators
  • • IT Managers
  • • CISOs
  • • Developers wishing to extend their knowledge or learn about best practices for optimising and protecting Oracle databases, as well as anyone wishing to implement an Oracle database

Pre-requisites

  • • Pre-Requisite 1: Knowledge of database architecture in general and the Oracle database in particular. Pre-Requisite 2: Knowledge of the RDBMS
  • • Knowledge of the RDBMS

Curriculum

Knowing which infrastructure is best suited to your architecture

Understanding the advantages and disadvantages of each infrastructure

Explore the main infrastructures

Understanding their licensing

The fundamental procedures to follow to optimise performance

The importance of following the different optimisation procedures

Desired and acceptable performance objectives

Setting up the System Global Area (SGA)

Managing the size of data blocks in memory

Optimising and sizing the System Global Area (SGA)

Set up the Program Global Area (PGA)

Implement automatic management of the SGA and PGA

Using the trace function in the server process

Applying an optimisation strategy

Set up the autotrace session, sqldeveloper, database control for the execution plan

Trace an SQL query

Analyse the current session and other instances

Introduction to the AWR (Automatic Workload Repository) reporting tool

Presentation of the performance collection tool ADDM (Automatic Database Diagnostic Monitor analysis)

Defining the optimisation strategy

Generating SQL queries

Optimising SQL queries manually

Using the ‘UNDO’ tablespace

Optimising logging and the size of log files

Managing spaces in tables

Reorganising segments

Using the ‘dbms_compression’ package

Security recommendations

Database access control

Managing database deletion access rights

Configuring Advanced security

Mastering TDE

Managing database core updates

Good database upgrade practic

Managing the Oracle Database Security Assessment Tool (DBSAT)

Mastering the company's security posture and taking account of recommendations

Install and Configure Oracle Audit Vault and Database Firewall (AVDF)

Installing and configuring Data Safe

Using RMAN

Get this Course

1226,00 €

  • • 3 days instructor-led training course
  • • After-course coaching available

  • Apr 23, 2025 - Apr 25, 2025
    08:30 AM - 05:00 PM UTC
    Abidjan or Virtual
    RESERVE SEAT