It's in the options, under the Keyboard tab, under Advanced. Or just run the game with the -console parameter.
I haven't heard any stories of this lately, but a while back, someone told me that non-English keyboards require you to bind a key other than ` to toggleconsole in order to get the console.