So many interfaces exist for digital systems e.g SPI, I2C, PCIe, USB, ...

I wish to know if there is any book that shall explain to me in some detail the different interfaces used in digital systems. There are so many ranging from simple ones to highly complex ones. e.g include SPI, I2C, PCIe, AGP, Serial Port, Parallel port, PS/2, Ethernet, USB, SD card interface, ATA, SATA and SCSI and the list goes on.

I merely wish to know if there are any good books that you know of which describe these interfaces in detail with example projects. I understand that
some of these and others I have not mentioned are so complex (like USB) that there are whole books dedicated to them. In-spite of that, do you know of any resource that I may use?

If you are still wondering I wish to know particularly if there is something like "The Digital interfaces Book". Besides this we also have things like VGA, RF connection, HDMI, among others used for video/audio signals. Do you know of any books on these?

I don't think there is a single book, they all serve different purposes. Some of them are best explained in datasheets and app notes, e.g. I2C, SPI, because they were devised by particular manufacturers, and they are not too complex to describe in half a dozen pages in datasheets.
Parallel ports only serve one main purpose (printers) so would not be of interest to anyone unless they were developing something (e.g. a printer) to interface to a traditional PC. Some interfaces are described in standards, and some you may need to pay for, to get more information. Some are very ancient (e.g. ATA) and about as much information as you'd want already exists on the Internet.
So in summary, most of these interfaces are quite diverse, some are simple, some are old. It would have to be an unusual book to collate this information (usually someone interested in video may be interested in video-related interfaces only and won't care about ATA and parallel port for example).

I don't remember all of the context of this book, but it might be something similar to what you are looking for:
https://www.amazon.com/Advanced-Electronic-Communications-Systems-Edition/dp/0130453501