SQL, or Structured Query Language, is the backbone of any modern database. While SQL does vary from vendor to vendor, the basics of writing statements is the same. In this workshop participants will be introduced to SQL, SQL Editors, major database vendors, and begin writing statements to mine data from a database. While the database used in the presentation will be PowerSchool, the concepts could be applied to any database. If participants do not use PowerSchool, access to a test server will be provided so that the user can participate in the workshop. The knowledge of SQL has revolutionized how data is managed within the Annville-Cleona School District. It has opened up many different doors to allow the replacement of manual processes with automated ones, as well as provide the opportunity to integrate into different applications. Examples will include automating student account creation (this involves knowledge of powershell), providing detailed CSV dumps for vendors that extend beyond what PowerSchool can natively do, and finding/fixing errors that affect PIMS (State Reporting).
Time: May 6 - 3:00 PM
Location: Room 111
Audience Level: Novice
Audience Knowledge: Access to PowerSchool preferred, but not required. Access to PowerSchool test server preferred, but not required. Ability to install software, such as a SQL editor on one's own machine.