1. I always worry the night before a big test.

2. I always worry at the night before a big test.

(# 1 is right, right? What about #2? Can we add 'at' before the night?)

Yes, 1 is correct, and 2 is not. The word "at" shouldn't be used; it's simply not needed.