Skip to main content

MCSA 70-462 - SQL Server 2012 Administrator

MCSA SQL Server 2012 Certification Path: 70-462 SQL Server 2012 Administrator

I'm halfway through the 70-462 SQL Server 2012 Administrator book, which is part of the MCSA certification path. Thankfully, I've had practical experience with much of what the book covers. Building a web app from scratch and deploying several vendor solutions on SQL Server has given me a solid foundation. Reading the book now feels like second nature, and I think it will enhance my understanding even more.

Study Plan Overview

I aim to finish the book quickly and sit for the second exam, possibly as early as this coming Friday or next week. While this material is more DBA-focused, I believe it’s valuable to learn, even if it’s not my professional goal.

Study Schedule

  • 1/19 - Chapter 1
  • 1/20 - Chapter 2
  • 1/22 - Chapter 3
  • 1/23 - Chapters 4, 5, 6
  • 1/24 - Chapters 7, 8, 9
  • 1/25 - Chapter 10
  • 1/26 - Chapter 11
  • 1/27 - Chapter 12
  • 1/28 - 2/4 - Exam Prep
  • 2/5 - Exam - Failed (678 / 700)
  • 3/5 - Exam - Failed (679 / 700)
  • 4/1 - Exam - PASSED!! (810 / 700)

Progress Updates

1/23 - Saturday

I'm on schedule! I completed Chapters 4 through 6 and saved Chapters 7-9 for Sunday. If I can get more done, that's even better! I'm also planning to do some case studies on the test system.


1/24 - Sunday

I went to McDonald's around noon for a coffee and finished Chapter 7 in about 90 minutes.

Sunday Mini Schedule:

  • 12 - 1:30 pm - Chapter 7
  • 2 - 3:30 pm - Chapter 8
  • 4 - 5:30 pm - Chapter 9
  • 6 - 7:30 pm - Chapter 10 (if I'm up for it...)

I started Chapter 9 at 5 pm—time to keep going!


1/25 - Chapter 10 - Indexes

Chapter 10 covers indexes, which is similar to the previous book. I plan to skim through it and focus on the new topics.


1/26 - Done Reading

I finished Chapters 11 and 12. Chapter 11 was particularly interesting as it discussed backups. While I mainly work with full/incremental backups, the chapter introduced other options and details. Chapter 12 consists of code case studies, which are more practical than theoretical. I answered the questions for the first case study and mostly grasped the concepts.

I've also started the CD exam practice questions. However, based on my experience with the 70-461 exam, I found the CD questions much easier than the actual exam, so I'll supplement my study with online resources and community discussions. I want to ensure I understand both the code and the steps involved in performing various tasks.

Exam Attempt and Reflections

2/5/16

Unfortunately, I failed the exam, scoring 678 when I needed 700. I flagged 19 questions for review that I found challenging, such as distinguishing between "Revoke" and "Deny" for user security. I realize I need to refresh my understanding of these concepts, especially since fatigue may have impacted my performance. I plan to study more thoroughly and will take both the next exam and a retake of this one back-to-back.

3/15/16

I've been studying consistently since then. My game plan is to reread the book, work through the questions, and review my notes based on what I remember from the exam.

Revised Study Plan:

  • 12 chapters - 7 days
  • Exam prep - 3 days


Labels:

Comments

Post a Comment

Popular posts from this blog

Sony MDR-ZX100 vs ZX-110 vs ZX310 Series Headphones

Sony ZX Series Headphones Review: A Budget-Friendly Sound Choice If you’re on the hunt for budget-friendly headphones with decent quality, the Sony ZX Series is definitely worth considering. I happen to own several models from the lineup: ZX-100 ZX-110 ZX-310 Let’s dive into how they compare in terms of build quality, cost, specs, sound, and overall value. Build Quality: ZX-310 Takes the Lead The Sony ZX series headphones primarily feature a durable plastic construction. My ZX-100 has lasted over 2½ years, enduring countless tosses into my backpack and car without any issues. However, the lower-end ZX-100 and ZX-110 models have a significant downside: poor-quality earpads. Over time, these earpads disintegrate, leaving vinyl flakes that stick to your hair and ears. The ZX-310, on the other hand, comes with upgraded earpads that don’t suffer from this problem, making them a clear winner in the build department. Cost Comparison: ZX-100/110 Wins for Affordability While the ZX-310 model co...
9 comments
Read more

Casio G-Shock 5600 vs 6900 vs 9000

G-Shock Preferences and Favorites After trying out several G-Shock models, I've developed a better sense of the specific features and design elements I appreciate most. While features are always a plus, my main priority is size . Here's how some of the models I've tried stack up. Size Preference: DW-5600 Series For overall size, the DW-5600 series stands out as a favorite due to its compact, comfortable form. It’s slim, lightweight, and fits well on my wrist without being too bulky. Although the 6900 series provides the benefit of a well-placed front illumination button, the 5600 remains the ideal size for everyday wear. Best Compromise: G9000 Mudman Series If I had to choose a balanced option between size, comfort, and functionality, the G9000 Mudman series would be it. The buttons are slightly tough to press, but the layout and form factor resonate with what I prefer in a G-Shock. Despite having different module versions (GLX, G, and DW), I find that these models offe...
Post a Comment
Read more

Casio MTD 1010 the $30 Submariner Homage

Casio MTD-1010: The Best Budget Submariner Homage If you’re on the hunt for an affordable watch that channels the classic diver aesthetic of the Submariner, look no further than the Casio MTD-1010 . Priced at around $30 on eBay , this model offers incredible value for anyone who loves a good deal. Affordable Elegance The MTD-1010 strikes a balance between style and practicality. While it features a quartz movement , it captures the essence of the iconic Submariner without being a direct replica or knockoff. This watch embodies the classic diver look with its bold dial, rotating bezel, and luminous hands, making it a fantastic choice for both everyday wear and special occasions. Function Over Frills What sets the MTD-1010 apart is its straightforward functionality. Casio focuses on delivering a reliable timepiece that doesn't get bogged down by unnecessary high-end features. This approach ensures that the watch is both accessible and functional, making it ideal for those who appreci...
2 comments
Read more