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 I

The Oracle9i Database Fundamentals I Curriculum covers the database administration strategies and procedures provided in Oracle9i. This curriculum introduces the participants to the concepts and procedures associated with Oracle architectural components, the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this curriculum teaches users the procedures for managing segment free space, undo space, temporary segments, and indexes. Lastly participants will learn the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data, and the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.

Audience

The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals.

Course Curriculum

The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by using OEM and the steps to start and shut down an instance. This course also explains the various dynamic performance views and initialization parameters and the globalization support that is provided.

Learn To

  • Identify the memory structures of the SGA and the information stored in the database and nondatabase files.
  • Identify the connection procedures and the processes generated during database connection.
  • Identify the stages in processing a query and the memory structures used in query processing.
  • Identify the steps of DML processing and the memory structures involved in DML processing.
  • Identify the uses of SCN and the features of a process commit.
  • Identify the tasks of a DBA and the Oracle Enterprise Manager tools used by a DBA.
  • Identify the OEM console components, steps to set up these components, and the functions of the OEM DBA tools.
  • Identify the default DBA user accounts and set up authentication methods to validate users.
  • Identify the parameters stored in the parameter file, their uses, and the rules followed while specifying the parameters.
  • Identify the tasks performed in the stages of instance startup and shutdown.
  • Identify the characteristics and parameters of dynamic performance views and display the current parameter values by using V$PARAMETER.
  • Modify a dynamic initialization parameter by using the Oracle Instance Manager and manage user sessions by using the Oracle Instance Manager.
  • Identify the characteristics of trace and alert files, the parameters controlling the trace files, and the contents of alert files.
  • Identify the character-encoding schemes and the reasons for choosing the national character sets for the database.
  • Identify the database initialization parameters, the derived NLS parameters, and the way to control the sort sequence.
  • Retrieve the data dictionary information about the character sets and the NLS settings.

Top

The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to create and maintain databases. The course also covers the new features of Oracle9i, such as Oracle Managed Files and Undo tablespaces, and the new features of the LogMiner utility.

Learn To

  • Discuss the guidelines for creating an OFA structure and the information in the ORACLE_HOME subdirectories.
  • Identify the requirements and factors considered while creating a database, the guidelines for planning the physical database design, the registry entries that must be specified for proper database functionality, and create a password file.
  • Identify the types of parameter files, create a parameter file by editing settings in the init.ora file, and start an instance in the NOMOUNT mode.
  • Identify the command options of the CREATE DATABASE command, the situations in which it fails, create a database by using the CREATE DATABASE command and identify its content after creation.
  • Identify the benefits of using Oracle-Managed Files and manage data files, control files, and online redo log files using OMF.
  • Describe the data dictionary structure, identify the data dictionary categories, and retrieve data dictionary information.
  • Execute catproc.sql and identify the uses of administrative scripts categories.
  • Identify the properties of stored procedures and packages, the benefits of using stored program units, and the functions of Oracle-supplied packages.
  • Retrieve information about stored objects, identify the common situations when dependent objects may have an INVALID status, and the functions of the control file with the types of information stored.
  • Retrieve control file information, multiplex a control file, and identify the uses of redo log groups, the features of members, and the parameter values of redo log files.
  • Identify the situations in which log switches and checkpoints occur, force log switches and checkpoints, and identify the functions of parameters that control the checkpoints.
  • Identify the features of archive modes and retrieve information about the archive modes and online redo log groups and members.
  • Plan the number and size of online redo log files, maintain redo log members and groups, and troubleshoot LGWR errors.
  • Identify the logical database structure and the types of tablespaces, create, resize, and change the properties of a tablespace by using Oracle Enterprise Manager.
  • Create read-only tablespaces and drop tablespaces, identify the benefits of multiple tablespaces, and specify storage parameters and retrieve data dictionary information.
  • Identify the features of undo tablespaces and manage undo tablespaces.

Top

The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary segments, and indexes.

Learn To

  • Identify the types of segments in the storage hierarchy.
  • Identify the benefits, working, and packages of automatic management of segment free space.
  • Identify the ways in which extents are controlled by segments.
  • Identify the block space utilization parameters.
  • Retrieve storage structure information.
  • Identify the purposes and the types of rollback segments.
  • Explain the processes that rollback segments follow for transactions.
  • Plan, create, and acquire rollback segments.
  • Modify and remove rollback segments.
  • Retrieve rollback segment information from the data dictionary.
  • Describe the solutions to rollback segment problems.
  • Explain the concepts of automatic management of undo space.
  • Identify the purpose and the features of the various types of temporary segments.
  • Retrieve temporary segment information from the data dictionary.
  • Maintain indexes.
  • Monitor indexes.

Top

This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.

Learn To

  • Identify the row storage method used by the various tables and the components of the row structure in an Oracle database.
  • Identify the features of the Oracle datatypes and ROWID.
  • Identify the guidelines for creating tables and the situations resulting in row chaining, and create tables.
  • Identify the characteristics of table parameters and high-water mark, change the parameter value, manually allocate extents, validate table structure and detect row migration.
  • Identify the effects of truncating a table, drop and truncate a table, and deallocate free apace.
  • Retrieve the table, extent and row location information from data dictionary.
  • Identify the features of index-organized tables and alter tables.
  • Identify the various types of database triggers and the methods to disable and enable the triggers.
  • Identify the guidelines for implementing constraints and create the two types of constraints.
  • Disable, enable and drop constraints and triggers in the validate and the novalidate mode, and identify the steps for using the EXCEPTIONS table.
  • Retrieve constraint, constraint columns, PK-FK relationship information and trigger information by using Oracle SQL*Plus Worksheet.
  • Load data by using direct-load inserts, identify the concepts associated with SQL*Loader, and use SQL*Loader to load data into tables.
  • Identify the uses of the export and import utilities, the export modes, and the export paths.
  • Reorganize data using export and import, identify the features and process of transportable tablespaces and the restrictions while using them.

Top

This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.

Learn To

  • Define and maintain the five components of the security domain of a user in a given environment.
  • Define and maintain a named set of resource and password limits.
  • Demonstrate the use of resource limits and how to set them.
  • Manage system and object privileges.
  • Control the administration of privileges in a database.
  • Demonstrate the use of concepts and skills to keep track of the various events occurring in an Oracle9i database.

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-031.

Pre-requisites

Students should have completed Oracle9i SQL - exam 1Z0-007 or Oracle8i SQL exam 1Z0-001

Follow on Courses

This is ideal intoductory course for individuals who wish to go on to learn about Oracle9i Fundamentals II - exam 1Z0-032

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


Oracle8i OCDA

Oracle9i DBA OCA

Oracle9i DBA OCP

Oracle9i: SQl

Oracle9i: Fundamentals 1

Oracle9i: Fundamentals 2

Oracle9i: Performance Tuning

Oracle Database 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.