Sams Teach Yourself Microsoft SQL Server 7 in 21 Days - Richard Waymire, Rick Sawtell

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

Buch | Softcover
800 Seiten
1999
Sams Publishing (Verlag)
978-0-672-31290-8 (ISBN)
45,85 inkl. MwSt
  • 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
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Der schnelle Einstieg

von Klemens Konopasek

Buch | Hardcover (2018)
Carl Hanser (Verlag)
40,00
Das umfassende Handbuch. Inkl. Analysis und Reporting Services

von Daniel Caesar; Michael R. Friebel; Hans Georg Selent-Knips

Buch | Hardcover (2020)
Rheinwerk (Verlag)
49,90