Computer Science - Theoretical vs. Applicable

I recently learnt about Theoretical computer science departments and applicable computer science departments at different colleges. Could someone tell me the difference, pros and cons and how to tell which colleges offer which kind?
Thanks!

Any good CS department will include both theory and practice in its courses and curriculum.

awesome. How do I know which courses are theory and which are applicable?

Usually, there are some specifically CS theory courses (e.g. discrete math or theoretical foundations, algorithms and complexity, theory of computation), but most other CS courses will combine theory and practice (practice meaning programming or hardware design assignments and projects to implement the ideas described in class).