Résumé
Here's everything you need to harness the power of SQL Server 2000, Microsoft's high-performance, Web-enabled client/server database and data analysis package. With a focus on performance and data integrity, database expert Paul Nielsen shows you how to design performance into your database from day one. From basic installation to working with XML, monitoring, and performance tuning - a topic so hot, it merits an entire section - Nielsen provides clear instructions, sound theory, and a special "Best Practice" icon that points to the most effective way to accomplish a given task. It's more than a guidebook; it's your total SQL Server 2000 toolkit.
Inside, you'll find complete coverage of SQL Server development ·- Design database schemas for performance, adapt integrity, and agility
- Understand ACID and Transactional Integrity and build rock-solid databases
- Use relational algebra to write powerful queries
- Tune indexes as the bridge between data and query
- Analyze Query Execution plans for performance
- Create T-SQL stored procedures, triggers, and user-defined functions
- Share data using DTS, distributed queries, XML, and ADO.NET
- Analyze data with Analysis Services
- Add advanced scalability, availability, performance, and portability to your databaseBonus CD-ROM!
- Sample database applications and code examples from the book
- SQL Server utilities
- Links to Web sites, including the author's SQL Server Web site, www.IsNotNull.com
Contents
Part I: Laying the Foundation- Introducing SQL Server
- Modeling the Logical Database Schema
- Installing and Configuring SQL Server
- Using SQL Server's Developer Tools
- Implementing the Physical Database Schema
- Retrieving Data with Select
- Merging Data Using Relational Algebra
- Searching Full-Text Indexes
- Creating Views
- Modifying Data
- Transactional Integrity
- Programming with Transact-SQL
- Developing Stored Procedures
- Building User-Defined Functions
- Implementing Triggers
- Advanced Server-Side Programming
- Transferring Databases
- Working with Distributed Queries
- Migrating Data with DTS
- Replicating Databases
- ADO and ADO.NET
- XML and Web Publishing
- Configuring SQL Server
- Maintaining the Database
- Automating Database Maintenance with SQL Server Agent
- Recovery Planning
- Securing Databases
- Advanced Performance
- Advanced Availability
- Advanced Scalability
- Analysis Services
- Advanced Portability
Appendix B: Sample Databases
Appendix C: SQL Server 2000 Specifications
Appendix D: What's on the CD?
L'auteur - Paul Nielsen
Paul Nielsen (Hickory, North Carolina) has been a
programmer, computer trainer, and consultant, focusing
exclusively on database development. Currently, he is a SQL
Server trainer at Learning Tree International and publishes
"www.IsNotNull.com,"a free, weekly newsletter for SQL
Server developers. Paul co-authored Inside the Norton
Antivirus (Brady, 1993) with Peter Norton. He also served
as the Technical Editor for "Access Advisor" Magazine and
has written over 110 computer-related articles.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Wiley |
| Auteur(s) | Paul Nielsen |
| Parution | 20/01/2003 |
| Nb. de pages | 928 |
| Format | 18,7 x 23,5 |
| Couverture | Broché |
| Poids | 1393g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780764549359 |
| ISBN13 | 978-0-7645-4935-9 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
