Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Exam 70-461


Exam 70-461

Author
Message
dbman
dbman
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 1537
Hi,
Ive just ordered the book: Querying SQL Server 2012 Training Kit. I am planning to take the exam 70-461 within 3 months. My question is: Will this book be sufficient enough to study to pass the exam. Are there any other resources anyone can recommend to make sure I have a good chance of passing.

Thanks
grapefruitmoon
grapefruitmoon
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1610 Visits: 1093
I'd say it would depend on your experience. I've been using T-SQL for over 10 years and passed the exam in January using mainly that book. I used it to top up knowledge of elements of T-SQL that I was a bit rusty with, and to learn the new features of SQL Server 2012. If you're inexperienced with T-SQL, then you might struggle just using this resource. Books Online is your friend! Use the book to get an overview, then dig in deeper with other resources.

-----------------------------------------------
SQL Server posts at my blog, Grapefruitmoon.Net
dbman
dbman
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 1537
Thanks for your advice. I think ill start with Books online.
dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 1958
Microsoft exams typically include questions that require knowledge not specifically spelled out in the official exam prep books. This is because they want you to have real world work experience too.

If you currently have a job where you work with SQL Server 2012, my suggestion would be to apply what is in the books to actual work tasks as much as possible. If not, do your experiments on your training system, particulary with features that are new in SQL 2012.
anoop.mig29
anoop.mig29
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 155
Sorry but can anybody explain me whats exam 70-461 , i mean to which version it deals and whether it is for administration or development
dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 1958
70-461 is Querying Microsoft SQL Server 2012

Here's a summary:
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-461#fbid=NV3hLp0Fd64
manub22
manub22
SSC-Enthusiastic
SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)

Group: General Forum Members
Points: 137 Visits: 1861
Yes, the book is suffecient to prep for the exam. But you will also have to practice with SQL Queries in SSMS.

For people working with TSQL and 5-10 yrs of work-x you just need to know the new stuff been introduced in SQL 2012, that's it. The whole exam is just on Querying the Database tables, that's it.

For exam details and on what to prepare for 70-461 Exam check the following blog post:

Link:http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/


~manoj | LinkedIn | Facebook | YouTube
Blog: SQLwithManoj.com

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search