Theoretically you can fill a completely flat tire at home, however you need to keep an eye out on if the tire has lost its bead. Basically this means that the inside of the tire is no longer pressing up against your wheel, meaning that air will leak out no matter how much you add. Filling up a tire like this will likely need to be done at a shop for most people.