They are definitely two different things. Baking soda is normally for baking goods that don't raise too much and baking powder is for goods that helps them to raise a lot.
Usually when I make cupcakes, I'll use vanilla sponge cake mix to bake it. It's because it tasted much more better without using baking soda. Baking soda will cause it to raise too high and the texture is slightly different.