|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-database-programming-for-wincc-scada-engineers/
课程评论：没有评论
课程名称：WinCC SCADA工程师的SQL数据库编程 课程概述：本课程是为WinCC SCADA工程师设计的全面入门课程，旨在帮助学习者创建和部署支持数据库的SCADA应用程序。SQL及相关数据库技术是任何制造或工艺工厂的重要组成部分，掌握数据库技术的SCADA工程师在工业软件应用中始终保持高需求。作为在工业软件应用开发领域拥有30年经验的专家，我可以告诉你，我部署的所有SCADA应用程序中，有一半以上都应用了本课程中的技能和技术。 在本课程中，你将学习如何利用Microsoft SQL Server、SQL编程语言、Visual Basic脚本(VBScript)和ActiveX数据对象(ADO)来创建强大的基于数据库的WinCC SCADA应用程序。你将学习如何在Microsoft SQL Server管理工作室中创建和管理数据库、表、视图及查询，掌握Transact SQL (T-SQL)编程语言的基本知识，编写简单和复杂的SQL查询。你还将学习如何在WinCC的VBScript中嵌入SQL查询，利用ADO添加、管理和删除Microsoft SQL Server中的数据。 此外，你将学习如何创建与SQL Server数据库交互并显示数据的WinCC屏幕和对话框，以及如何使用SQL在WinCC布局编辑器中生成报告。课程还提供可重用的VBS代码函数和实例，学员可以将其直接应用于任何WinCC SCADA应用程序，以快速构建与生产数据库交互的脚本和屏幕，这些内容的价值远超过课程的价格！成功完成本课程后，你将具备利用SQL编程、VB脚本和WinCC构建下一个SCADA应用程序的能力。
This comprehensive beginner's course for WinCC SCADA engineers will put you on the path to creating and deploying database enabled SCADA applications! SQL and related database technology are a vital part of any manufacturing or process plant floor; SCADA engineers with expertise in leveraging database technology for their industrial software applications are always in demand. As a 30-year veteran of successfully building industrial software applications, I can tell you that fully half of all SCADA applications I have deployed use the skills and techniques you will learn in this course. You will learn how to leverage Microsoft SQL Server, the SQL programming language, Visual Basic Scripting (VBScript) and ActiveX Data Objects (ADO) to create powerful database-driven WinCC SCADA applications. You'll learn to create and manage databases, tables, views and queries in Microsoft SQL Server Management Studio. Master the basics of the Transact SQL (T-SQL) Programming language, writing simple and complex SQL queries. Embed SQL Queries in WinCC's Visual Basic Scripting Language using ADO to add, manage and delete data in Microsoft SQL Server. Create WinCC screens and dialogs that interact with and display data from SQL Server databases. You will learn to generate reports using SQL in the WInCC Layout Editor. As part of this course, you will also receive reusable VBS code functions and examples that you can drop into any WinCC SCADA application to quickly build scripts and screens that can interact with your production databases; these alone are more than worth the price of this course! After successfully completing this course, you will have the skills to leverage the power of SQL programming, VB Script and WinCC for your next SCADA Application.
