• Database Management for Industrial Automation and Control Systems (EA05)


    Length: 2 days
    CEU Credits: 1.4
    Course Hours: 8:00 a.m.-4:00 p.m.


    Learn the ways in which information is stored, managed and protected in a modern Industrial Automation and Control System (IACS), including how to access and manipulate that information and what steps can be taken to safeguard and ensure the availability of that information. This course provides a specific introduction to relational database technologies and techniques. This course provides a basic explanation of the technologies and terminology of information storage, manipulation, and exchange, which makes it especially beneficial to personnel responsible for the support and administration of an IACS and for integrating such systems into the plant and corporate business systems. 

    You will be able to:

    • Identify how information is represented and stored in an industrial automation and control computer system, including how bulk storage is organized into files and directories
    • Contrast and compare the various mechanisms used for exchanging data between applications programs and data sources, in the same or separate computers, such as open control (OPC), XML, and others
    • Describe and differentiate the various types and categories of tables used to store information in a typical IACS
    • Describe the difference between a real-time database and other types of IACS databases
    • Design a basic set of relational database tables and a scheme that describes them
    • Create basic relational and "flat" database tables using commercial software tools
    • Use the Standard Query Language (SQL) to create, populate, and query a relational database of your own design and creation
    • Evaluate the security and reliability of critical IACS databases and understand both architectural and cybersecurity mechanisms for improving both

    You will cover:

    • Data Representations: Binary Data | Different Ways to Represent a Number | Floating and Fixed Point | ASCII Data/Textual Data | Date and Time
    • Database Structures: Data Structures and Records | Data Types | Organizing Records | Keys and Sorting
    • Database Types: Computer Files | Bulk Storage | File Systems | Application Data Files | Real Time Databases
    • Database Tables: Fixed Size Static and Dynamic | Extensible Tables | Circular Tables | IACS Use of Databases
    • Data Relationships
    • Relational Databases: Standardized RDBMS Language | SQL Language
    • Basics of Database Design
    • Database Operations
    • Data Storage and Retrieval
    • Special Requirements of Real Time Databases
    • Database Software
    • Data Documentation
    • Database Maintenance
    • Data Security and Availability
    • Data Exchange Mechanisms: Files | HTML | ODBC | OPC | XML | SQL | JDBC | ADO

    Lab and Classroom Exercises:

    • Create and manipulate data in "flat" tables
    • Create a Microsoft Access Database
    • Use mySQL to create and populate a relational database
    • Use SQL to query and manipulate a relational database

    If you wish to register offline, download the Training Registration Form, complete, and return to ISA with your payment.

    Not sure this particular course is for you?
    pre-instructional survey is available for you to evaluate your level of understanding of the course material and to show you the types of questions you'll be able to answer after completing the course.