The best way to learn SQL Server

Question

So, I get a new job working with databases (more precisely, Microsoft SQL Server). I know nothing about SQL much less than SQL Server. They said that they will train me, but I want to take the initiative to learn about it on my own, to be in front. Where is the best place to start (textbooks, books, etc.)? I want to learn more about SQL moreso than any of the fancy dots and clicks.

Answer 1

If you plan on coding the sql database using .NET, skip ADO and go directly to Linq. You will not miss anything.

Oh, also, Joe Selco. If you see his name in an article or book about SQL, read it.

Answer 2

, , .

DBA

• , ect .
• ODBC Windows
• ( )
• ( )

• (Run for the hill)
• ADO, ODBC
• CRUD (Create Read Update Delete)

Answer 3

SQL:
http://www.google.com/search?hl=en&q=introduction+to+sql → http://www.w3schools.com/SQL/sql_intro.asp

MSSQL:
http://www.google.com/search?hl=en&safe=off&q=introduction+to+ms+sql → http://www.intermedia.net/support/SQL/sqltut.asp p >

? -

Answer 4

Sql Books Online .

Answer 5

SQL Server 7.0 ddart.net.

Answer 6

SQL Server Central - MS SQL

Answer 7

Yikes... : " !"

, -, , SQL, , SAMS "Teach Yourself SQL 34 ". SAMS, , , ... .

Answer 8

- EDMX Designer Visual Studio 2010. , , , , , . SQL, (FK).

Answer 9

http://sqlzoo.net is a great interactive place to start.