Microsoft SQL Server 2000 provides enterprise-class database solutions, offering interactive development tools and complete management of your relational database applications.
In this book, you'll build a sample database with SQL Server and in the process learn how to design with solutions in mind. If you are migrating from a desktop solution such as Access to SQL Server, this book will provide you with clear and practical demonstrations of the relevant tasks at every stage in the process. Once you've mastered the basics of SQL Server, you'll move on to learn more advanced techniques. By the end of this book, you'll have a firm grasp of the most important SQL Server features and be able to develop your own effective database solutions.
"synopsis" may belong to another edition of this title.
Most titles use screen shots to at least guide readers through installation of computer software and then turn to a more text-based presentation style later on. Not so with this text, which has several hundred screen shots used throughout showing SQL Server tools in action. After covering how to install and configure SQL Server (a trial edition is including on the accompanying CD), the author continues to show off tools like Enterprise Manager and Query Analyzer at work with plenty of step-by-step, hands-on tutorials with plentiful screen shots.
This book walks you through designing and creating a simple database (one that stores results for a golf league). In most every case, the author shows off using a tool alongside a more "manual" approach using SQL to get the job done. (For example, there's step-by-step coverage of how to create tables and indexes using Enterprise Manager, as well as how to do the same tasks using raw SQL in Query Analyzer.) Along the way, there is a solid tutorial to basic SQL for querying, inserting, updating, and deleting data, plus a good introduction to stored procedures and triggers. The strong sections on backing up and restoring databases are all you need to get started with basic database administration in SQL Server. Besides nuts-and-bolts DBA tasks, this book also offers a quick introduction to XML support available on the Microsoft database platform. The text closes with a handy listing of all T-SQL keywords, plus a guide to security options and settings available in SQL Server.
In all, this hands-on guide to database essentials can let you start effectively administering and programming with SQL Server regardless of your level of database experience. --Richard Dragan
Topics Covered:
"About this title" may belong to another edition of this title.
Shipping:
US$ 3.99
Within U.S.A.
Book Description Condition: New. pp. 760. Seller Inventory # 264659704
Book Description Condition: New. pp. 760. Seller Inventory # 3188263