Sams Teach Yourself Microsoft SQL Server 7 in 21 Days
Published on 7. January 1999
Book
Paperback/Softback
800 pages
978-0-672-31290-8 (ISBN)
Description
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.
More details
Language
English
Place of publication
Indianapolis
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 231 mm
Width: 189 mm
Thickness: 45 mm
Weight
1306 gr
ISBN-13
978-0-672-31290-8 (9780672312908)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
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).
Content
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.
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.