Final Project: Creating Queries for your own Application

Document created by kduffy on Sep 25, 2018Last modified by kduffy on Nov 13, 2018
Version 6Show Document
  • View in full screen mode

Final Project: To complete this course and receive a certificate of completion, you must complete a final project on or before the deadline specified at the beginning of your course by the course facilitator. If you have any questions about the final project, please as on the community discussion forums.


Objective: The goal of the final project for the Exposing Data with the PI SQL Framework online course is to apply what you've learned so far in your own environment. There are countless ways to use the PI SQL framework, and this is your chance to make the course directly applicable to your own scenario.


Project Description:

A successful project will include:

1. An overview of your scenario and the goals of your project

2. The products you selected, their arranged architecture within your environment (a description or an image is fine), and explanations for both

3. The queries that you wrote and a screenshot of the Object Explorer in PI SQL Commander to show any custom database objects or schemas that were created along the way

4. Screenshots of the queries being run in your application, showing that data was passed correctly and handled by the application.

Optional: Screenshots of the queries being run in PI SQL Commander and screenshots of the application connecting. These will both be covered by step 4, but you can break it down into smaller steps if you would like.

5. Please also include a list of the videos you watched and exercises that you did along the way.


How to Submit Your Project:

Please submit the project file, in MS Word or pdf, via e-mail directly to your course facilitator.


Note about Original Work:

Please remember that no extensions will be given for the final project. Your submission must be your own work, and not copied from another student, course videos, ebook or online resources. No credit would be given for plagiarized work, partially completed work, and no refunds would be given for failed projects.


Note About Customer Data

Absolutely NO customer data will be shared outside of the Student/Facilitator relationship. The facilitator will NEVER ask a student to share proprietary information with the class. Anything shared with the facilitator as proof of work will be destroyed at the end of the course. If however, you work on a generic project and wish to share it with other users on the community, OSIsoft can help facilitate that. This will be completely at your discretion and OSIsoft would take no legal responsibility.