When building a site and aiming at a target market, how low should the competition be? Is 100,000 too much competition?

Also do you guys know a good place to get SEO video tuts to learn more?