 Professional SQL Server 2000 Programming
ISBN: 978-0-7645-4379-1
Paperback
1440 pages
November 2000
US $59.99
 Add to Cart
This price is valid for United States. Change location to view local pricing and availability. |
Visit Wiley's Higher Education Site for:
Instructors may request an evaluation copy for this title.
|
Chapter 1: SQL Server 2000 – Particulars and History.
Chapter 2: RDBMS Basics: What Makes Up a SQL Server Database?
Chapter 3: Tools of the Trade.
Chapter 4: The Foundation Statements of T-SQL.
Chapter 5: Joining Tables.
Chapter 6: Creating and Altering Tables.
Chapter 7: Constraints.
Chapter 8: Normalization and Other Basic Design Issues.
Chapter 9: SQL Server Storage and Index Structures.
Chapter 10: Views.
Chapter 11: Writing Scripts and Batches.
Chapter 12: Stored Procedures.
Chapter 13: User Defined Functions.
Chapter 14: Transactions and Locks.
Chapter 15: Triggers.
Chapter 16: Advanced Queries.
Chapter 17: Distributed Queries and Transactions.
Chapter 18: SQL Cursors.
Chapter 19: A Brief XML Primer.
Chapter 20: Integration of XML into SQL Server.
Chapter 21: The Bulk Copy Program (bcp).
Chapter 22: Introduction to Data Transformation Services.
Chapter 23: Replication.
Chapter 24: Advanced Design.
Chapter 25: Analysis Services.
Chapter 26: Full-Text Search.
Chapter 27: English Query.
Chapter 28: Security.
Chapter 29: Performance Tuning.
Chapter 30: Administration Overview.
Chapter 31: Advanced DTS.
Chapter 32: Scripting Administrative Functions with WMI.
Appendix A: System Functions.
Appendix B: Function Listing.
Appendix C: Tools for Our Time.
Appendix D: Access Upsizing.
Appendix E: Microsoft Data Transformation Services Package Object Library Reference.
Index.
