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

	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 2008 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	83
Chapter 4	How to retrieve data from two or more tables	121
Chapter 5	How to code summary queries	157
Chapter 6	How to code subqueries	179
Chapter 7	How to insert, update, and delete data	211
Chapter 8	How to work with data types and functions	235
Section 3	Database design and implementation
Chapter 9	How to design a database	291
Chapter 10	How to create and maintain databases and tables with SQL statements	321
Chapter 11	How to use the Management Studio for database design	349
Section 4	Advanced SQL skills
Chapter 12	How to work with views	369
Chapter 13	How to code scripts	391
Chapter 14	How to code stored procedures, functions, and triggers	427
Chapter 15	How to work with cursors	479
Chapter 16	How to manage transactions and locking	503
Chapter 17	How to manage database security	529
Chapter 18	How to work with XML	583
Chapter 19	How to work with BLOBs	615
Section 5	CLR integration
Chapter 20	An introduction to CLR integration	651
Chapter 21	How to code CLR stored procedures, functions, and triggers	675
Chapter 22	How to code aggregate functions and user-defined types	713
Resources
Appendix A	How to install the required software for this book	739
Appendix B	How to install the files and databases used in this book	749
Appendix C	Coding and syntax conventions	757
Index		760

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