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