How did you learn SQL

Question

Post reply

How did you learn SQL

egaytan

Grasshopper

Points: 22
More actions
July 25, 2008 at 12:49 pm

#190114

I have been assigned a program for work called PDMWorks Enterprise that uses SQL 2005 for the metadata. Do you have any good resources on how to learn SQL 2005?
Places in Detroit or online that offer training? Any free training would be useful but the company is willing to pay for training.

Viewing 15 posts - 1 through 15 (of 30 total)

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

Deviprasad Ten Centuries Points: 1060 More actions · Answer 1

Deviprasad

Ten Centuries

Points: 1060

July 25, 2008 at 3:28 pm

#848711

MSDN and books online

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

For a good series of freebie tutorials

SSQL Tutorials

http://msdn.microsoft.com/en-us/library/ms169620.aspx

A specific subject matter tutorial (SQL Server Management Studio)

Try this amongst many others

SSMS

http://msdn.microsoft.com/en-us/library/ms166547.aspx

If your company is willing to pay try this for a list of MS books

http://msdn.microsoft.com/en-us/sqlserver/bb895927.aspx

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

OptimusPrime Ten Centuries Points: 1379 More actions · Answer 3

May I suggest SQL Server 2005 learning CDs/DVDs.

This will get you up to speed fast and you will be posting replies here pretty soon! 🙂

Regards

Venkatesan Prabu SSCommitted Points: 1892 More actions · Answer 4

Check my blog for some basic stuffs

http://venkattechnicalblog.blogspot.com/

Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:

http://venkattechnicalblog.blogspot.com/

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

I am part owner in End to End Training, in Orlando, but good training. We do have a custom mentoring course if you want it.

Are you looking to admin or develop stuff? Two different training scenarios. I'd recommend picking up a book on the side you want to learn and work through it. That will help somewhat.

Goldie Lesser SSCertifiable Points: 6155 More actions · Answer 6

Personally, I have found that one of the best ways to learn T-SQL is by reading through the posts on this site. 🙂

I come on here every morning, read the questions asked, and try to solve the problem.

Then I look to see if anyone else had a better solution.

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 7

MSDN, Books Online and Google are your best companions.

ALOT of stuff ot there... All you need is TIME...

Atif Sheikh

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

egaytan Grasshopper Points: 22 More actions · Answer 8

Do you have a suggestion for a place to buy the DVD/CD training video?

OptimusPrime Ten Centuries Points: 1379 More actions · Answer 9

check out appdev.com. That's where I got my CDs when I started to learn SQL Server 7.

The SQL Server 2000 DVDs are only 500 bucks. And that set will give you everything you need to learn including admin and t-sql. With this, you learn at your own pace. But you need to be dedicated in learning it.

The 2005 version is still a bit pricey. But if your company is paying for it, it will be worth their investment.

Also, I recommend this book: "The Guru's Guide to Transact-SQL" Its by by Ken Henderson. Its nice to read on your commute home.

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 10

Here are three free online tutorials:

http://www.sql-tutorial.net/

http://www.firstsql.com/tutor.htm

http://www.w3schools.com/sql/default.asp

These are the primary Microsoft SQL Server References:

SQL Server 2000 Books Online

http://msdn2.microsoft.com/en-us/library/aa257103(SQL.80).aspx

SQL Server 2005 Books Online

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

alucas-824230 SSC Enthusiast Points: 107 More actions · Answer 11

and like Charlton Heston said in Planet of the Apes:

"Never trust anyone over 30!" (for advice on how to learn SQL 2005).

😛

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 12

alucas (7/30/2008)
and like Charlton Heston said in Planet of the Apes:
"Never trust anyone over 30!" (for advice on how to learn SQL 2005).
😛

Since Charlton Heston didn't say that, I'm not sure what your point is.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 13

alucas (7/30/2008)
and like Charlton Heston said in Planet of the Apes:
"Never trust anyone over 30!"

This is generally credited to Jerry Rubin, not Charlton Heston. and certainly not in Planet of the Apes.

Perhaps you meant "Take your stinking paws off me, you damn dirty ape!", which Charlton Heston DID say in Planet of the Apes. I know I often say that when someone asks me for advice on learning SQL Server.

😛

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

MarlonRibunal Ten Centuries Points: 1332 More actions · Answer 14

In addition to what have been provided here:

http://www.exforsys.com/tutorials/sql-server-2005.html

You can also visit my blog

http://dbalink.wordpress.com

-Marlon Ribunal

SQL Server Database Administrator