{"id":131,"date":"2012-04-09T23:00:35","date_gmt":"2012-04-10T04:00:35","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=131"},"modified":"2012-04-09T23:00:35","modified_gmt":"2012-04-10T04:00:35","slug":"sql-2012-study","status":"publish","type":"post","link":"https:\/\/cognitiveinfo.com\/?p=131","title":{"rendered":"SQL 2012 Study Materials"},"content":{"rendered":"

This started as my personal list of study materials, but it bears sharing.\u00a0 I got started studying as I studied for the new SQL 2012 Beta Exams.\u00a0 You might still get a slot to try out the exams for free over at the Born to Learn blog<\/a>\u00a0 Once you choose an exam, follow their link to see the specifics about the exam.\u00a0 Be sure to click on the ‘Skills Measured’ tab.\u00a0 That will show what percent of the test covers different areas.<\/p>\n

Be sure to take a look at the planned certification paths for SQL 2012<\/a>.\u00a0 The paths have changed since 2008 and seem to allow more specialization.<\/p>\n

Next, since all of these tests are on SQL 2012, you need to go get the free e-book from Microsoft Press.<\/a> \u00a0\u00a0\u00a0 For the exam I took, I used the ‘skills measured’ to focus on just three of the chapters.<\/p>\n

Now that you’ve found a test and read the new book, you need to practice.\u00a0 Here you have a few options.<\/p>\n

1.\u00a0 You can download SQL 2012, install it and practice.<\/p>\n

1.1\u00a0 Read about the versions and download a trial here:\u00a0 http:\/\/www.microsoft.com\/sqlserver<\/a><\/p>\n

1.2 Go get the famous ‘Adventure Works’ sample databases and install them.\u00a0\u00a0 http:\/\/go.microsoft.com\/fwlink\/?LinkID=220093<\/a><\/p>\n

1.3 Once you have your own install and the samples, there are some good tutorials published to help you work with new features.<\/p>\n

http:\/\/msdn.microsoft.com\/en-us\/library\/hh231699.aspx<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

2. Head over to the free learning labs and practice on Microsoft’s Virtual Labs.<\/a>\u00a0 I like this option because I’m up and practicing in just a few minutes.\u00a0 This is especially true for labs like SQL 142, AlwaysOn Availability Groups.\u00a0 In that lab, you get 5 SQL server VM’s plus a domain controller.\u00a0 I personally don’t have time to spin up 6 servers but this lab makes it easy to practice availability at that level.\u00a0 I will warn you these labs are time limited to about 150 minutes, so plan your study time when you can focus on getting through the lesson.<\/p>\n

Hope this helps with some basic study materials.\u00a0 -Allen<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

This started as my personal list of study materials, but it bears sharing.\u00a0 I got started studying as I studied for the new SQL 2012 Beta Exams.\u00a0 You might still get a slot to try out the exams for free over at the Born to Learn blog\u00a0 Once you choose an exam, follow their link […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[33,59,65,82,93],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-certification","tag-learning","tag-microsoft-sql-server","tag-resources","tag-sql-2012"],"_links":{"self":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=131"}],"version-history":[{"count":0,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions"}],"wp:attachment":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}