Microsoft SQL Server 7 For Dummies
Published on 26. October 1998
Book
Paperback/Softback
360 pages
978-0-7645-0416-7 (ISBN)
Description
Don't lose your sanity, or your spare time, trying to figure out how to use Microsoft SQL Server 7. With the expert advice of SQL guru Anthony Mann, you can quickly and easily develop the expertise you need to build, deploy, and manage a reliable, scalable database system that can handle your entire business and grow as your business grows.
Get all the benefits of Microsoft SQL Server 7 with none of the headaches. Microsoft SQL Server 7 For Dummies helps you create SQL Server objects step-by-step by using built-in wizards, the Enterprise Manager, and the Query Analyzer. Develop and re-use stored procedures, save time by automating common tasks with Jobs and Alerts, import and export data to and from an SQL Server database, and keep your data secure and backed up with the tips, tricks, and techniques you'll discover inside Microsoft SQL Server 7 For Dummies. This book features a CD-ROM full of must-have SQL Server tools, too, including programs for automatically building multitier applications, creating SQL Server objects, and generating SQL Server-friendly Visual Basic code.
Get all the benefits of Microsoft SQL Server 7 with none of the headaches. Microsoft SQL Server 7 For Dummies helps you create SQL Server objects step-by-step by using built-in wizards, the Enterprise Manager, and the Query Analyzer. Develop and re-use stored procedures, save time by automating common tasks with Jobs and Alerts, import and export data to and from an SQL Server database, and keep your data secure and backed up with the tips, tricks, and techniques you'll discover inside Microsoft SQL Server 7 For Dummies. This book features a CD-ROM full of must-have SQL Server tools, too, including programs for automatically building multitier applications, creating SQL Server objects, and generating SQL Server-friendly Visual Basic code.
More details
Language
English
Place of publication
Foster City
United States
Publishing group
John Wiley & Sons Inc
Target group
College/higher education
Dimensions
Height: 233 mm
Width: 189 mm
Thickness: 22 mm
Weight
624 gr
ISBN-13
978-0-7645-0416-7 (9780764504167)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
Anthony T. Mann, a partner in Strategic Innovations Consulting, Inc., a Denver-based consulting firm, has many years of experience developing and teaching client/server applications with Microsoft SQL Server. He holds Microsoft certifications in SQL Server, Visual Basic, Windows NT, and Windows architecture.
Content
Introduction.
Part I: An Introduction to Microsoft SQL Server 7.
Chapter 1: A Quick Tour of Microsoft SQL Server 7 Tools.
Chapter 2: Installing Microsoft SQL Server 7.
Chapter 3: Why Not Just Use Microsoft Access?
Part II: Database Design.
Chapter 4: Understanding the Relational Data Model.
Chapter 5: Creating Base-level SQL Server Objects.
Chapter 6: Creating Advanced SQL Server Objects.
Chapter 7: Fun with Stored Procedures.
Part III: Interface Design.
Chapter 8: Making Microsoft SQL Server 7 Work by Using SQL.
Chapter 9: Now That I Have a Structure, How Do I Use It?
Chapter 10: Using Jobs and Alerts to Make SQL Server Work for You.
Chapter 11: Maintaining Flexibility by Importing and Exporting Data.
Part IV: Enterprise Issues.
Chapter 12: Building the Best Little Warehouse in Texas.
Chapter 13: Security: Protecting Against Peeping Toms!
Chapter 14: Preventing the Inevitable Disaster (Losing Data)!
Chapter 15: So You Want to Be Published?
Part V: The Part of Tens.
Chapter 16: Ten Microsoft SQL Server Online Resources.
Chapter 17: Ten Popular Ways to Give SQL Server More Pizzazz.
Part VI: Appendixes.
Appendix A: Wizard Flowcharts.
Appendix B: Glossary.
Appendix C: About the CD.
Index.
IDG Books Worldwide End-User License Agreement.
Installation Instructions.
Book Registration Information.
Part I: An Introduction to Microsoft SQL Server 7.
Chapter 1: A Quick Tour of Microsoft SQL Server 7 Tools.
Chapter 2: Installing Microsoft SQL Server 7.
Chapter 3: Why Not Just Use Microsoft Access?
Part II: Database Design.
Chapter 4: Understanding the Relational Data Model.
Chapter 5: Creating Base-level SQL Server Objects.
Chapter 6: Creating Advanced SQL Server Objects.
Chapter 7: Fun with Stored Procedures.
Part III: Interface Design.
Chapter 8: Making Microsoft SQL Server 7 Work by Using SQL.
Chapter 9: Now That I Have a Structure, How Do I Use It?
Chapter 10: Using Jobs and Alerts to Make SQL Server Work for You.
Chapter 11: Maintaining Flexibility by Importing and Exporting Data.
Part IV: Enterprise Issues.
Chapter 12: Building the Best Little Warehouse in Texas.
Chapter 13: Security: Protecting Against Peeping Toms!
Chapter 14: Preventing the Inevitable Disaster (Losing Data)!
Chapter 15: So You Want to Be Published?
Part V: The Part of Tens.
Chapter 16: Ten Microsoft SQL Server Online Resources.
Chapter 17: Ten Popular Ways to Give SQL Server More Pizzazz.
Part VI: Appendixes.
Appendix A: Wizard Flowcharts.
Appendix B: Glossary.
Appendix C: About the CD.
Index.
IDG Books Worldwide End-User License Agreement.
Installation Instructions.
Book Registration Information.