-- SQL Server has a 50% marketshare in the NT database category and is continuing to grow
-- Database design is complicated, and not well covered in the marketplace. This book will be in high demand by SQL programmers
-- Expert authors -- Poolet writes the SQL by Design column in SQL Server Magazine, and Reilly teaches Microsoft certification course on SQL Server
-- Bonus coverage -- including ethical database design and privacy
"synopsis" may belong to another edition of this title.
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
"About this title" may belong to another edition of this title.
Book Description Osborne/McGraw-Hill, 2000. Paperback. Book Condition: New. Bookseller Inventory # DADAX0072123753
Book Description The McGraw-Hill Company. Book Condition: New. pp. 612. Bookseller Inventory # 7570401