Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

3 Answers 3

up vote 1 down vote accepted

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.

share|improve this answer
    
thanks ........for reply.......is there any best book? –  shamim Jan 25 '12 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.

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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