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 only takes a minute to sign up.
Sign up to join this community
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
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.
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.
