Oracle database, able to query things from back end using sqlplus or SQL Developer. Ability to modify PowerSchool front end pages is good. Latest versions of PowerSchool, version 19.11 and 20.4 do address normalization far better than previous versions we have used. Now on to 20.11.3 and Oracle database 12.2 or 19c. PowerSchool's FrontEnd GUI is great to be able to modify. Review collected by and hosted on G2.com.
PowerSchool leaves much to be desired with ability to add / modify without using APIs, which most districts are not able to leverage. PowerSchool also has yet to have a way to archive out old data. Yes, we must keep data for students from Pre-K through 12th grade, including attendance, grades, discipline, etc., but without a way to archive-out data, your database can become quite large and difficult to test on. Let's face it, even with proper Indexing, when you query through numerous tables joined together to get the data you need for decision making, these queries can become unreasonable. We have several tables in the database with more than a million rows. There are many times that we can do things so much quicker in SQL but PowerSchool highly discourages this in PRODUCTION environments. Of course, you can do whatever you like on the Test and Development servers. Review collected by and hosted on G2.com.



