Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

70-461 Expand / Collapse
Author
Message
Posted Friday, June 15, 2012 2:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 9:41 AM
Points: 118, Visits: 439
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
Posted Friday, June 15, 2012 2:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:53 AM
Points: 5,218, Visits: 5,072
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
Posted Friday, June 15, 2012 3:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 9:41 AM
Points: 118, Visits: 439
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
Posted Friday, June 15, 2012 3:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:53 AM
Points: 5,218, Visits: 5,072
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.




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 #1316441
Posted Friday, June 15, 2012 4:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 9:41 AM
Points: 118, Visits: 439


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

Thank you

Post #1316455
Posted Monday, June 18, 2012 9:13 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 7:40 AM
Points: 15, Visits: 157
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
Posted Monday, June 18, 2012 11:13 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 18, 2014 7:25 AM
Points: 989, Visits: 1,823
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
Posted Wednesday, June 20, 2012 1:08 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 4, 2013 12:17 PM
Points: 40, Visits: 134
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
Posted Thursday, June 21, 2012 12:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 15, 2014 8:35 AM
Points: 32, Visits: 542
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
Posted Friday, June 22, 2012 9:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 6, 2013 3:58 PM
Points: 3, Visits: 76
Hi KatieAndEmil, thanks for your suggest. tommorow (monday) i want to try exam 70-461. :)
Post #1320068
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse