There is no alcohol in Dubai.
Alcohol is allowed for tourists and non-Muslims. To buy it, you need a special card or a tourist visa. You can enjoy alcoholic drinks in almost every hotel (except for dry hotels), all nightclubs, and bars. Usually, nightlife places are located in hotels, and there are more than 500 of them in Dubai!