How to retrieve, design, and code in SQL Server 2005

	Book summary Table of contents Who this book is for What people say about this book Related books



		FREE download of chapter 3 FREE download of the book examples What software you need Instructor's CD FAQs Book corrections

Table of contents for
Murach’s SQL Server 2005 for Developers

Section 1	An introduction to SQL
Chapter 1	An introduction to relational databases and SQL	3
Chapter 2	How to use the Management Studio	47
Section 2	The essential SQL skills
Chapter 3	How to retrieve data from a single table	79
Chapter 4	How to retrieve data from two or more tables	115
Chapter 5	How to code summary queries	149
Chapter 6	How to code subqueries	167
Chapter 7	How to insert, update, and delete data	197
Chapter 8	How to work with data types and functions	217
Section 3	Database design and implementation
Chapter 9	How to design a database	269
Chapter 10	How to create and maintain databases and tables with SQL statements	297
Chapter 11	How to use the Management Studio for database design	323
Section 4	Advanced SQL skills
Chapter 12	How to work with views	343
Chapter 13	How to code scripts	365
Chapter 14	How to code stored procedures, functions, and triggers	399
Chapter 15	How to work with cursors	447
Chapter 16	How to manage transactions and locking	471
Chapter 17	How to manage database security	497
Chapter 18	How to work with XML	549
Section 5	CLR integration
Chapter 19	An introduction to CLR integration	581
Chapter 20	How to code CLR stored procedures, functions, and triggers	605
Chapter 21	How to code aggregate functions and user-defined types	643
Resources
Appendix A	How to install the required software for this book	669
Appendix B	How to install the files and databases used in this book	675
Appendix C	Coding and syntax conventions	681
Index		684

To contact us, call us at (800) 221-5528 or email us at murachbooks@murach.com