SQL Server 2000 Design and TSQL Programming (Database Professional's Library)

Poolet, Michelle

ISBN 10: 0072123753 / ISBN 13: 9780072123753

Published by Osborne/McGraw-Hill, 2000

About this Item

Most items will be dispatched the same or the next working day. A copy that has been read but remains in clean condition. All of the pages are intact and the cover is intact and the spine may show signs of wear. The book may have minor markings which are not specifically mentioned.

Seller Inventory # rev8050276568

Bibliographic Details

• Title: SQL Server 2000 Design and TSQL Programming (Database Professional's Library)
• Publisher: Osborne/McGraw-Hill
• Publication Date: 2000
• Language: English
• ISBN 10: 0072123753
• ISBN 13: 9780072123753
• Binding: paperback
• Condition: Good
• Weight: 1202 grams

About this title

Synopsis

Build the best SQL Server 2000 database solution for your organization. This book explains how to design a robust, scalable SQL Server 2000 database model, planning for business requirements, data integrity, and security. You'll learn to write queries and develop custom reports and views and create stored procedures, functions, and triggers in T-SQL.

From the Back Cover

Design, develop, implement, and optimize a SQL Server 2000 database that meets your company's needs.

SQL Server 2000 Design and T-SQL Programming explains how to plan and build a database from the ground up in SQL Server 2000. You'll start with data modeling and database design and then you'll implement your database plan. Next, you'll learn to query the database, generate reports, and create custom views. Then, it's on to data integrity, triggers, stored procedures, and distributed data topologies. Throughout the book, you'll follow a real-world business model that demonstrates a SQL Server 2000 database plan in action.

Plan and design an SQL Server 2000 database Map an entity-relationship diagram to a database table architecture Create tables and load data into your database Write queries and use the Query Analyzer Window Combine data from multiple tables using joins and subqueries Write summary reports which aggregate data and group by common values Create custom views Write transaction control statements and locking schemes Handle performance tuning and optimization Create stored procedures and triggers Manage distributed database queries and transactions