ESAMI Offices
 
 
 

Short Courses

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.

Sorry,the application deadline for this course has expired.

Course Title: Oracle Database Administration

Venue: ESAMI Headquarters, Arusha, TANZANIA  
Learning Duration:  2 Weeks 
Starting: 12 Mar 2018  Ending: 23 Mar 2018
Fees: 1500 USD
Payment Details: To cover tuition and training materials only.

COURSE OVERVIEW

The course 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.

 

WHO SHOULD ATTEND

This course is designed for the computer professional who needs to understand the concepts and architecture of Oracle. These include Oracle developers, Oracle DBAs, Oracle web developers, database administrators and any computer professionals who need to understand the architecture of an Oracle database. The participants should have an understanding basic relational database concepts such as SQL before enrolling in this training.

 

HOW PARTICIPANTS WILL BENEFIT

The goal of this course is to cover the Oracle architecture and internal mechanisms such that participants are able to perform basic DBA tasks such as database creation, startup and shutdown, and database management. The course also covers Oracle networking basics and the Oracle utility programs.

By the end of this course the participants will be able to:

  • Explain 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*Plus for DBA management,

  • Control file,

  • UNDO and REDO management,

  • User and privilege management,

  • Oracle database management,

  • Initialization file management,

  • 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:  2018-03-12-3-10-1960

PROGRAMME ANNOUNCEMENTS

BUSINESS SCHOOL CALENDAR FOR 2018

2 Jul 2018
  BUSINESS SCHOOL CALENDAR FOR 2018   ESAMI Business School is inviting applications for its degree programmes scheduled to commence as below.     DBA COMMENC...
View More
 

Short Courses Calendar

bullet

CENTERS

bullet

DOWNLOADS

 
 
 
facebook   twitter