Must Knows of SQL server

Question

Post reply

Must Knows of SQL server

Anita K

Grasshopper

Points: 24
More actions
November 17, 2005 at 2:29 am

#90822

I am new to programming SQL server.I would like to know what concepts I should be knowing to say that i know SQL server.
I know it is very stupid question.Any book will have all basics but I just want to know in case i am proceeding in the right direction while i am learning.
All you SQL gurus can help me with it

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

Well - here's my list of what I would consider the "basics":

1) Normalization & Relationships

2) Understanding Indexes

3) Defaults, constraints, Rules etc.

4) Data types

5) Creating tables, views, stored procedures & triggers

6) Joins & T-Sql

If you don't use this site already, here's a great link to SQL Basics

**ASCII stupid question, get a stupid ANSI !!!**

Steve Jones - SSC Editor SSC Guru Points: 734552 More actions · Answer 2

I'd add in there backup/restore on SQL Server.

SQL Agent, scheduling jobs, basic DTS packages for Excel import/export, sending SQL Mail.

vinny_1973 SSCommitted Points: 1782 More actions · Answer 3

vinny_1973

SSCommitted

Points: 1782

November 18, 2005 at 3:00 am

#604580

so ... that wud be "Learn Everything", huh guys!??

Jo Pattyn SSC-Dedicated Points: 32076 More actions · Answer 4

I would start with backup/restore

Than security

Then see other topics above.

I didn't have the need yet to use DTS packages or SQLMail.

*misread*

sushila SSC-Dedicated Points: 35293 More actions · Answer 5

This is interesting...I saw the word "programming" in the original post and responded to it as a developer...Steve rounded it off with admin tasks..guess I missed the most important thing - that there is no more a divide between DBAs and DB Developers...

ps:Just a personal preference - but give me design and development over administration any day!

**ASCII stupid question, get a stupid ANSI !!!**

vinny_1973 SSCommitted Points: 1782 More actions · Answer 6

u obviously haven't played with clusters enough sushi!

sushila SSC-Dedicated Points: 35293 More actions · Answer 7

Oh I'm one of those "all work and no play" types...dull as ditchwater...must start setting aside some playtime now & then...

ps:The problem is I haven't played with clusters at all...finally..something to look forward to in Life..

**ASCII stupid question, get a stupid ANSI !!!**

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 8

Aside from all the topical information posted (yes, you have to pretty much hit everything in this post) the absolute best things you can have in your tool box are:

A mentor
Good Online websites (as favorites)
Good online discussion groups (you've got to read and participate)
Google
The ability to say "I do not know the answer at present, but I can research the issue and then we can solve your problem".

Always remember, a good DBA does not need to know everything chapter and verse, but rather needs to know where to find the correct chapter and verse in any given situation.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

sushila SSC-Dedicated Points: 35293 More actions · Answer 9

"A mentor" alone is worth all the other tools in the box...unfortunately they're really hard to come by...

**ASCII stupid question, get a stupid ANSI !!!**

Anita K Grasshopper Points: 24 More actions · Answer 10

Thanks guys ,

Now I know what they mean when they say post a question and get the point of views.

The answers have really helped me.I hope soon I'll also be able to comment as you Pro's....

Happy coding and keep posting good stuff. I'll be more than interested.

P.S can any one please list some of the good sites to refer to while i move on with my study?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 11

Well this site's probably the best.

http://www.sqlskills.com

http://www.sql-performance.com

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Anurag Nayar Mr or Mrs. 500 Points: 515 More actions · Answer 12

Also, you may want to take a look at below sites for best practices, standards etc.

http://vyaskn.tripod.com/object_naming.htm

http://www.sql-server-performance.com/vk_sql_best_practices.asp

http://www.sqlteam.com/Item.asp?ItemID=4065

Anurag