1 Course Introduction (8.04 MB)
2 Download & Install WinCC SCADA + SQL Server (37.35 MB)
3 Download & Install Microsoft SQL Server Management Studio (22.48 MB)
4 Import the BatteryCo Course Database (17.28 MB)
6 Write Your First SQL Query! (10.48 MB)
1 Section 2 Overview (8.89 MB)
10 Insert Data using SSMS and SQL (66.81 MB)
2 What is a Relational Database (69.97 MB)
5 What Is Structured Query Language (SQL) and Transact SQL (T-SQL) (51.68 MB)
7 The Production Defect Tracking Project (37.16 MB)
8 Creating the Database, Tables and relationships (64.87 MB)
1 Section Overview (6.29 MB)
10 Inserting, Updating and Deleting Table Data (207.18 MB)
2 The SQL Select Statement (65.5 MB)
4 Limiting and ordering query results using Where and Order By (89.84 MB)
6 Using math operators and Cast with Select Queries (50.16 MB)
8 Using In Between and Like Clauses (63.45 MB)
1 Section overview (11 MB)
10 Using the ADO Command Object (139.3 MB)
12 Create VBScript Functions for Data Entry, Table Management and Visualization (282.07 MB)
2 Create a WinCC Project (28.29 MB)
4 Your First WinCC VBScript using SQL with ADO (98.96 MB)
6 Configuring the ADO Connection Object (134.09 MB)
8 Handing Errors with VBScript (83.33 MB)
1 Section Overview (7.06 MB)
10 Using The ADO Errors Collection for more informative error handling (97.12 MB)
12 Next Topics (11.04 MB)
2 Using the WinCC WebBrowser and MSHFLexGrid Control to Visualize Data (140.15 MB)
4 Build the Defect Tracking Overview Screen And Interfaces Part 1 (216.67 MB)
6 Build the Defect Tracking Screens and Operator Interfaces, Part 2 (299.62 MB)
7 Update the Defect Tracking View (100.96 MB)
1 Section Overview (8.68 MB)
2 SQL Aggregate Functions (122.79 MB)
4 The SQL JOIN Statement (203.44 MB)
6 SQL Sub Queries (77.2 MB)
1 Section overview (5.9 MB)
2 Using SQL in WinCC Reports Designer (166.86 MB)
4 Create a WinCC Screen to generate and preview reports (74.57 MB)