Study Guide(70-461 Querying MS SQL)

Question

Study Guide(70-461 Querying MS SQL)

fritzjoery

SSC Veteran

Points: 273
More actions
February 21, 2016 at 12:17 am

#311593

Hi guys, i just want to know if there are study group that currently studying T-SQL together.
I want to take 70-461 Querying MS SQL in the few months.
I already found tutorials but only fundamentals.
I wish to have real world examples.
Hoping for your help.
Thank you.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004683 More actions · Answer 1

fritzjoery (2/21/2016)
Hi guys, i just want to know if there are study group that currently studying T-SQL together.
I want to take 70-461 Querying MS SQL in the few months.
I already found tutorials but only fundamentals.
I wish to have real world examples.
Hoping for your help.
Thank you.

This forum is inherently one of the biggest "study groups" in the world and has many real-life examples. Just check on any of the T-SQL forums on this site.

That, notwithstanding, the exam doesn't cover "real world". It basically covers what's in Books Online. You won't find, for example, real world problems that require a Tally/Numbers table/function or the difference between ROW_NUMBER()s to resolve the problem and you won't find examples on how to determine the first of next month.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 740155 More actions · Answer 2

I agree with Jeff in that the exam doesn't cover real world examples. If you want to see how a particular feature might be used in the real world, search for the term. For example, if you want to know how try_convert works, search the forum or articles here on the site. There will be places where people are using the command or asking questions about it.