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 29, 2012 1:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 9, 2012 4:54 AM
Points: 3, Visits: 31
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.
Post #1323279
Posted Sunday, July 1, 2012 1:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 9, 2012 4:54 AM
Points: 3, Visits: 31
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.

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
Post #1323580
Posted Monday, July 2, 2012 11:10 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 11:14 AM
Points: 535, Visits: 1,651
Is 461 easier than 433?
Post #1323925
Posted Monday, July 2, 2012 12:16 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
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
Post #1323976
Posted Monday, July 9, 2012 6:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 9:47 AM
Points: 11, Visits: 41
these linked content look good, but it hasn't finshed editing.

I think, T-SQL library in MSDN would be better idear.
Post #1326802
Posted Monday, July 9, 2012 2:27 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 1:16 PM
Points: 165, Visits: 371
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



Post #1327140
Posted Tuesday, July 10, 2012 6:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:40 PM
Points: 2,070, Visits: 520
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


MCITP x 3
MCSE x 1
Post #1327473
Posted Tuesday, July 10, 2012 6:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 9:47 AM
Points: 11, Visits: 41
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.

Post #1327484
Posted Tuesday, July 10, 2012 7:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 9, 2012 4:54 AM
Points: 3, Visits: 31
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!
Post #1327512
Posted Thursday, July 19, 2012 4:50 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:40 PM
Points: 2,070, Visits: 520
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 ;)
- Good news - exam focus on querying !
- Not much new features of sql 2012 was used
- xml queries was harder
- Simulation 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!


MCITP x 3
MCSE x 1
Post #1332071
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse