What I have yet to learn for the first SQL exam

I found a link of what skills will be measured on the 70-761 Querying Data with Transact SQL exam. I know I need to learn these concepts:

Error handling

I need to know these facts (I understand the concepts already, but just need to know specifics of using them):

How and when to use APPLY, GROUPING SETS, CUBE, ROLLUP, PIVOT and UNPIVOT.

I need to know these procedures:

I have to practice creating table-valued and scalar-valued functions, and query and output JSON and XML data. (Previously, I thought the XML bit had been left off this new version, but apparently, it has not!)

Now I know what chapters I'll focus on this week in the book, which includes a sample database to go through all the concepts in the book, so I can practice and not just read about the areas where I'm lacking. Next week, I'll take a practice test and see how I fare.

Comments

Popular posts from this blog

Board games and near the end of the gym challenge

December Challenge has ended!

Another Month Away - Painting, Week 1