70-461

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Career » Certification » 70-461

71 posts, Page 1 of 8

1 2 3 4 5 »»»

70-461

Rate Topic

Display Mode

Topic Options

Author

Message

n00bDBA

Posted Friday, June 15, 2012 2:37 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 117, Visits: 421

Hi,

Id like to take this exam and looking for some good prep.. My T-SQL skills are basic at present (main reason for taking the exam). Since the exam prep books arent out for another few months, Could anyone suggest some study materials?

I prefer learning by doing, so any training with examples and things you can try yourself would be great.

Any learning techniques that poeple have for learning coding would be great to (I normal draw out any concepts im trying to learn, doesnt really work with writing TSQL)

Thanks

Post #1316383

anthony.green

Posted Friday, June 15, 2012 2:44 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

My advise would be to lookup the skills measured, from the MS Learning website for the exam and then devel into them by going searches in a search engine of your choice.

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-461#tab2

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1316388

n00bDBA

Posted Friday, June 15, 2012 3:42 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 117, Visits: 421

Hi

thank you for the reply!

Keeps it simple! I had already writed out the objectives and starting to go though them pretty much as you had suggested (keeping links to BOL for each command)

Id still like a book or videos to watch as well if anyone has any suggestions.

Post #1316433

anthony.green

Posted Friday, June 15, 2012 3:49 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

You will be lucky to get anything specific for the exam as they have only just been officially released.

Just do a search for T-SQL 101, should bring up the basics of T-SQL then can go deeper from there.

Post #1316441

n00bDBA

Posted Friday, June 15, 2012 4:09 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 117, Visits: 421

Think ill make a few dummy projects to design databases to work from.

Thank you

Post #1316455

ErikvanD

Posted Monday, June 18, 2012 9:13 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:33 PM
Points: 15, Visits: 155

cbtnuggets.com just has a video series out on 461 which could be a good starting point to get an overview. I am preparing for the exam myself and will sure have a look at these too.

______________________________________________________
... to select or not to select, that's the question...

Post #1317382

jeff.mason

Posted Monday, June 18, 2012 11:13 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 06, 2013 6:51 AM
Points: 989, Visits: 1,790

Honestly, in my opinion, use the tools to study for the T-SQL tests for 2008 for now. I have very little 2012 experience and passed the beta for this exam almost completely on my knowledge of 2008. There's not a lot of new T-SQL for 2012 (not compared to the administration changes), and you could at least get started knowing that for the most part what works in 2008 is going to work in 2012.

Post #1317453

KatieAndEmil

Posted Wednesday, June 20, 2012 1:08 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 8:00 AM
Points: 38, Visits: 116

Hi

I recently passed 70-461 (last Sunday) and I created a page that helped me to proper for the exam. see below link

70-461 study materials

Regards
Emil

Post #1318947

Leslieo

Posted Thursday, June 21, 2012 12:37 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:20 AM
Points: 31, Visits: 438

There are several books authored by Itzik Ben-Gan that are exceptionally good:
SQL Server 2008 T-SQL Fundamentals
Inside SQL Server 2008 T-SQL Querying

One of his SQL Server 2012 books is available now:
SQL Server 2012 High-Performance T-SQL using window functions

learndevnow.com has SQL Server courses available; only one is regarding 2012 but the ones about SQL Server 2008 would be helpful. The cost is $99 for the year.

I suspect you would be able to match most or all of the exam objectives to the books above.

Post #1319101

_subhan

Posted Friday, June 22, 2012 9:50 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 28, 2013 2:01 AM
Points: 3, Visits: 74

Hi KatieAndEmil, thanks for your suggest. tommorow (monday) i want to try exam 70-461. :)

Post #1320068

« Prev Topic | Next Topic »

71 posts, Page 1 of 8

1 2 3 4 5 »»»

Permissions