Excitech

ARCHIBUS System Admin - Oracle

Excitech
In Enfield

Price on request
Prefer to call the centre directly?

Important information

Typology Training
Location Enfield
Duration 1 Day
  • Training
  • Enfield
  • Duration:
    1 Day
Description


Suitable for: Designed for an experienced ARCHIBUS DBA user

Facilities (1)
Where and when
Starts Location
On request
Enfield
8 Kinetic Crescent, Innova Business Park, Middlesex, England
See map
Starts On request
Location
Enfield
8 Kinetic Crescent, Innova Business Park, Middlesex, England
See map

To take into account

· Requirements

• Previous attendance of an ARCHIBUS Basic database course • Previous attendance of at least 3 other ARCHIBUS module courses • Full understanding of AutoCAD software • Competent in the use of MS-Windows An understanding of Facilities Management • Sound experience of Database concepts and Oracle • Database Development or programming experience essential

Questions & Answers

Ask a question and other users will answer you

Course programme

Focuses on administering the System Security Levels and Customisation.

This course aims at providing the basis for customising ARCHIBUS. The course covers issues like database configuration, altering existing tables, indexing and importing/exporting data.

Upon completion, the user will have an understanding of the following:

  • Understand Client/Server networks
  • Understand and use ODBC connections
  • Configure Databases
  • Create and alter new tables
  • Create new Primary and Foreign keys
  • Create and alter validation columns
  • Alter existing Primary and Foreign keys
  • Change columns attributes
  • Adding indexes to columns
  • ARCHIBUS AFM-License.xml
  • Fully understand the Installation Process of ARCHIBUS
  • ARCHIBUS Process and Roles
  • ARCHIBUS ini Configuration
  • Manipulate the Navigator Tool
  • Create new table Views
  • Manipulate table Views
  • Understand security issues
  • Enable security and create Groups
  • Understand and use the Oracle Net Configuration tool
  • Understand and Use the Oracle SQL Plus tool
  • Uploading Oracle DMP Files
  • ARCHIBUS Ora AFM.P1 Table Spaces
  • Check database integrity
  • Backing up data
  • Recover data
  • Importing/exporting data


Compare to choose better:
See all