1) DC; 2) low frequency AC; 3) Radio frequency circuits
With DC, the water in pipes analogy is close enough to be useful.
With low frequency AC, like mains electricity at around household voltages, there are additional considerations to make the water in pipes analogy to be useless enough we generally require people to be licensed to work with it.
Radio frequency electronics is indistinguishable from magic.