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.
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.
Overview
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 ...