2nd round:
Given a School DB with Professor, Student, Class, Score tables.
1) How many classes does each professor teach?
2) Display AverageScoreForClass and AverageScoreForProfessor.
3) Write a SP to get a student’s score
4) Display StudentName, ClassName, MAX(Score) which got max score for each class.
How to optimize a SSIS package?
How to use Checkpoint?