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


70-461


70-461

Author
Message
bethgvinson
bethgvinson
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 37
Leslieo (6/21/2012)
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.

I am starting to look into getting the MCSA: SQL Server 2012, but only have classroom experience, and not much of it. I want to be a DBA, and feel I am a natural at it; I absolutely love it.

Does anyone else recommend learndevnow.com? I will probably be getting the book and training kit that the MS site recommends for the course - Book: T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure,
MCTS Self Paced Training Kit 70-461. What do you all think of that?

I have had a very difficult time figuring out what I need to take and where I need to go to get my education. I don't have a lot of money (cause I'm looking for work!), but I would like quality courses and understand I will have to pay; just don't want to waste my money. I am self taught and prefer virtual to onsite classroom.

Any suggestions would be so appreciated! Also, I am new here and figuring out where to post my questions, so please let me know if there are other forums or threads that may be helpful to me. Thanks so much everyone. :-)
bethgvinson
bethgvinson
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 37
I just preordered the two resources recommended for the MS Exam 70-461 -
 Book: T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure
 MCTS Self Paced Training Kit 70-461

Kinda irritating that the training kit isn't anticipated to be out until October though. Sad

I'm so excited about working on this, and I want to start yesterday!

I did check out the CBTNuggets videos on it and they look promising.

Edit: Was going to merge this with the last post, but couldn't figure out how. :o
Ed B
Ed B
Mr or Mrs. 500
Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)

Group: General Forum Members
Points: 594 Visits: 1775
Is 461 easier than 433?
KatieAndEmil
KatieAndEmil
SSC Rookie
SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)

Group: General Forum Members
Points: 41 Visits: 135
Those looking to learn.... I personally prefer books + practice. Conferences/classroms are nice but you generally need to have prior knowledge to get most of them. SQL Bits videos are good.

Below are some links from our website that might help you to prepare for certifications:
Exam Guide to 98-364 Database Fundamentals - This is still in progress

Exam Guide 70-461 Querying with SQL Server 2012

and SQL Tutorial for beginners

We hope to add new articles based on certification requirements (we are starting with 98-364 and 70-461)

Regards
Emil
Garsy
Garsy
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 54
these linked content look good, but it hasn't finshed editing.

I think, T-SQL library in MSDN would be better idear.
cppwiz
cppwiz
SSC-Enthusiastic
SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)SSC-Enthusiastic (184 reputation)

Group: General Forum Members
Points: 184 Visits: 470
You could also use the free Microsoft SQL Server 2012 Virtual Labs to prepare for the exam.

http://www.microsoft.com/sqlserver/en/us/learning-center/virtual-labs.aspx



Konstantin Reu
Konstantin Reu
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2645 Visits: 754
I've scheduled exam on 19 jul. Now i am seeing cbt nuggets for 70-461 - very very simple. I guess that 70-461 is simpler than 70-433.
Can anybody confirm it ?

PS. I have almost 10 year of experience with sql but i am concerned:-)

MS SQL 2008 MCITP x 3
MS SQL 2012 MCSE x 2
Garsy
Garsy
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 54
neprosto (7/10/2012)
I've scheduled exam on 19 jul. Now i am seeing cbt nuggets for 70-461 - very very simple. I guess that 70-461 is simpler than 70-433.
Can anybody confirm it ?

PS. I have almost 10 year of experience with sql but i am concerned:-)


it looks you have already passed exams for 2008. So, the 2012's exams are also simple for you.;-)
bethgvinson
bethgvinson
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 37
cppwiz (7/9/2012)
You could also use the free Microsoft SQL Server 2012 Virtual Labs to prepare for the exam.

http://www.microsoft.com/sqlserver/en/us/learning-center/virtual-labs.aspx


Wow, thanks so much for this! Now I feel like I'm getting somewhere!
Konstantin Reu
Konstantin Reu
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2645 Visits: 754
neprosto (7/10/2012)
I've scheduled exam on 19 jul. Now i am seeing cbt nuggets for 70-461 - very very simple. I guess that 70-461 is simpler than 70-433.
Can anybody confirm it ?

PS. I have almost 10 year of experience with sql but i am concerned:-)



I can answer your question itself, because i have just passed 70-461 Wink
- Good news - exam focus on querying !
- Not much new features of sql 2012 was used
- xml queries was harder
- Simulation w00t ten last queries should be written by hand.
- One queries had level like MCITP\DBA. it is impossible to know for developer. Be ready to be caught.

In total exam left good impression, and more oriented to experienced developer than 70-433. Finally it is not hard as you may think.

Good luck!

MS SQL 2008 MCITP x 3
MS SQL 2012 MCSE x 2
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