Not that easy with the tile, and need a hammer drill for the concrete bit. As noted already start with a small bit and work up in size.
For the tile, mark the outline of the pipe, drill very small holes all round the edge and use something metal and strong, like an old screwdriver to join the holes together, and remove the waste bit of tile. DO NOT use the drill on hammer on the tile, or it will get smashed- I have learned that the hard way. Use safety googles or a sharp bit of tile/ concrete may entail a visit to hospital and an operation.
I know that it's possible to get a proper hole drill to use on masonry, but I never found one in Thailand.