Microsoft SQL Server 2000 in 21 days

Teach Yourself

Richard Waymire, Rick Sawtell

942 pages, parution le 04/12/2002 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days, 2E will clearly define and walk the reader through the features of SQL Server 2000. The reader will be given tips and tricks for working within the new SQL Server 2000 product environment as well as working with SQL Server databases. The book will feature information on:

Create and alter databases.
Manage security and implement permissions.
Protect, backup, and restore data.
Enforce and ensure data integrity.
Modify and manipulate data.
Create views, triggers, functions, and stored procedures.

Contents

WEEK 1. AT A GLANCE.

Day 1. Introducing Relational Databases and Microsoft SQL Server 2000.
Day 2. Installing Microsoft SQL Server 2000.
Day 3. Working with SQL Server 2000 Management Tools and Utilities.
Day 4. Creating and Administering Databases and Data Files.
Day 5. Setting Up Login and User Security.
Day 6. Establishing Database Permissions.
Day 7. Backing Up Your Databases.
Week 1. In Review.

WEEK 2. AT A GLANCE.

Day 8. Restoring Your Databases.
Day 9. Data Types and Creating Tables.
Day 10. Retrieving Data with the SELECT Statement.
Day 11. Modifying Data.
Day 12. Using Transact-SQL Extensions.
Day 13. Indexing for Performance.
Day 14. Ensuring Data Integrity.
Week 2. In Review.

WEEK 3. AT A GLANCE.

Day 15. Creating Views, Triggers, Stored Procedures, and Functions.
Day 16. Understanding Replication Design Methodologies.
Day 17. Implementing Replication Methodologies.
Day 18. Scheduling Jobs with SQL Server Agent.
Day 19. Migrating Data Between Database Servers.
Day 20. Performance Monitoring Basics and Tools.
Day 21. Using XML with SQL Server 2000.
Week 3. In Review.

Bonus Day At a Glance.

Day 22. An Overview of Analysis Services.
Day 23. An Overview of English Query.

APPENDIXES.

Appendix A. Answers to Quiz Questions.
Appendix B. Installing MSDE 2000.
Appendix C. High Availability.

L'auteur - Richard Waymire

Richard Waymire, a program manager with the SQL Server development team at Microsoft, is also a Microsoft Certified Trainer, Solutions Developer, and Systems Engineer + Internet. He's the immediate past president of the Pacific NorthWest SQL Server User's Group. Richard was a SQL Server trainer before joining Microsoft. Although he has also focused on training and consulting on Windows NT and other BackOffice and development technologies, he's still a database administrator at heart. You can reach Richard at rwaymi@hotmail.com.

L'auteur - Rick Sawtell

Rick Sawtell, MCT, is an independent consultant and also teaches classes on SQL Server, Access, and Visual Basic.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sams
Auteur(s)	Richard Waymire, Rick Sawtell
Parution	04/12/2002
Édition	2^eme édition
Nb. de pages	942
Format	18,7 x 23
Couverture	Broché
Poids	1538g
Intérieur	Noir et Blanc
EAN13	9780672324697
ISBN13	978-0-672-32469-7