ChessX – Free database and PGN viewer. Comes with a training mode and the Stockfish engine. Available for Windows, Mac and Linux computers.
Chessbase Reader – Alternative free PGN viewer, a little more good-looking and easy-to-use. For Windows.
Chess.com database downloads – download millions of games in PGN format.