Learn Microsoft SQL Server 7 by successfully completing hands-on projects You don't have to be a fortune teller to realize that Microsoft's SQL Server 7 is going to be the most widely used database product on the planet. This book, unlike typical reference books, shows you how to use SQL Server to add value to your business operations. Drawing inspiration from the lab manuals you used in biology and earth science classes, the authors provide step-by-step instructions for accomplishing the kinds of projects you'll want to do with SQL Server. Here's a taste of some of the projects: How to build an e-commerce site with Site Server Commerce Edition Implementing a data-driven Intranet with SQL Server and IIS Creating both single-source and multisource data marts Working with OLAP Services and a variety of OLAP clients Writing Visual Basic applications that work with SQL Server Plus two CD-Roms! CD-ROM 1 contains Microsoft SQL Server 7.0 120-Day Evaluation Edition CD-ROM 2 contains all the code from the book, example applications, 18 third party Development tools, and links to related Web sites
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 23.5 cm
Breite: 19 cm
Spieldauer
Gewicht
ISBN-13
978-0-471-32751-6 (9780471327516)
Schweitzer Klassifikation
GETTING STARTED. Introduction to SQL Server. Installing SQL Server. Backup and Recovery. PROJECTS. Project No.1: Upsizing Your Desktop Database. Project No.2: Publishing SQL Server Data to HTML. Project No.3: Building a Corporate Intranet with Internet Information Server. Project No.4: Create a Single-Source Data Mart. Project No.5: Creating a Multi-Source Data Mart with Data Transformation Services. Project No.6: Working with OLAP Services. Project No.7: Implementing Replication. Project No.8: Getting Started with E-Commerce. Project No.9: Encapsulating Business Logic with Stored Procedures and Triggers. Project No.10: Using Visual Basic to Write SQL Applications. More Project Ideas. APPENDICES. Appendices. Index.