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:
The course has multiple paths depending on which products you will use. To successfully complete the course, all students must complete the videos and exercises pertaining to PI SQL Client/RTQP. The additional optional exercises and videos are tagged with the query engine or endpoint that they pertain to. If these do not apply to your scenario, feel free to skip these sections.
OLEDB Enterprise - These sections are for those still using PI OLEDB Enterprise for the query engine, as opposed to the new RTQP Engine
Below are the video lectures for this course. We have placed the topics in the same order as they would be presented in a live instructor-led course. Feel free to rewind and re-watch parts of the videos that you need to view again. Be sure to check out the Online Course Videos - Tips and Tricks if your videos look fuzzy!
1. Architecture and Product Selection - Required
2. Installation and Configuration - Required
3. Writing Queries - Required
4. Optional: Installation and Configuration for (OLEDB Provider and Enterprise)
Exercise: PI OLEDB Provider Configuration (OLEDB Provider)
Exercise: PI OLEDB Enterprise Configuration (OLEDB Enterprise)
5. Optional: Writing Queries for (OLEDB Provider)
6. Optional: Writing Queries for (OLEDB Enterprise)
7. Guided Project - Required
8. Final Project - Required
Tell us how we can improve:
Each track of this course contains a large number of exercises to help you practice the information shown in the videos. In order to complete the class, you must do all of the exercises that pertain to your track and product.
It's not necessary that you do every exercise since some of them are regarding topics that may not pertain to your work, such as JDBC. They should be marked clearly in each exercise. If you're unsure about which exercises to complete, please consult with the course facilitator.
PI OLEDB Enterprise Query Optimization White Paper (OLEDB Enterprise)