Skip to main content

Intro to Databases and Scripting

Course Overview​

Learn the basics of SQL databases and Python scripting. This course uses Ignition to help build familiarity with SQL tables, basic SQL queries, and simple Python code. Students will work with the core Ignition modules and design simple interfaces to build familiarity with SQL tables and basic queries, as well as use Python to work with data in Ignition.

This course is an excellent foundation for the Level 2 “Using Databases and Scripting in Projects” class for those with limited experience with Python scripting or SQL databases, or who want a refresher before diving into more complex topics.

Length: 4 days

Who is This Class For? What are the Class Expectations?​

This class if for users that have some Ignition experience who are looking to learn more about Python and SQL in Ignition and how they can be used to improve your Ignition projects. No prior SQL or Python experience is required.

Important

This is a level 1 class, prior experience with Ignition is recommended but in depth knowledge is not required.

Suggested Class Pre-Requisites:​

Topics Covered​

Introduction to Using SQL in Ignition​

  • SQL and Relational Databases
  • Using Databases in Ignition
  • Database Overview
  • Populating Views with Data
  • Filter Results
  • Multiple Criteria
  • Sort Results
  • SQL Date Functions
  • Aggregate Functions
  • Group By
  • Joins

Introduction to Using Python in Ignition​

  • Understanding Python
  • Python Introduction
  • Execute Scripts on a Button Press
  • If Statements
  • Lists and Loops
  • Dictionaries

Populate Views with Queries and Query Data​

  • Use Database Data in Embedded Views
  • Using Parameters to Combine Tag and Database Data
  • Expression Bindings
  • The Carousel
  • Add a Search Feature

Insert and Update Database Records​

  • Inserting Records in SQL
  • Named Queries and Scripting
  • Improve a Form with Dropdowns
  • Edit Existing Records

Parameterized Popup​

  • Simple Parameterized Popups
  • Opening a Popup
  • Interactive Popups
  • Pre-fill the Popup with Existing Information
  • Update Data Using a Popup
  • Store Tag Values in the Database

Security​

  • Enabling Session Security
  • Security Through System Functions
  • Check Roles Through Session Properties