Excitech - Training Course.pdf

About Global Documents

Global Documents provides you with documents from around the globe on a variety of topics for your enjoyment.

Global Documents utilizes edocr for all its document needs due to edocr's wonderful content features. Thousands of professionals and businesses around the globe publish marketing, sales, operations, customer service and financial documents making it easier for prospects and customers to find content.

ARCHIBUS Understand database importing exporting data COURSE Create MSSQL

Bristol                          Enfield                          Central London                          Leatherhead                          Manchester                          Glasgow
t: 0845 370 1444                                                                © 2008. Excitech Ltd. All Rights Reserved                                             www.excitech.co.uk/training
COURSE DESCRIPTION
Training Course Outline
Excitech Ltd. Design Technology Centre, 8 Kinetic Crescent, Innova Business Park, Enfield, Middlesex, EN3 7XH.
PRE-REQUISITES
COURSE OBJECTIVES
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.
This course is designed for an experienced ARCHIBUS user.
The following prerequisites apply:- 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.
Upon completion of this course, 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
Duration 1 Day          Course Code AFM/MSSQL
Course Costs
Not available as a scheduled course
ARCHIBUS System Admin (MSSQL)