Level 2 Using Databases & Scripting in Projects

Use your SQL and Python knowledge to enhance your projects

Course Length: 4 Days

What You’ll Learn

Take your existing SQL and Python knowledge and use it in Ignition. In this class students will create project resources built around existing database data. Design bi-directional data displays, process JSON objects, and use complex Perspective components while exploring error handling. Students will work with multiple data sets to focus on understanding the data and creating useful Ignition resources based on it. By the end of this class, students will be able to enhance existing displays, design projects to modify SQL databases while maintaining data integrity, and plan scalable scripting/SQL strategies.

Highlights From This Class

Get a snapshot of the main concepts and skills you’ll learn:

  • Intermediate SQL/Python for querying, importing libraries, and transforming data
  • Working with related database tables
  • Error handling
  • Component events and working with complex components
  • Project scripting libraries, custom gateway logging, and documentation skills
  • Batch inserts, message handling, and component message handlers

Explore the full curriculum below.

Who is This Class For?

This class is for those that can read and write basic SQL queries or basic programs in Python or other object-oriented programming languages and want to integrate these skills directly into their Ignition Project design.

Prerequisites

This is a Level 2 class, prior experience with Ignition is required and Core Certification is recommended.

Suggested Preparation

    • Working knowledge of SQL and Python languages or completing the Level 1 DB&S class.
    • Completed Inductive University.
dbproject

Daily Schedule

Arrive on Day 1: 7:30 AM – 8:00 AM

  • Morning Session: 8:00 AM – 12:00 PM
  • Lunch: 12:00 PM – 1:00 PM
  • Afternoon Session: 1:00 PM – 5:00 PM

We recommend booking departing flights no earlier than 6:00 PM.

lunch-ignition-class

Level 2 Using Databases & Scripting in Projects

TOPICS COVERED

Intermediate SQL and Python

Design Complex Queries For Tailored Result Sets

Managing Sets of Linked Database Tables

Classify the Relationship Between Key Columns in Different SQL Tables to Query and Update Your Database While Maintaining Data Integrity

Data Transformation

Develop Scripts to Transform Query Data Into Perspective Object Properties

Error Handling

Implement Error Handling Techniques to Write Scripts That Respond to and Recover From Errors

Component Events

Fine-Tune the User Experience and Control Exactly How Data is Queried and Updated Using Component Events to Write Scripts That Add Enhanced Features and Functionality to Your Applications.

Importing Python libraries

Import Third-Party Python 2 Libraries to Extend Ignition’s Built-In Scripting Functions

Working With Complex Components

Write SQL Queries and Python Scripts to Generate Sets of Complex Objects to Dynamically Populate Perspective Properties

Processing and Generating Complex Objects

Write Scripts That Interact With Members and Methods of Complex Objects

Custom Gateway Logging

Add System Functions to Scripts to Write to the Gateway Wrapper Logs With Information, Warning, or Error Logs

Find and Read Existing Documentation

Identify and Effectively Implement Information From Public Documentation on Ignition Concepts, SQL & Python Syntax, and Other Systems

Project Scripting Library

Create Project-Global Functions and Objects To Use Across All Project Scripts

Batch Inserts

Improve Efficiency By Planning and Building Mechanisms To Control Batch Inserts to the Database

Message Sending & Component Message Handlers

Synchronize Data Flow and Displays Across a Session or Across Multiple Sessions With Component Message Handlers

Value Change Scripts

Run Specific Instructions When the Value of a Property Changes

Have questions?

For more information, please contact us by clicking “Send Us A Message!”

SEND US A MESSAGE!