SQL Server 2000 Design and T-SQL Programming
Michelle Poolet, Michael Poolet, Michelle Reilly · 2000
From the Publisher: 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. 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 databaseMap an entity-relationship diagram to a database table architectureCreate tables and load data into your databaseWrite queries and use the Query Analyzer WindowCombine data from multiple tables using joins and subqueriesWrite summary reports which aggregate data and group by common valuesCreate custom viewsWrite transaction control statements and locking schemesHandle performance tuning and optimizationCreate stored procedures and triggersManage distributed database queries and transactions