Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

Richard Waymire, Rick Sawtell (Autoren)

Buch | Softcover

800 Seiten

1999
Sams Publishing (Verlag)
978-0-672-31290-8 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

This tutorial-based book demonstrates the features of SQL Server 7. It provides tips and tricks for working within the SQL Server 7 product environment. The reader is presented with a goal at the beginning of the book, which can be achieved via a series of tasks by the end of the book.

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days gives you the new features and capabilities of SQL Server 7, in a tutorial environment. This book features information on: Row-level locking; SQL Server Query Analyzer (formerly the ISQL/w); Microsoft Manage-ment Console (platform that the Enterprise Manager is now based upon); Update Replication feature (multisite, improved performance and scriptable replication objects); New Wizards such as: Create Database, Create Job, Index Tuning, Version Upgrade and Security; SQL Server Agent which provides unattended job execution and alter/response management; New Transact-SQL statements such as ALTER PROCEDURE, ALTER TRIGGER; and information on recursive triggers and local cursors. It walks you through the features of SQL Server 7, increasing the performance and scalability of your database.

Rick Sawtell is both a Microsoft Certified Solutions Developer as well as a Microsoft Certified Trainer. Richard Waymire is a Principal Engineer with Aris Corp. in Bellevue, WA. He is also a Microsoft Certified Trainer (MCT), Solution Developer (MCSD), and Microsoft Certified Systems Engineer (MCSE).

I. WEEK 1: AT A GLANCE.

Day 1: Introduction to SQL Server 7.0 and Relational Databases.
Day 2: Installing SQL Server 7.0.
Day 3: Using The SQL Server 7.0 Tools And Utilities /Repository/06723/0672312905/conversion/html/0672312905/element_003.html/Repository/06723/0672312905/conversion/html/0672312905/element_003.html.
Day 4: Creating and Implementing Databases, Files, and Filegroups
Day 5: Using SQL Server Login and User Security.
Day 6: Working with Permissions.
Day 7: Implementing Backups in SQL Server 7.0.
II. WEEK 2: AT A GLANCE.

Day 8: Restoring SQL Server Databases.
Day 9: Creating Tables.
Day 10: Using SQL Server 7.0 Data Transformation Services.
Day 11: Retrieving Data with Queries.
Day 12: Data Modification with Queries.
Day 13: Enhancing Performance with Indexing.
Day 14: Ensuring Data Integrity.
III. WEEK 3: AT A GLANCE.

Day 15: Working with Views, Stored Procedures, and Triggers.
Day 16: Programming SQL Server 7.0.
Day 17: Understanding Replication Design and Methodologies.
Day 18: Implementing Replication Methodologies.
Day 19: Using the SQL Server Agent.
Day 20: Configuring and Monitoring SQL Server 7.0.
Day 21: Integrating SQL Server and the World Wide Web.
III. WEEK 3: IN REVIEW.

Appendix A.
Answers.

Erscheint lt. Verlag	7.1.1999
Verlagsort	Indianapolis
Sprache	englisch
Maße	189 x 231 mm
Gewicht	1306 g
Themenwelt	Informatik ► Datenbanken ► SQL Server
	Mathematik / Informatik ► Informatik ► Netzwerke
	Mathematik / Informatik ► Informatik ► Software Entwicklung
ISBN-10	0-672-31290-5 / 0672312905
ISBN-13	978-0-672-31290-8 / 9780672312908
Zustand	Neuware