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

IBM DB2 Universal Database V6.1 Administration

The Complete IBM DB2 Universal Database V6.1 Administration Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 510.

Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQLStudents will also learn how to plan, implement and maintain new and existing DB2 databases.

This curriculum will help candidates prepare for the ILT exams DB2 UDB Fundamentals and DB2 UDB Administration Workshop for Windows NT.

Audience

These courses are intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc, prior to taking this courseLimited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM Certified Solutions Expert Certification Database Administration exam 510.

Fundamentals

  • Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features
  • Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes
  • Master basic Structure Query Language (SQL)
  • Manage database operations.

Administration

  • Implement a new DB2 database or application
  • Maintain an existing DB2 database.

Delivery

Computer Based Training (CD-ROM)

Content

Interactive, skills-based with full testing for exam preparation

Duration

Approx 20 hours

Qualifications

IBM Certified Solutions Expert Certification Database Administration exam 510

Pre-requisites

Microsoft Access or Database Fundamentals or relevant experience


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 commitmentsWorking 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 contentThis “learning by doing'” model is far more effective than the traditional true/false, multiple choice approachLive 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

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 databaseDatabases store information such as customer names and addresses, stock records or accountsMany 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 databaseOverall 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 importantDatabase 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 jobQualifications 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 systemsMany employers will require a good honours degreeFor others, experience in programming will help

Many database operations managers move into this work from the business side of an organisationHowever, 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 subjectExperience 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 coursesSome IT companies offer specific certifications in their products

Graduate Apprenticeships in IT may be available for people in EnglandThese 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 ScotlandThere 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 responsibilityAlternatively, 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 databaseParticipants 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 databasesIndividuals who derive database designs, manage and maintain databases, configure and manage security and install and configure Microsoft SQL Server would benefit from this course.