SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to study for MCSA SQL Server 2012


How to study for MCSA SQL Server 2012

Author
Message
dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3441 Visits: 2000
http://www.amazon.com/s/ref=nb_sb_ss_i_0_9?url=search-alias%3Dstripbooks&field-keywords=sql+2012+certification&sprefix=SQL+2012+%2Cstripbooks%2C303
dob111283
dob111283
SSC-Addicted
SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)

Group: General Forum Members
Points: 403 Visits: 110
Thanks for that. I have the exam stuff, but this caught my eye.

http://www.amazon.com/Beginning-Microsoft-Server-2012-Programming/dp/1118102282/ref=sr_1_4?s=books&ie=UTF8&qid=1364410337&sr=1-4&keywords=sql+server+2012+beginners
lshanahan
lshanahan
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1459 Visits: 438
I've been in your shoes. Consider leveraging your previous career to gain a position that will allow you to interact with and use SQL Server in an employment setting. There are more than a few DBAs and developers who began as the guy or girl who just was really good at pulling data together from databases and wound up as the de facto administrator for SQL Server. Way back when I had a job in a human services field and computers were a hobby. Then the company I worked for hired a full-time system admin who had never worked in our field. I had enough computer savvy to be the "translator" between him and our management. Eventually it led to me becoming his assistant. Later on I got into desktop/field support full-time. Along the way I created a number of databases using MS Access (don't laugh, guys) and learned the basics of databases and relational theory.

In my current job, I was hired for my desktop experience but my boss was particularly interested in the fact I had some database and VBA experience as well. To make a long story short, today I have a PC at my desk with a developer copy of Visual Studio, which includes SQL Server 2005. I'm entirely self-taught. mostly by devouring Sql Server Books Online, which is included with SQL Server and is also available via MSDN (the MSDN version allows you to select which version of SQL Server you're interested in, which is important because there are still older versions of SQL Server in production use out there). Books Online (or BOL as it is affectionately known in cyberspace) contains a great deal of tutorials and how-tos which will at bare minimum give you a solid, well-rounded knowledge of SQL Server as well as SS Integration Services, Analysis Services and Reporting Services.

At any rate, the point I am belaboring is that the IT world in general is more interested in what you can do rather than what you know. Certifications are fine and I do not in any way wish to dissuade you from your goals, but as others have pointed out finding a way right now to get some practical experience under your belt will not only help you with the exams, but also down the road when you try to land your dream position.

Good luck and go for it.

____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
dob111283
dob111283
SSC-Addicted
SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)

Group: General Forum Members
Points: 403 Visits: 110
Great post and I totally agree with you larry. The point of the certification was JUST to get the first job and as fast as possible (I'd like a home and a family with my wife in the next few years). It's just getting my foot through the door. After that I could care less about certifications, I'll absorb knowledge like a hawk.
dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3441 Visits: 2000
There is a lot of debate over the value of certification and I'd like to add my 2 cents.

Like many in this field, I became a defacto-dba via support for end-user applications with SQL (and FoxPro) back ends. I found that with a good set of instructions and minimal knowledge, one can install SQL Server, a third party application that connects to a database, and the whole system might run for years in manner that does allow users to get their jobs done. The problem is that performance issues might occur, or the system may crash for one reason or another, and the defacto DBA need to be able to do something other than reboot the server.

And even then, once you get a good backup routine in place and you're learned the difference between inner & outer joins, your site probably STILL doesn't utilize all the features of SQL Server. If many SQL Server features are a mystery, your users may not be getting all the benefit they can get, may be suffering unnecessary performance issues, and may be at risk for security breeches. And if you find yourself job hunting, the company you want to work for may be looking for knowledge & experience in functions you know little about.

In my case, I've found that studying for certification has exposed me to many more features of SQL, some of which I've started using to my employer's benefit without them asking me to do it (unless your bosses are DBAs, they wouldn't know to ask you to do them). And as for other features I've experimented with on my VM at home but have no need for in my work environment, these may be among the skills being sought at my next job interview.
dob111283
dob111283
SSC-Addicted
SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)

Group: General Forum Members
Points: 403 Visits: 110
I appreciate that very informative post, especially the certification part.
smart_analyst
smart_analyst
SSC Veteran
SSC Veteran (217 reputation)SSC Veteran (217 reputation)SSC Veteran (217 reputation)SSC Veteran (217 reputation)SSC Veteran (217 reputation)SSC Veteran (217 reputation)SSC Veteran (217 reputation)SSC Veteran (217 reputation)

Group: General Forum Members
Points: 217 Visits: 109
Can anyone advise for MCSA 70-461 from where can I download the sample database TSQL2012?
dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3441 Visits: 2000
The link is on page xxvii:
http://tsql.solidq.com/books/tk70461/
Shey
Shey
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 15
Hi. How's the job hunting? I am also looking for an entry-level SQL developer job here in NYC. Did you pass any of the SQL Server 2012 cert exams yet? I will be taking my first one this month. I would love to hear of your progress.
dob111283
dob111283
SSC-Addicted
SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)SSC-Addicted (403 reputation)

Group: General Forum Members
Points: 403 Visits: 110
I have found no entry level jobs in south florida, nor on the job training or internships. I've been studying meanwhile, doing all the chapters like 4-5 times. I should be ready for the exam the first week of February, since i haven't been rushing.
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