Data Mining Articles

The content for the articles below come from handouts and previous articles written by Matt Freund for use on his web sites, in workshops, and in user conference sessions.   Use of the material on handouts or on other web sites is prohibited without his written consent.

 

PS Database

  • Overview
  • Core Tables and Fields
  • Custom Tables and Fields

 

Structured Query Language (SQL)

The following articles should help you become more familiar with SQL.  These articles are unique in that they use PowerSchool as a reference, which should make it easier to understand and relate to compared to generic SQL sites that are online.

  • Basic SQL - if you're not familiar with SQL or just want a refresher on the basics, start here
  • Intermediate SQL - once you know the basics, move on to some more powerful commands
  • Advanced SQL - how to use pivot tables and create derived tables with joins or withs

 

Oracle SQL Developer

 

sqlReports

Data Export Manager

 

 

Terms of Use

The downloads on this site are standalone customizations and integration into other customization downloads is prohibited.  All written material on this site was created by Matt Freund.  Use on handouts or on other web sites is prohibited without his written consent.