Advanced from Beginner to Advanced TSQL

Question

Advanced from Beginner to Advanced TSQL

yihyoonl

Old Hand

Points: 329
More actions
October 22, 2003 at 9:20 pm

#82454

Hi,
Can someone give some advice on how best to advance from beginner to advanced TSQL, given that my current job function does not involve alot of TSQL coding. Other than reading books and practice from the examples, is there other practical steps that I can do?
Thanks
Aemon
Yih-Yoon Lee
lee@yihyoon.com

Yih-Yoon Lee
lee@yihyoon.com

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

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

My job doesn't require me to play around with database at all, but I simply do so.

Find yourself a task you want build a database solution for. If it is somehow job related, maybe automating some of your daily tasks, that's a great thing to start with.

...and don't be afraid to ask questions!

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

David Burrows SSC Guru Points: 65143 More actions · Answer 2

quote:
My job doesn't require me to play around with database at all, but I simply do so.

Nice to know you have the time Frank

Far away is close at hand in the images of elsewhere.
Anon.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

quote:
Nice to know you have the time Frank

yes, at the moment I love my job!

Stockmarkets are down, bondmarkets not even better, no new product ideas to discuss with brokers, reporting duties finished....

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

SQLBill SSC Guru Points: 51440 More actions · Answer 4

Start off by creating scripts that just retrieve information (SELECT). Create scripts that let you find out what type of data is in the database. Get creative with your scripts. Practice JOINing tables and getting the proper results.

Create a VIEW. Play with that.

Create Temporary Tables ##tablename and play with them.

Get permission from the DBA to create your own database. Or just use the Northwind and Pubs databases if available and if the DBA allows it.

On NON_Production databases, write some INSERT, UPDATE, and DELETE scripts, use TRIGGERs.

Write some stored procedures.

Lastly, find things that are done frequently (daily, weekly, monthly) and try to improve on the script if one exists, or write one yourself.

Also, is there a TSQL programmer at your site? Ask them if they can get you involved when they are writing a script.

-SQLBill

yihyoonl Old Hand Points: 329 More actions · Answer 5

Hi All,

Thanks for the advice. I guess there is really no shortcut :), practice , practice and practice.

Aemon

Yih-Yoon Lee

lee@yihyoon.com

Yih-Yoon Lee
lee@yihyoon.com

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

Yes, that's right!

Nothing is for free. But learning is fun

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

omhoge SSCertifiable Points: 5416 More actions · Answer 7

Reading the "SQL Black Belt" in SQL Server Mag. has helped me alot. Also if you can get access or a snapshot of a real -life database and then create a report design and work on some SQL to get that info and maybe even get it close to the presentation layout. I got great practice on doing cross tab queries that way.

hth - jh

Skål - jh

bendall SSC Rookie Points: 41 More actions · Answer 8

Yih-yoon Lee, You sound like you are where I was a few months ago. I learned a lot from forums-posting and reading, this one and others. Everyone is usually very helpful. You may want to get a book or two simply as a quick referance. I've found a few solutions in a couple of books I picked up. Even better would be to expense it! I wouldn't call myself an advanced user by any means, but I am much futher along than I was in April when I started SQL. SQLBills suggestion of playing with tables and views is the easiest way if you don't want to read much.