ARCHIBUS System Admin - MSSQL

Short course

In Enfield

Price on request

Description

  • Type

    Short course

  • Location

    Enfield

  • Duration

    1 Day

Suitable for an experienced ARCHIBUS user.

Facilities

Location

Start date

Enfield (Middlesex)
See map
8 Kinetic Crescent, Innova Business Park

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Focuses on administering the System Security Levels and Customisation. Aims at providing the basis for customising ARCHIBUS.

Covers issues like database configuration, altering existing tables, indexing and importing/exporting data.

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 MSSQL Query Analyzer.
  • Understand and Use the SQL Enterprise Manager.
  • Uploading SQL MDF files.
  • ARCHIBUS SQL scripts.
  • Check database integrity.
  • Backing up data.
  • Recover data.
  • Importing/exporting data.

ARCHIBUS System Admin - MSSQL

Price on request