I'm just curious but I'm in a SQL course at the moment and my head is swimming in all the different functions and operators. It's a lot to take in and since I'm in this course to get certified I'm worried about the dizzying amount of knowledge being presented to me. I'm just curious and wondering if anyone has taken the 461 exam and if it gets into the gritty details or if it's more higher level concepts.
I know this is a loaded question but as someone who has played with SQL for about two years and gotten my hands dirty with modifying stored procedures, queries, and coming up with my own basic ones in a production environment with no help or oversight I'm realizing that it will take many years to become comfortable with all of these tools. It just makes me worried that these tests may be beyond me.