The design of pile foundations is covered in Section 7 of Eurocode 7.

"There are eleven limit states listed that should be considered though only the most relevant limit states to the particular situation would normally be considered in the design. These include the loss of overall stability, bearing resistance failure of the pile, uplift of the pile and structural failure of the pile..." (Section 8.11)

Resources for pile foundations (Section 8.11):

The complete Chapter 8

Example 8.11