MS Office Access Training - Database modelling in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.
325.-/d
ID : 645
Goal : Provide attendees with the appropriate knowledge and tools (RDBS, SQL...) to analyze corporate data. The attendees will be able to plan appropriate steps for database design. They will also learn the basic and essential terminology for database management.
Audience : Users needing to create a database with MS Access or any other database software.
Prerequisites : Have a logical mind.
Goals :
- Introduction
- Database design steps
- Available tools on the market for database modelling and management
- Various layouts of a database (architecture)
- Digital data types (text, number, etc.)
- Entity-Link Model (DCM: Data Conceptual Model)
- Determine to be managed corporate data
- Group corporate data as entities (1st, 2nd and 3rd normal form)
- Identify data defining an entity (primary key, foreign key)
- Identify links between entities (using foreign keys)
- Define links cardinality (one to one, one to many, many to many) and integrity
- Migrating from DLM (Data Logical Model) to DDT (Data Design Model)
- Define joints in analysis
- Training Conclusion
Pedagogical method : 90% theorical based training with PDF support document. Eventually examples done with MS Visio or Access.
Suggested duration for presentiel training (days) : 0.5
Suggested duration for on-line training (days) : 0.6
Daily price in face-to-face : 325 CHF
Daily price in remote : 156 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 1625 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).
Tags : database, access, visio, ms access, ms visio, database modelling, design scheme, er scheme, relations, referential integrity , sql server, oracle, db2, mysql , database modelisation trainings.