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.
This course 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.
Course Objectives
By the end of the course, participants will be able to:
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 theredifferent 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 Outline
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