ESAMI Offices
 
 
 
Information Communication Technology

The ICT programme has been widely acclaimed as one of the most competitive programmes in the region.
The programme covers specializations in the areas of Hardware, Software and Design in addition to equipping
the student with a wide range of skills and knowledge necessary for any Information Technology professional.

Course Title: ORACLE DATABASE ADMINISTRATION

Apply Online
Venue: ESAMI Headquarters, Arusha, TANZANIA  
Learning Duration:  2 weeks 
Starting: 27 Mar 2023  Ending: 7 Apr 2023
Fees: 1500 USD
Payment Details: To cover tuition and training materials only.

COURSES OVERVIEW
The goal of this course is to cover oracle architecture and internal mechanisms such that participants are able to perform basic DBa tasks such as database creation, start up and shutdown, and database management. The course also covers oracle networking basics and the oracle utility programmes.

WHO SHOULD ATTEND?
The course is designed to provide oracle professionals with an in-depth understanding of the features of oracle including sql fundamentals, object-orientation, partitioning and advanced oracle features for the internet.

HOW PARTICIPANTS WILL BENEFIT
At the end of the course, participants will be able to
• Explain the roles and duties involved in oracle database management and administration;
• Perform oracle dba tasks.

TOPICS INCLUDE:
Sql fundamentals; architecture & configuration; instance architecture; oracle instance internals; using sql for dba management; control file; undo and redo management; user and privilege
management; oracle database management; initialization file managemen; oracle*net configuration, data buffer configuration & sizing, oracle object management; oracle indexes; oracle constraints; schema; file & table space management; database maintenance, oracle dba utilities; monitoring oracle; dictionary and v$ views, table & index monitoring; workload & trend monitoring; instance monitoring; oracle environment monitoring; statspack and awr performance management; performance management; bottleneck performance analysis; instance tuning; sql and cbo behavior; tracing sql execution; sql execution internals; sql tuning; oracle high availability tools, backup & recovery.

 

 

Course No:  2023-03-27-3-10-3459

Apply Online

ANNOUNCEMENTS

ESAMI COURSES RUNNING IN DUBAI FROM JUNE - DECEMBER, 2022

7 Jun 2022
  DUBAI COURSES: JUNE – DECEMBER, 2022     ESAMI is inviting applications for the following short courses that are scheduled to run in Dubai, UAE from June to December 202...

2022 ESAMI BUSINESS SCHOOL ACTIVITY CALENDAR

7 Feb 2022
     2022 BUSINESS SCHOOL ACTIVITY CALENDAR     PROGRAMME STARTING DATES S/N VENUE PROGRAMME STARTING DATE INTAKE 46 EVENING ...
View More
 

Short Courses Calendar

bullet
bullet

DOWNLOADS

 
 
 
facebook   twitter