Bedrock

Bedrock is both an indestructible and unmineable block.

Obtaining
Bedrock cannot be broken using any tools. It also cannot be moved by pistons to get it you need to be in creative.

Natural generation
Bedrock comprises the bottom-most 5 layers of the Overworld in a rough pattern, although to the 4th layer is predominately flat bedrock with no gaps, which makes the very bottom 5th layer inaccessible.

In the Nether, bedrock comprises both the top and bottom 4 layers in a rough pattern. At the top of the Nether, bedrock prevents you from going past layer 127. It can also be found at the sides of the Nether in the console edition.

Bedrock in the Overworld and the Nether always generates in the same pattern no matter what seed is used.

In the End, defeating the Ender Dragon spawns a portal with a Bedrock frame. A single piece of flaming Bedrock also appears underneath Ender Crystals.

Video
Note: This video is outdated, as the void fog was removed in 1.8.

Trivia

 * Bedrock emits a dark particle effect
 * In the console editions, only the lowest layer (and highest in the Nether) of naturally spawned bedrock is unbreakable.
 * In maps generated before the Halloween Update, there were occasional gaps in the bottom layer of Bedrock that the player could fall through.
 * It is possible, but rare, for ore to be found encased in Bedrock.
 * In Minecraft 4k, there is bedrock on the bottom of the map with no texture.
 * Strongholds can cause a bedrock not to form within its bounds.
 * It is possible to blow up bedrock with an explosion edited to at least a power of 5000.