Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us

Glossary

Password needed Newsgroup

Remote Support system

Admin Training

Back | Level back

 

Objective

Areas covered include Installation, Setup and Administration of the EULANDA® ERP and the SQL Server. The various installation scenarios are treated extensively, as well as connecting external workstations, electronic data transfer and the Internet. The participants will learn how to handle safety precautions, data backup's and restore. After having participated he / she should be able to create new users and user groups. The participants learn how to use SQL Server tools like the Enterprise Manager, the Query Analyzer and the DTS Agent. In addition an introduction of the Query language T-SQL is given. This knowledge enables the administrator to customize the EULANDA® ERP and create server-side jobs. The training provides many examples and requires profound knowledge on PC's in general and the operating systems Window® 2000 and Windows® XP.

 

Course Information

Max. no. of participants 8
Equipment Each participant work on individual PC's
Duration 1 day
Food and Beverages Convention beverages, snacks and a three course business lunch are included.
Price 320.- EUR plus VAT. per person. Clients with a Software subscription receive 5% discount. All classes are exclusively for professionals only.
Registration Register...

 

Agenda

The AdminTraining is planned for one day and require profound knowledge on PC's in general and the operating systems Window® 2000 and Windows® XP. T-SQL knowledge is not needed but it would be helpful if basics are present.

  • The Client- / Server-concept
  • Installation of the SQL-Server (Full version)
  • The Installation of the EULANDA® ERP in the net
  • Network layers and their properties
  • Authentication methods
  • Connecting via leased line
  • Remove the software
  • Break 10 min
  • Enterprise Manager (EM) Basics
  • Transaction protocols
  • Back up
  • Restore
  • Exercise: Create a backup job
  • SID of the database users
  • Transfer databases via EM
  • Time controlled server jobs
  • Server maintenance with EM
  • Compendium of the EULANDA® ERP database
  • Hard- and software tuning
  • Luncheon
  • The Query Analyzer
  • The SQL-Designer
  • SQL-query language (basics)
  • Exercise: Analyze connected tables
  • Exercise: Data exchange using own data sources
  • Exercise: Alter prices of a given rebate group
  • Break 10 min
  • Security concept of the database
  • Excel-interface and the SQL-Server
  • User roles and rights
  • Create users
  • Integrate NT-Users
  • Exercise: Create negative roles
  • Exercise: User with negative roles
  • The DTS Agent
  • Alter DTS packages
  • Administrator scripts in the SQL Designer
  • Q&A

 

Further Information

Admin course                       Download as PDF-file
Registration or per   Download as PDF-file