• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 553
  • Last Modified:

What is the learning scope of being a Microsoft SQL DBA?

Question 1: How to learn SQL (DBA)?
I've been learning MS SQL 2005 recently by reading Microsoft SQL Server 2005 Books Online. I am not quite sure what parts of knowledge are for DBA and what for developers. Can anyone point me the correct way of learning SQL so I can learn in a smart way and avoid wasting time on learning unnecessary things.

Question 2: I set my career target/path to be IT infrastructure professional, if anyone here in similar role, please give me some advice/tips of what knowledge I should have to become a qualified IT infrastructure pro. and in turns of database, what level of knowledge I should have.

thanks,
Jerry
0
JerryJay
Asked:
JerryJay
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
1. This book would exactly clarify what you need to know about Administration

http://www.amazon.com/Server-Database-Administration-70-431-70-443/dp/0071496092

and Development
http://www.amazon.com/Server-Database-Developer-70-431-70-441/dp/0071546693/ref=pd_sim_b_1

2. In terms of Database, you can learn both with practical experience. Download SQL Express and workout all steps given in the book.
0
 
AmmarRCommented:
Dear jerry

if you want to know about MsSQL go to microsoft directly
http://www.microsoft.com/learning/en/us/certification/cert-overview.aspx#tab5

and read the section

Career and IT Manager Portals

if your looking for good material, i recommend these sites, start with videos its simpler then books, after you get familiar with the product you can get deeper with books

http://www.lynda.com/
http://www.learnitfirst.com/
http://www.appdev.com/

for you to become a DBA, you need to know about SQL administration

0
 
JerryJayAuthor Commented:
thank you all
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now