Semos Education Semos Education
  • Monday - Friday 9:00AM - 10:00PM
  • Call us now +44 7487633466
  • Keep in touch info@semosedu.com
EN / МК / RS
Кошничка
reserve a seat
  • Description
  • Content
  • Target Audience
  • Benefits
  • Certificates

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database.

 

In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

MODULE 1

Introduction

 

MODULE 2

Introducing Oracle Database Architecture

 

MODULE 3

Database instance management

 

MODULE 4

Oracle network environment configuration

 

MODULE 5

Management of database storage structures

 

MODULE 6

Manage user security

 

MODULE 7

Managing concurrent access to data

 

MODULE 8

Data cancellation management

 

MODULE 9

Oracle Database Audit Implementation

 

MODULE 10

Database maintenance

 

MODULE 11

Performance management

 

MODULE 12

Performance management: SQL debugging

 

MODULE 13

Resource management with Resource Manager

 

MODULE 14

Automating tasks with Oracle Scheduler

 

MODULE 15

Site management

 

MODULE 16

Backup and recovery concepts

 

MODULE 17

Data transfer

 

MODULE 18

Working with Oracle support

  • Administrator
  • Architect
  • Database Administrator

Benefits to you:

 

  • Describe Oracle Database architecture
  • Configure the database to support your applications
  • Manage database security and implement auditing
  • Implement basic backup and recovery procedures
  • Move data between databases and files
  • Employ basic monitoring procedures and manage performance

Course attendance certificate issued by Semos Education

Description

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database.

 

In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Content

MODULE 1

Introduction

 

MODULE 2

Introducing Oracle Database Architecture

 

MODULE 3

Database instance management

 

MODULE 4

Oracle network environment configuration

 

MODULE 5

Management of database storage structures

 

MODULE 6

Manage user security

 

MODULE 7

Managing concurrent access to data

 

MODULE 8

Data cancellation management

 

MODULE 9

Oracle Database Audit Implementation

 

MODULE 10

Database maintenance

 

MODULE 11

Performance management

 

MODULE 12

Performance management: SQL debugging

 

MODULE 13

Resource management with Resource Manager

 

MODULE 14

Automating tasks with Oracle Scheduler

 

MODULE 15

Site management

 

MODULE 16

Backup and recovery concepts

 

MODULE 17

Data transfer

 

MODULE 18

Working with Oracle support

Target Audience
  • Administrator
  • Architect
  • Database Administrator
Benefits

Benefits to you:

 

  • Describe Oracle Database architecture
  • Configure the database to support your applications
  • Manage database security and implement auditing
  • Implement basic backup and recovery procedures
  • Move data between databases and files
  • Employ basic monitoring procedures and manage performance
Certificates

Course attendance certificate issued by Semos Education

Past experiences

What people say about us

  • - Marko Krstevski Microsoft .NET Academy

    Seeking to expand my knowledge, I decided to enroll in Semos Education, where I am gaining the necessary knowledge and experience.

  • - Teodor Markovski Student

    The desire to become a Cloud architect led me to Semos Education. I am thrilled by the positive experiences of former students and the way in which the instructors and Career Center take care of the students.

  • - Viktorija Georgieva Summer Mentorship Program for Python Develope

    The reputation of Semos Education for quality training and the opportunity to learn from experienced instructors played an additional significant role in my decision.

  • - Borche Peltekovski Accredited Academy for Graphic Design

    After completing my studies at Semos Education, I envision myself working in a technology company, such as Samsung, Apple, or a company of similar caliber.

  • - Vasilija Uzunova Oracle Certified Instructor

    For me, there was no other choice but Semos Education. I want to be part of the best, I want to share my knowledge in a company that is global, and ours.

Meet the instructors

  • Biljana Barukchieva  

    Senior project manager

    @Quinshift

     

    20+ years of experience