ORACLE DATABASE ADMINISTRATION

The Oracle Database is the most flexible, scalable, reliable, fast and secure data management platform available in the market. Today’s Oracle Database offers more cost and performance management features than ever before, whether you run it in your data center on your hardware, run it Cloud at Customer, or run it in the Oracle Public Cloud. Oracle University partners with experts from product development, consulting and our own industry leading customers to provide you instruction, insight and best practices to get the most of out the Oracle Database.

Oracle Database Training will:

  • Help you choose which deployment architecture works for your data management situation.
  • Teach you the skills you need to install, configure, design and troubleshoot database systems.
  • Demonstrate how to use advanced features or the Oracle Database to extend it for your data management solution.

Course targetting to those students who wanted to start there carier as Oracle Database administaration.

 
 
 
Intoduction
 
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
 
How to change Archive destination in Oracle
 
How to start,stop,Reload Listener in Oracle
 
Alert log file in Oracle
 
How to recover missing control file
 
How to recover missing data files
 
Spool file in Oracle
 
How to set Static Ip address
 
Basic Unix command for Oracle DBA
 
Export Import Table in oracle
 
Parfile in oracle
 
How to Install SQL developer tool
 
How to Create Pfile to SPFile and Vice-Versa
 
Parameter Files in Oracle – PFile and SPfile
 
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
 
Migration from Non-Container Database to Pluggable Database-PART I- Oracle 12C
 
Migration from Non-Container Database to Pluggable Database-PART II- Oracle 12C

This training course uses both conventional and non-traditional techniques. It utilises small group and facilitated plenary discussions as well as instruction to explore key concepts, models, tools and techniques. Hands-on exercises and case studies are used to practice the application of knowledge and use of skills. Structured reviews provide the opportunity to consider how the learning can be applied to the delegates’ own work.

  • D.McKINSEY AND ASSOCIATES Ltd Certificate of Completion for individuals who attend and completes’ ORACLE DATABASE ADMINISTRATION course.
  • Candidates who desire International Certifications shall be registered through our platform for such an examination.

4 WEEKS

D.Mckinsey is licensed to train and issue certificates by the following bodies;

–           Nigerian Council for Management Education, (CMD).

–           OGTAN (Oil and Gas Trainers Association of NIGERIA).

Kindly confirm space availability by calling +234 (0) 8023192104 or +234 (0) 9062386530 or send an email to info@dmckinseyandassociates.com, dmckinseytraining@gmail.com.   For In-House training programs / on request, please contact us using above contact details.

fEB 4-28

Close Menu