Interview Question in Microsoft Transact-SQL


 

Interview Question :: What are the gud books to learn SQL Server 2005 for a new person?I have a bit of knowledge about databases


my syllabus to study is

1. SQL server 2005 architecture.
2. Declaring variables and parameters.
3. Maintaining data (DML).
4. T-SQL stored Views, procedures , Functions and Triggers.
5. Programming procedural statements.
6. Error handling.
7. Handling server-side result sets.
8. Querying and storing XML.
9. Integration of .net CLR with SQL server.
a. Developing procedural code in .net.
b. Extending SQL server with .net.
Answers to "What are the gud books to learn SQL Server 2005 for a new person?I have a bit of knowledge about databases"
RE: What are the gud books to learn SQL Server 2005 for a new person?I have a bit of knowledge about databases?

1. Robert Vieira, Beginning SQL Server 2005 Programming (Paperback, 2006)

ISBN-13: 978-0764584336



2. Robert Vieira, Professional SQL Server 2005 Programming (Programmer to Programmer) (Paperback, 2006)

ISBN-13: 978-0764584343



These books should cover everything you will be studying in your syllabus, and have clear and easily understandable content with a good mix of theory, examples, and practical code.
 
Vote for this answer ::  
RE: What are the gud books to learn SQL Server 2005 for a new person?I have a bit of knowledge about databases?

WHO NEEDS BOOKS!?!? google is the best source to learn any code or program because you get so many different opinions and options. I know w3schools.com is where i learned most of my knowledge giving the basics on each language of code. hope i helped! ...and i wouldnt waste ur money on something thats free!
 
Vote for this answer ::  
Update Alert Setting