What's "foolproof" mean? Is it like a "bulletproof?" Like, to protect from fools?

Could you give me some situation that I can use "in terms of"?

The expression "in terms of" is used when you want to refer to a particular subject or topic. You can use this expression whenever you want to address a specific aspect of something you are discussing. Here's a few examples of this expression: Ex: The house is very affordable in terms of cost. Ex: In terms of special effects, the movie was incredible, but everything else about it was just okay. Ex: In terms of quality, that restaurant is the best. In terms of cost, however, it is quite expensive.

Are there good alternatives to "obviously" here? "seemingly" perhaps?

Ah, "seemingly" wouldn't work as an alternative to "obviously" here. "Seemingly" implies that it appears as if, or "apparently." Whereas "obviously" means that it's easily perceived or understood. Some alternatives to "obviously" here are: "clearly," "of course," or even a very informal "duh!" Ex: Clearly, they flew! Ex: They flew, of course! Ex: Well, duh, they flew!

Why isn't an article put front of "whole" here?

There was an error in the script. The article "a" is in front of "whole" here. The script has been corrected.

What does the word "connection" refer to in this context? A bond, I presume?

Yes, that's right! A "connection" does refer to a kind of bond between them, like a friendship. Ex: I've made a bit of a connection with my neighbour. She invited me for dinner! Ex: Five minutes after meeting my dog, River, I had formed a connection with her.

What does "veritable" mean?

"Veritable" is a qualifier word used to emphasize something, similar in meaning to "real" or "genuine." Thus, we can understand "a veritable garden" in this video to mean "a true/real garden," to emphasize the beauty and the natural environment of Kauai. Ex: This match was a veritable massacre. The opposing team wasn't able to score at all. Ex: Trust me, buy these stocks. It's a veritable gold mine.