Automated databases of automated process control systems

Теми тижня

• 

  Abstruct

  Summary of the educational component:  The goal is to provide future specialists with knowledge about information models and management systems for banks (DBs) and databases (DBs) in instrumentation, road and transport industries, relational and distributed ACS databases, ACS database administration processes, ACS database query languages, ACS database software application architecture.  

  • The news Форум
  • Forum for mutual assistance Форум
• 

  Topic 1. The concept of DBMS. Data models. The relational model. Features of database design in the road industry and instrumentation.

  
  

  • Forum for Topic 1 Форум
• 

  Topic 2. Normal forms. The relationship. Key.

  
  

  • Forum for Topic 2 Форум
• 

  Topic 3. SQL statements for creating a database.

  
  

  
  

  • Forum for Topic 3 Форум
• 

  Topic 4. Relational operations in SQL

  
  

  • Forum for Topic 4 Форум
• 

  Topic 5. Stored SQL procedures and functions

  • Forum for Topic 5 Форум
• 

  Topic 6. Transactions. The level of isolation. Blocking

  • Forum for Topic 6 Форум
• 

  Topic 7. Link integrity. Foreign keys. Indexing

  • Forum for Topic 7 Форум
• 

  Topic 8. Database Administration. Protection of database data in the road industry and instrumentation.

  • Forum for Topic 8 Форум