Microsoft Sql Server 7.0. Companion Cd-Rom Included

SQL (structured query language) is rapidly emerging as a database language standard, and a practical guide to its use is a must for database programmers. Learn Microsoft SQL Server 7.0 begins with the SQL basics and thoroughly highlights the fundamentals, including database creation, query techniques, and data warehousing. An appendix provides a reference guide to the syntax of the Transact-SQL language. The companion CD-ROM contains the 120-day Evaluation Edition of Microsoft SQL Server 7.0, along with the database used in the chapter exercises. * Create databases, tables, indexes, views, stored procedures, triggers, and database diagrams. * Run queries directly in the database with the Query Analyzer. * Duplicate and distribute data through merge and transactional replications. * Create data warehouses using the OLAP Manager, and learn about the features of this tool. * Transform data using Data Transformation Services. * Learn proper backup and restoration procedures. * Use the reference guide to learn Transact-SQL syntax. * Practice the concepts in the book using the Evaluation Edition of Microsoft SQL Server 7.0 included on the companion CD-ROM.