SQL Server for Dummies (type guide)

[Bizkit87]

Hi

I'm looking for a (free) e-book on MS Sql server 2005 for a colleague who wants to start learning Sql Server... any ideas?

there are a few books, but nothing on that level, he is complete n00b, and most info i've got is a bit more advanced?

(yes, i did google)

 

[FarligOpptreden]

I doubt you will be able to get your hands on a book, let alone the SOFTWARE for SQL Server 2003...

 

[NetSpike]

There is no SQL Server version 2003. It's probably running on a Windows Server 2003 machine.

 

[James]

Tutorials

 

[Bizkit87]

ok ok, sorry....

2005 on server 2003

fixed....

 

[dequadin]

Which "side" of SQL Server are you looking to learn? From a Database Administrator point of view or a Developer's point of view?

If it's the developer view there are tons of tutorials on SQL and T-SQL around the net, just think of something you need to do and GIYF

Good tutorials on general server Administration are a bit more difficult to find. But specific administration HowTo's are quite well documented on the net. Backing-Up/Restoring, Maintenance Plans, Optimization etc can be found if searched for specifically.

 

[nephelyn]

If he is a complete noob as you say, it would probably be better to get something that explains terms and the like ie what is a table, column, constraint, index, foreign key. What are they used for, after that look at something that will explain SQL: selects, updates and inserts. Then you can turn to a SQL Server specific book, start with installing and setting it up. Here you can turn to the book that MS uses as material for their courses. Look on their website.

This friend of yours perhaps a consultant?

 

[Bizkit87]

This friend of yours perhaps a consultant?

haha, nope, he's one of the "business" guys here where i work, but he's got a lot of pull with top managers (business as in business, i don't think he knows anything technical!!!)

i asked him if he wants to learn SQL, or SQL server, and he said "yes", so i tried to explain that SQL is a "language" and SQL server is a database, where you can use this language, but a lot of other things as well, again replied with "yes" ... so i don't know

I mostly only work with MaxDB/MySQL, and Oracle.... so i can't help him too much. (on the SQL server parts, and i don't have time to teach him sql)


EDIT: anyway, told him to JFGI! ... just nicely!

so thanx to all!