Video Training / IT and Programming for PC Tutorials →SQL Database Programming for WinCC SCADA Engineers

Leverage SQL programming, VBScript and WinCC to create powerful database-driven SCADA applications.
What you'll learn:
Install and Use Microsoft SQL Server Management Studio
Create & Manage SQL Server Databases, Tables and Data
Create Database Diagrams and Views with SQL Server Management Studio
Use Structured Query Language (SQL) to Query Database Tables
Use SQL to Insert, Update and Delete Data in SQL Server databases
Write VBScripts in WinCC that leverage SQL Programming for your SCADA application
Build WinCC Screens that interact with SQL Server Databases
Learn to use SQL Aggregate Functions, JOINS and Sub Queries
Learn to leverage SQL Queries in generating reports in WinCC Reports Designer
Requirements:
A PC with WinCC version 7.4 or higher installed.
No prior WinCC, SQL or VBS experience required; I will teach you what you need to know.
Description:
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.
Who this course is for:
Industrial application engineers interested in leveraging the power of SQL Programming and databases into their WinCC SCADA Applications
Homepage

https://www.udemy.com/course/sql-database-programming-for-wincc-scada-engineers/