Microsoft SQL Server 7 For Dummies (For Dummies Series) - Softcover

Mann, Anthony T.

Softcover

ISBN 10: 0764504169 ISBN 13: 9780764504167

Publisher: For Dummies, 1998

Synopsis

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.

About this title

Review

Microsoft SQL Server 7 for Dummies provides one of the quickest run-throughs of this high-capacity database product and its associated skills, such as database design. Author Anthony T. Mann presents the basic concepts of relational databases, the SQL Server interface and tools, programming techniques, and enterprise management issues.

The book begins with a general introduction to both Microsoft SQL Server and SQL databases. Understanding the conceptual model of relational databases and the associated terminology is critical, and Mann moves at a good clip through this material. Diagrams and screen shots illustrate key points and help solidify the terminology.

Next, Mann introduces basic and advanced objects such as tables, indexes, queries, and stored procedures. After this interactive instruction, the author dives into the SQL language, illustrating how to create database objects with the Data Definition Language (DDL) and work with it using the Data Manipulation Language (DML).

This book also covers enterprise issues such as data warehousing, backup and recovery techniques, and security issues. The book ties it all together with a list of online resources and third-party add-on products. If you've been curious about SQL Server, but thought it must involve dry academic learning, give this introduction a spin. --Stephen W. Plain

From the Back Cover

Finally a Book That Makes Network Database a Lot Simpler

• The Fun and Easy Way to Develop a Database System Tailored to Your Business Needs
• Your First Aid Kit for Deploying and Managing Network Databases
• Web Publishing and Security Concerns — Explained in Plain English

Get All the Benefits of Microsoft SQL Server 7...with None of the Complications

Exclusive SQL Server 7 "Cheat Sheet" Inside!

With its new built-in management tools, scores of extra wizards, and support for the latest database standards, Microsoft SQL Server 7 is hotter than ever. And you don't have to lose your sanity or give up your weekends to figure out how to use it. With the expert advice of SQL Server 7 guru Anthony Mann, you'll 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 with it.

Inside, find helpful advice on how to:

• Install Microsoft SQL Server 7 without any headaches
• Create SQL Server objects using wizards, the Enterprise Manager, and the Query Analyzer
• Develop and use stored procedures
• Use SQL to put Microsoft SQL Server 7 to work
• Save time by automating tasks with Jobs and Alerts
• Import and Export data to and from an SQL Server database
• Secure and backup your data
• Publish documents to the Web

Edition details

• Publisher: For Dummies
• Publication date: 1998
• ISBN 10: 0764504169
• ISBN 13: 9780764504167
• Binding: Paperback
• Language: English
• Number of pages: 359