This course will cover the use of databases in business and how they are used in daily operations and to drive business decisions. Students will gain introductory experience with database setup, backup and maintenance, and data import, export and integration. Organizations collecting and storing data is not enough. Data for decision making needs to be analyzed to identify trends and outliers. Students will be introduced to SQL scripting, data analysis tools and ways of visually displaying data. Microsoft Power BI suite of tools will be used for live dashboards, charts, and printed reports. |
Along with the advanced control systems that are appearing throughout the country, the revolution of graphical software to make it possible to control a very complex system has evolved. This course will cover the basics of using a graphical software package to create a user friendly control screen. The basics of using this type of software to interface with PLC's either directly or using an OPC server will be covered. The graphical software packages used in the SCADA lab are FactoryTalk, Ignition and WonderWare. Prerequisite: successful completion of all SCADA courses previously required up to this point. |
Knowing how to install, configure, and troubleshoot a computer network is a highly marketable and exciting skill. This course first introduces the fundamental building blocks that form a modern network, such as protocols, media, topologies, and hardware. It then provides in-depth coverage of the most important concepts in contemporary networking, such as TCP/IP, Ethernet, wireless transmission, virtual networks, security, and troubleshooting. After completing this course and completing the exercises, students will be prepared to select the best network design, hardware, and software for an environment. Students will also master the skills to build a network from scratch and maintain, upgrade, troubleshoot, and manage an existing network. This course culminates in the opportunity to test for CompTIA’s Network+ N10-006 certification. Prerequisite: successful completion of all SCADA courses previously required up to this point. |
Continuation of SD 159 and an introduction to programmable automation controllers (PACs) primarily using the Allen-Bradley Logix controllers and Studio 5000 programming software. Study the use of Siemens and other industrial controllers. Advanced ladder logic and discrete I/O instructions, counters, timers, network control of remote IO and motor drives, motion control, program development techniques and troubleshooting are covered. Skills will be reinforced by using a variety of software simulation and mock process models. Prerequisite: successful completion of all SCADA courses previously required up to this point. |