What are some good T-Sql resources?

Question

0.00/5 (No votes)

See more:

, +

I have been working as a .NET developer for like 6 months now and I have been in touch with .NET and sql server for like 1 year. I wouldnt say I dedicated everyday to improving my skill but I think I know the basic sql. I looked for resources to learn sql online (both books and blogs etc) but most of them are just limited to basic SELECT, UPDATE, INSERT, DELETE , HOW TO CREATE, DROP,ALTER TABLE OR STORED PROCEDURE OR VIEWS, JOINS, TRANSACTIONS. THE END I want to learn beyond that. For example, I know how to create a stored procedure or use CTE but I am not aware of many tricks and techniques that I can use with them. I guess that comes along with work experience but still if there is a book or website or youtube videos series which can help me get better at sql then I would be more than happy. I thought about buying MCTS 70-433 book (not because I want to take exam but because may be I can learn something). A simple google search "SQL resources" returns 240,000,000 results, and perhaps thats where I get baffled. I believe that since you guys are more experienced perhaps it would be best to ask you what you would suggest me? Also note that I am not planning on becoming a DBA but I would like to be a developer who is very strong in SQL. Thank You.

Posted 26-Dec-13 6:19am

jim rock

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

jschell · Answer 1 · 2013-12-26T06:46:00

The books I have specific to MS SQL Server

"Mastering SQL Server 2005" by Gunderloy, Jorden and Tschanz. Pub: Sybex
"SQL Server 2005 T-SQL Recipes" by Sack. Pub: Apress
"SQL Hacks" by Andrew Cumming and Gordon Russel. Pub: O'Reilly
"Super SQL Server Systems" by Gama and Naughter. Pub: Rampant

First 3 are probably the best.
If you can find anything else from O'Reilly it is probably good as well. I have only ever had two turkeys from them and one of those was a tutorial and the other was just too short for the money.

Maciej Los · Answer 2 · 2013-12-26T06:51:00

Solution 2

I would to say: Only practice makes you perfect!

There a tons of resources. The best one is that which is the best for you.

My favorites:
MSDN[^]
SQLCENTRAL[^]
SQLAUTHORITY[^]

Posted 26-Dec-13 6:51am

Maciej Los

thatraja · Answer 3 · 2013-12-26T06:54:00

Solution 3

You want something like index page(s) from a Book. Alright, I'll give a single page.

Database related articles @ Codeproject[^]

Our members written articles on (almost)all topics. Browse, practice & use....

Posted 26-Dec-13 6:54am

thatraja

Jain Nishant · Answer 4 · 2013-12-26T19:21:00

Solution 5

See:- http://www.w3schools.com/sql/[^]

Hope, this will helps you...

Posted 26-Dec-13 19:21pm

Jain Nishant

Christian Graus · Answer 5 · 2013-12-26T10:02:00

Solution 4

At risk of blowing my own trumpet, as well as the things mentioned, I've started a series of articles, the first is here[^], and I'll do at least one a week. So long as you don't rely on this alone, you could do worse than working through my articles once a week to learn new things about SQL.

Posted 26-Dec-13 10:02am

Christian Graus

Comments

jim rock 26-Dec-13 23:25pm

I just skimmed through your article and it;s not bad actually. I think I would like to read more of your articles but have posted more articles continuing the article you gave me a link to?

Christian Graus 27-Dec-13 0:38am

Cool - there's two up, I am working on the third right now, should go up tomorrow or the next day. I plan at least one a week, depending on my schedule.