What will I learn in this course?

Document created by jkim Employee on Nov 6, 2018Last modified by jkim Employee on Jan 14, 2019
Version 4Show Document
  • View in full screen mode

This course is primarily suited for the professional who develops applications that interact with the PI System in a relational database (SQL) manner.  It is for someone who needs to understand the various product options for interacting with the PI System using SQL queries, develop SQL queries to run against these query engines, and integrate these queries into production applications. Overall, this course is intended to prepare you to develop the best way for your organization to integrate the PI System into applications built for relational databases. Generic SQL knowledge will not be taught in this course.

By the end of the course, you will be able to:

  • Select the optimal PI SQL product(s) and architecture for your environment
  • Set up a simple PI SQL framework architecture
  • Develop PI SQL queries against one or more of the query engines in the PI SQL Framework
  • Integrate PI SQL queries into third party SQL based applications such as Microsoft SQL Server Integration and Reporting Services
1 person found this helpful