Categories

Summary

Databases represent a set of information that includes everything related to the company in full details of internal expenses, external financial transactions, transactions and tenders held during a specified period of time in addition to a full archive of all that has been achieved since the establishment of the company. 

These rules link the information and make the administrative work and analysis of the general position of the company is easy so the organization of such data must be very precise and strict. 

The British Academy for Training and Development provides a training course in ORACEL database administration in the department to anyone who wants to learn advanced and modern methods of managing databases within companies or institutions. 

Objectives and target group

Who should attend? 

  • Managers and directors of companies. 
  • Managers of administrative departments in companies. 
  • Managers of data collection and storage departments within companies. 
  • Employees in data management departments within institutions and companies. 
  • All employees within the administrative technological work sector. 
  • All employees within the computer software business sector. 
  • Students and academics who wish to develop their capacity to create databases. 

 

How attendees will benefit? 

After completion of the Training Programme, delegates will be learned to: 

  • Advance Knowledge on Oracle Database-Administration 
  • Oracle 12C basic concepts 
  • Data guard configuration and there different type installation 
  • ASM knowledge and configuration part 
  • Backup in Oracle database 
  • Different recovery real time scenarios 
  • Performance Tuning Basics 
  • Basics of RAC and High Availability 
  • Oracle 18C database Installation and Administration 
  • New trending topics will be added soon based on demand also 

Course Content

  • Core DBA 
    • How to open GUI in putty session 
    • Create,Delete Oracle Services using Oradim Utility 
    • How to Set Environment in Oracle Windows Server- Set ORACLE_HOME & ORACLE_SID 
    • How to start,stop database . 
    • How to change DBID in oracle 
    • How to change DB Name in Oracle 
    • How to rename datafile in Oracle 11G 

 

  • RAC (Real application cluster) 
    • How to create Non-Container Database-Oralcle 12C Administration 
    • Create Pluggable database using DBCA-Oracle 12C Administration 
    • How to create Pluggable database Manually-Oracle 12C database administration 
    • How to start/stop/Basic of Pluggable database-Oracle 12C administration 
    • How to Rename Pluggable Database-Oracle 12C Administration 
    • How to Drop Pluggable database - Oracle 12C Administration 
    • How to take backup of container-pluggable database 

 

  • Dataguard 
    • Check if Primary database is in Sync with Standby in Dataguard 
    • Snapshot Standby Database Introduction 
    • How to convert Physical standby database to Snapshot Standby Database 
    • How to convert SnapShot to Physical Standby database 
    • Swichover introduction in Oracle Dataguard 

 

  • ASM (Automatic Storage management) 
    • Oracle 12C Administration 
    • Oracle 12C download and Prerequisite 
    • Installation of Oracle 18C database on Windows Server 
    • How to connect to EM(Enterprise manager) Express with Oracle 12C database 

 

  • RMAN Backups 
  • Logical Backups 
  • Monitoring Tools  
  • Basic understanding of ITIL Process 

Course Date

2020-09-21

2020-12-21

2021-03-22

2021-06-21

Course Cost

Note / Price varies according to the selected city

Members NO. : 1
£3700 / Member

Members NO. : 2 - 3
£2960 / Member

Members NO. : + 3
£2405 / Member

Related Course

Featured

SQL Server Training Programme

2020-08-24

2020-11-23

2021-02-22

2021-05-24

£3700 £3700