Need module for notifications like privatemsg
There is messaging_simple  table which stores message values.

See the column timeread this provides time when the message is read. The entries which have 0 value shows unread message.

You can apply sql query to find out rows with timeread 0 for logged in user and can get the count of unread messages.