T-SQL

Question

Post reply

T-SQL

lepoto.masedi

Grasshopper

Points: 19
More actions
July 5, 2011 at 3:55 am

#240233

What is the quickest and most effective way of learning T-SQL?

Viewing 8 posts - 1 through 7 (of 7 total)

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

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 1

Actually writing it

Here's what i would do :-

Download the version of sql express i want to practice on

Download adventure works DB and install it

Create a hypothetical scenario based on the data already present in Adworks db

Start coding

Use Books on line for syntax and alternate ways of coding

It all starts with simple

Select , insert , update and delete

Jayanth Kurup[/url]

lepoto.masedi Grasshopper Points: 19 More actions · Answer 2

Thanks,

I have adventure Works on my SQL Denali instance......

I will try the approach

Mr Quillz Old Hand Points: 301 More actions · Answer 3

Also try doing tutorials... What is also a good learnig method is to do the T-SQL questions here on SQLServerCentral. They teach one a lot of things!

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 4

lepoto.masedi (7/5/2011)
What is the quickest and most effective way of learning T-SQL?

As boring as it sounds, do the one thing that most people do not do when beginning their studies of any computer language... deeply study "data-types" and the built in functions. That's where a huge amount of knowledge and power lay.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sibystar SSC Enthusiast Points: 198 More actions · Answer 5

SQL Server Books Online and Adventureworks DB is the best combination to start with:-)

jasonwi1202 SSC Veteran Points: 291 More actions · Answer 6

The site in my signature also has some good material for learning the basics of optimizations.

Jason

Webmaster at SQL Optimizations School

Bruce W Cassidy SSChampion Points: 12668 More actions · Answer 7

How quickly would I need to duck if I recommend Joe Celko's books? 😀

The best way to learn is almost always to do, but a great book certainly helps along the way.