Computer Courses from, Keimos - IT Training Services

Computer  Training Courses Spacer image

IT Training Courses  Spacer image
Customised IT Training for

Individuals, IT Professionals and Businesses

To talk to us, Call 01492 623887

 
Not found what you are looking for then search the full catalogue of courses
Oracle Approved Courswear

Oracle9i Database Fundamentals II

The Oracle9i Database Fundamentals II Curriculum introduces students to backup methods for Oracle9i database administration. The backup concepts covered include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. This curriculum also covers the Oracle9i database recovery concepts, to include recovery with and without archiving, recovery of offline and online databases, recovery with missing data files, and incomplete recovery with and without archiving. Participants will learn about the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This curriculum also discusses the configuration of the Oracle Shared Server and Oracle Names Server.

Audience

The intended audience for this curriculum include Database administrators, IT managers, and technical professionals.

Course Curriculum

This first part of the course introduces students to backup methods for Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as RMAN, standard SQL*Plus commands, and the Oracle Enterprise Manager Console. Students assess the status of critical database files using SQL*Plus commands. In addition, students create a standby database, identify the steps involved in synchronizing a standby database, and activate, refresh, and update a standby database.

Learn To

  • Identify the factors to consider when defining a backup and recovery strategy.
  • Multiplex control files by copying them with an operating system utility.
  • Place a log member from two log groups in a specific directory.
  • Identify the implications of operating an Oracle database in NOARCHIVELOG mode.
  • Change the state of an archiving location using the Enterprise Manager Console.
  • Sequence the steps to perform a closed database backup.
  • Identify the parameter used to multiplex files with the backup command.
  • Create a standby database by using SQL* Plus.

Top

The second part of the course introduces students to Oracle9i database recovery concepts. The recovery concepts course includes recovery with and without archiving, recovery of offline and online databases, recovery with missing data files, and incomplete recovery with and without archiving. Additional concepts covered by this course include time-based recovery, cancel-based recovery, recovery manager components, recovery manager commands, export and import utilities, user managed recovery, fast-start on demand rollback, recovery manager report generations commands, maintaining the recovery manager catalog along with failure points, and troubleshooting recovery problems.

Learn To

  • Identify the files to be restored for a database in the NOARCHIVELOG mode.
  • Store the archived logs in a new location using the ALTER SYSTEM command.
  • Perform a offline database recovery.
  • Recover a database that failed due to the loss of a data file without a backup.
  • Perform a time-based recovery operation.
  • Recover a database that has failed due to the loss of current redo logs in an online database.
  • Create an export file using the command line interface.
  • Import objects into a schema by using the command line interface function.

Top

The last part of this course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server.

Learn To

  • Sequence the steps required for a client to establish a connection to an Oracle server.
  • Match the client and server network components required to perform specific tasks on a Web application client implementation.
  • Identify the features of automatic instance registration.
  • Configure a local net service name by using the Oracle Net Configuration Assistant.
  • Identify the tasks performed to implement an LDAP Proxy naming method.
  • Identify the benefits of using the Oracle Shared Server configuration.

Top


Delivery

Computer Based Training (CD-ROM) and Manual

Content

Interactive, skills-based with practical examples

Duration

Approx 40 hours

Qualifications

This curriculum will help candidates prepare for the Oracle9i OCP DBA Certification and is mapped to Exam 1Z1-032.

Pre-requisites

Students should have completed both Oracle9i SQL, exam 1Z0-007 and Oracle9i Fundamentals 1- exam 1Z0-031

Follow on Courses

This is ideal intoductory course for individuals who wish to go on to learn about Oracle9i Performance Tuning - exam 1Z0-033


Click here to get a free information pack

Need to talk to somebody about the Courses? Then call us on 01492 623887


Distance learning/Self Study

All courses are designed to offer you the student the convenience of studying from the comfort of your own home or workplace, working at your own pace in the way that is most suited to your lifestyle and career commitments. Working at your own pace means that you are more likely to learn the subject in-depth as you are not under pressure to compete with other students who may be better or worse than, so you will never lag behind or be waiting for somebody to catch up.

Keimos Database Courses

Our courses use simulations extensively to provide opportunities for students to learn & practice skills-based content. This “learning by doing'” model is far more effective than the traditional true/false, multiple choice approach. Live application software is not needed.

Interactive content is used often in the courses to engage the learner's attention, to reinforce and exercise skills being taught, and to provide feedback on the learner's grasp of a skill or concept.


Top

Oracle Courses



Site Designed by Keimos©1997-2008

Valid XHTML 1.0! Valid CSS! .

database operations manager

The work

A database operations manager is responsible for organising, operating and maintaining information in a database. Databases store information such as customer names and addresses, stock records or accounts. Many organisations use databases including:

Database managers have a range of responsibilities including: They are also responsible for making sure that users understand the need to comply with the Data Protection Act.

They work closely with systems analysts in making changes to the database. Overall systems design decisions are performed by systems analysts; detailed database design is performed by database operations managers.

An organisation’s information needs change, so knowledge of the latest technology to recommend improvements to the system is important. Database operations managers work closely with information technology (IT) managers on a day-to-day basis.

Skills and Interests

As a database operations manager, you should:

Entry

There is no single route to becoming a database operations manager - the main requirements are having the right knowledge, skills and experience for the job. Qualifications are an important part of demonstrating these, and although a degree is often required, there are many other recognised academic and vocational qualifications.

Whilst the larger graduate recruiters may take trainees from any discipline, smaller employers generally require knowledge in specific computer languages, software packages or operating systems. Many employers will require a good honours degree. For others, experience in programming will help.

Many database operations managers move into this work from the business side of an organisation. However, they must have some experience in systems programming or systems design, and they often have a degree or higher national award, which can be in any subject. Experience can be just as important as qualifications for many jobs.

Training

The majority of training is on the job, supplemented by short internal or external courses as appropriate, and progress will be helped by taking additional manufacturers courses. Some IT companies offer specific certifications in their products.

Graduate Apprenticeships in IT may be available for people in England. These integrate study at degree or diploma level with structured work-based learning.

Many young people enter IT work directly through Modern Apprenticeships at Foundation and Advanced level, or Skillseekers and Modern Apprenticeships in Scotland. There are no set entry requirements but employers will want to be sure that applicants are motivated, enthusiastic and can benefit from the training.

Opportunities

Opportunities can arise within any organisation that makes use of computerised databases.

Specialist information technology bureaux, which provide a database service to clients, also employ database operations managers.

Managers can progress in their career by moving to another employer for a post with greater responsibility. Alternatively, they might transfer their skills to other areas of computing work, such as systems analysis, network management or general management.

Self-employment or freelance work is sometimes possible, and there are an increasing number of experienced database operations managers who do contract work.

Databases

Oracle8i/9i (DBA)

Curriculum is designed to give the Oracle Database Administrator (DBA) a firm foundation in basic administrative tasks and provide the necessary knowledge and skills to set up, maintain, and troubleshoot an Oracle8i database. Participants will learn about the concepts of relational databases and the SQL and PL/SQL programming languages, database administration strategies and procedures provided in Oracle8i, the critical skills for planning and implementing database backup and recovery strategies.

MCDBA

The Microsoft Certified Database Administrator is specifically for professional who implement and administer Microsoft SQL Server databases. Individuals who derive database designs, manage and maintain databases, configure and manage security and install and configure Microsoft SQL Server would benefit from this course.