Learning SQL

[SPetty1979]

I have a "working" knowledge of MySQL and some new circumstances are requiring me to learn full blow SQL. Are there any good recommendations on books or websites regarding SQL programming.

Thanks!
Shawn

 

[AlexCuse]

I really like 'the Guru's Guide to Transact-SQL'

There is also books online and a wealth of info on the web.

Good luck, and enjoy!

Alex


Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.

 

[SPetty1979]

Thanks Alex,

My other question, is, what do you generally look for in a "reference" guide for SQL. Are you looking for something that has the complete inner workings of SQL, something that has an explanation and examples of coding, or both?

Thanks again,
Shawn

 

[mrdenny]

It depends on what you need to do as to what you will look at. If you are going to be doing SQL Server programming then you want a book that has T/SQL samples. If you will be the DBA of the system then you'll want a book that covers the inner workings of the database.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[TysonLPrice]

There quite a few free (you may have to register) sites for learning SQL. Do a Google search on "SQL 2000 Tutorials Free".

Here's a couple:

http://www.functionx.com/sqlserver/index.htm

http://www.2000trainers.com/section.aspx?sectionID=2

 

[SQLBill]

I have a "working" knowledge of MySQL and some new circumstances are requiring me to learn full blown SQL

Are you trying to increase your knowledge of MySQL or are you trying trying to learn SQL Server 2000/2005??? All SQL is not created the same.

-SQLBill

Posting advice: FAQ481-4875

 

[SPetty1979]

I have learned some MySQL for some web based applications that I have needed, so I am familiar with the basic querying code.

However I have accepted a new position that will have it in my best interest to learn full blown SQL programming and concepts.

I'm subscribed to the MySQL forums as well, I know I came to the right place.

Also thanks for the additional input mrdenny and tysonlprice.

Shawn

 

[SQLDenis]

>>full blown SQL

Which dialect do you need to master? T_SQL, PL/SQL, ANSI SQL? Once you know that then you can find the appropriate forum (all 3 have a forum)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLBill]

You really didn't answer my question....are you now learning Microsoft SQL Server? Or are you staying with MySQL? The two are different 'flavors' of SQL and this forum is only for Microsoft SQL Server: Programming (see the forum title). Some of the tips you learn here WILL work with MySQL, but a lot won't because not all of the SQL is the same.

-SQLBill

Posting advice: FAQ481-4875

 

[SPetty1979]

SQLBill.

I am learning both. The reason I made the post in this forum is for SQL not MySQL.

SQLDenis.

Pretty sure it'll be T_SQL.

I definitely think I have a few good sources to run with now, I just wanted to stop by here to see if there was any "definitive" work for learning SQL.

Thanks much everyone!

 

[SQLBill]

Thanks for clearing up which SQL you are learning. BTW-have you checked the FAQ section for this forum? There is a FAQ listing suggested books/links/etc.

-SQLBill

Posting advice: FAQ481-4875