Pulling the Best Assessment Record

March 25, 2010

During the course of a school year, it may be necessary to assess students multiple times.  This information can be very useful for monitoring the progress of students, but it also causes problems when you simply want to know the best scores that a group of students have posted.  Getting the best record for an [...]

0

The Case for Left Joins

March 6, 2010

When working with educational data, the student is going to be the center of nearly every database query.  From there we might attach test records, classes or involvement in programs.  Often times programmers accomplish this with what is known as a “full inner join”.  A method by which relevant records from both database tables are [...]

0