What is meant by дательный падеж and what is an example of where it is used?

The dative case.  This is a case used for indicating movement towards something, e.g. in the sentence 'give the book to me' the word 'me' takes the dative case.  The word мне thus means 'to me'.