I'm just getting into SQL-SERVER, so forgive me if this is a basic question.

I need help, recently work on database programming, For my query development, to understand complex query, to can optimized syntax, I need guideline/good resources. Give me a helping hand to increase my knowledge in sql field.

Thanks in advanced

3 Answers 3


Here is my favourite article for beginners: http://www.sqlmag.com/article/tsql3/t-sql-101-lesson-1

10 articles in total, you will be a pro in no time.

  • thanks ........for reply.......is there any best book?
    – shamim
    Jan 25, 2012 at 6:15

I think Itzik Ben-Gan books (Microsoft SQL Server 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying, Inside Microsoft SQL Server 2008: T-SQL Programming) is very applicable for your needs.


I was very satisfied with Murach SQL Server 2008 for Developers which was used to teach us database programming in college. It will take you through everything from the basics to intermediate programming and includes functions, views, indexes, aggregate queries, dynamic SQL, stored procedures and XML.

The layout is great with detailed descriptions are on the left-hand page and summaries, examples and tables are on the right; this makes it very useful as a reference book after you are done learning the basics.

Not the answer you're looking for? Browse other questions tagged or ask your own question.