MCSE: Administering Microsoft SQL Server 7

MCSE: Administering Microsoft SQL Server 7

          
5
4
3
2
1

Available


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Quantity:
Add to Wishlist

About the Book

This is a great guide to passing Microsoft's System Administration for Microsoft SQL Server 7 exam - and every bit as valuable once you've passed the exam and you're running an SQL Server system. Written by a top SQL Server expert, the book starts with an overview of SQL Server 7 and SQL fundamentals, then shows how to build database objects - including tables, views, database roles, stored procedures, indexes, and more. It reviews key SQL Server components, including the Distributed Transaction Coordinator, SQL Server Agent, SQL Mail, Replication Monitor, Data Transformation Packages and more. From start to finish, it delivers comprehensive guidance on planning, installing, configuring and optimizing SQL Server 7. The book includes test questions at the end of each chapter, sample texts in the appendix, access to an interactive training Web site - even a free CBT Systems course on the CD-ROM, worth $225!

Table of Contents:
I. MICROSOFT SQL SERVER OVERVIEW. 1. An Overview of Microsoft SQL Server. Microsoft SQL Server and Windows NT. Windows NT Subsystems. Windows 95/98. Client/Server and Microsoft SQL Server. Why Use SQL Applications? Ease of Use. Simplify Systems. Enforcement of Business Procedures. Building Custom Applications. Cost Factors. Multiprocessing Versus Multithreaded. Multiprocess Systems. Multithreaded Systems. Networking. Protocol Options. Local Area Networks. Wide Area Networks. Internet or Intranet. Commonly Used SQL Server Interfaces. Transact-SQL. OLE DB. ODBC. Microsoft English Query. Fundamentals of Database Building. The Relational Database. What Is a Relational Database? The Normalized Database. Tables, Columns, and Rows. Device Independence. Key Points. Chapter Review Questions. 2. What Is SQL? T-SQL and ANSI-SQL. Standards and Compatibility. Types of SQL Commands. Data Definition Language (DDL). Data Manipulation Language (DML). Data Control Language (DCL). Commonly Used T-SQL Statements. How to Use T-SQL Statements. SELECT. INSERT. UPDATE. DELETE. Transactions and SQL. Key Points. Chapter Review Questions. 3. SQL Server Structure. Creating a Database with SQL Server 7.0. Compatibility with Earlier Devices. Database Objects. Tables. Views. Database Roles. Defaults. Rules. Stored Procedures. Triggers. Cursors. Indexes. System Catalog. Key Points. Chapter Review Questions. 4. Microsoft SQL Server Components. SQL Mail. Database Maintenance Plans. Processes. Files. master Database. model Database. msdb Database. Sample Databases. tempdb Database. Log Files. Web Files. Key Points. Chapter Review Questions. 2. INSTALLATION AND CONFIGURATION. 5. Installing Microsoft SQL Server 7.0. Operating System Requirements. Windows NT. Windows 95/98. Hardware Requirements. Required User Accounts. Running the Setup Application. Full-Text Search Option. Installation Options. Network Installations. Installing SQL Server Clients Tools. Troubleshooting Setup. Client Connections. Key Points. Chapter Review Questions. 6. Configuration Options. Optimizing Memory Usage. System Memory. Monitoring and Profiling. Performance Monitors. The Profiler. Allocating Memory. Optimizing Disk Performance. The Multithreaded Server. Key Points. Chapter Review Questions. 7. Startup and Shutdown. Starting Microsoft SQL Server. Using the Services Applet. Using the SQL Server Enterprise Manager. SQL Server Service Manager. Using the Server Manager. Using a Command Line Startup. Options for Startup. Troubleshooting Startup. Using the SQL Server Error Log. Using the Windows NT Event Viewer. Viewing the Output Files. Checking Named Pipes. Key Points. Chapter Review Questions. 3. PLANNING AND MANAGING SECURITY. 8. Security. Identification and Authentication. Windows NT Security. SQL Server Security. Database Security. Selecting the Type of Security. Windows NT Authentication. SQL Server Authentication. Mixed Security. Trusted Connections. Setting Security Modes. Creating Users. Devising Usernames. Passwords. Guest User. Using Roles. Application Roles. An Owner. Using the Permissions System. GRANTing Permission. DENYing Permission. REVOKE Permissions. Permissions and the SQL Server Enterprise Manager. Using the SQL Server Security Wizard. Security Between Linked Servers. Key Points. Chapter Review Questions. 4. WORKING WITH DATABASE FILES. 9. Managing Your Database Files. The Relational Database. The Normalized Database. Tables, Columns, and Rows. What Is a Relational Database? Device Independence. Key Points. Chapter Review Questions. 10. What Is Data Integrity? What Is Data Integrity? Entity Integrity. Primary Key Constraint. UNIQUE Constraints. Using the uniqueidentifier Data Type. Domain Integrity. The DEFAULT Constraint. Using the CHECK Constraint. Domain Rules. Datatypes. Referential Integrity. What Is Referential Integrity? User-Defined Integrity. Key Points. Chapter Review Questions. 11. Data Consistency and Concurrency. Statements and Transactions. Using Locks for Consistency. Understanding a Lock. Setting Transaction Isolation Level. Key Points. Chapter Review Questions. 12. Managing Database Space. Planning Database Space Requirements. Planning the Database. Sizing the Log File. Expanding a Database. Shrinking a Database. Deleting a Database. Key Points. Chapter Review Questions. 5. TRANSFERRING DATA. 13. PLANNING DATA TRANSFERS. Where Is the Data Now? What Kind of Data? Transforming Versus Inserting Data. Key Points. Chapter Review Questions. 14. Methods of Transferring Data. Using the Bulk Copy Program (bcp). Making a Database Ready for bcp. Creating the bcp Format File. Editing the bcp Format File. Using SELECT INTO Statements. SQL Server Version Upgrade Wizard. Data Transformation Services (DTS). What Is DTS? Scrubbing and Validating Data. Creating a Data Warehouse. Key Points. Chapter Review Questions. 6. BACKING UP A DATABASE. 15. Why Back Up Your Data. Types of Failures. Client Application Failure. Program Failure. Disk or Media Failures. Key Points.Chapter Review Questions. 16. Backing Up the Database. Using Backups. Forms of Backups. Creating Your Backup Strategy. Creating a Backup Device. Performing a Backup. Heavy Duty Protection-Mirrors and RAID. RAID and Disk Arrays. Using Removable Media. SQL Server Failover Support. Key Points. Chapter Review Questions. 7. RESTORING DATABASES. 17. Restoring the Database. Restoring a Database. Restoring a Damaged Database. Restoring Transaction Logs and Differential Backups. Recovering the Master Database. Key Points. Chapter Review Questions. 8. MONITORING SQL SERVER PERFORMANCE. 18. Optimizing Performance. Optimizing Queries. Cost-Based Optimization. Clustered Indexes. Using Nonclustered Indexes. Creating Useful Indexes. Other Performance-Tuning Factors. Creating Full-Text Search Indexes. Key Points. Chapter Review Questions. 9. AUTOMATING TASKS. 19. The SQL Server Agent. The Role of the SQL Server Agent. Setting Up the SQL Server Agent Service. The SQL Server Agent Error Logs. Multiserver Administration. Creating the Multiserver Group. Defecting a Target Server. Key Points. Chapter Review Questions. 20. Creating and Using Schedules. Defining a Job. Starting a Job Definition. Defining the Steps of a Job. Creating Schedules. Using Notifications on a Job. Troubleshooting Scheduling. Stopping a Scheduled Job. Using a Stored Procedure. Using Alerts. Setting Alerts. Alert Responses. Using a Stored Procedure with Alerts. Removing an Alert. Key Points. Chapter Review Questions. 10. PUBLISHING DATA ON THE WEB. 21. Your Data and the Web. The Web Assistant. Key Points. Chapter Review Questions. 11. Beginning Replication. 22. Replication Basics. Replication Models. Publisher. Subscriber. Replicated Data. Push Versus Pull. Types of Replication. Snapshot Replication. Transactional Replication. Merge Replication. Key Points. Chapter Review Questions. 12. PLANNING A REPLICATION STRATEGY. 23. Planning and Setting Up a Replication Strategy. Planning Replication. What Information Needs to be Replicated. Choosing a Replication Model. When to Replicate. Site Autonomy. Who Can Subscribe? Setting Up Your Servers. Setting Up a Publisher and Distributor. Setting Up Subscribing Servers. Replication and Synchronization. Creating Articles and Publications. Key Points. Chapter Review Questions. 13. MANAGING REPLICATION AND DISTRIBUTED TRANSACTIONS. 24.Replication Management. Distributed Transactions. Two-Phase Commit. Definitions. How the Two-Phase Commit Works. Configuring MS DTC. Problem Areas. Heterogeneous Replication. Monitoring Replication. Performance Monitoring Tools. Troubleshooting Replication and Viewing Error Logs. Key Points. Chapter Review Questions. Appendix: Answers to Chapter Review Questions. Index.


Best Sellers


Product Details
  • ISBN-13: 9780130107954
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Height: 242 mm
  • No of Pages: 352
  • Sub Title: Administering Microsoft SQL Server 7
  • Width: 242 mm
  • ISBN-10: 0130107956
  • Publisher Date: 14 Jan 1999
  • Binding: SA
  • Language: English
  • Spine Width: 44 mm
  • Weight: 1351 gr


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
MCSE: Administering Microsoft SQL Server 7
Pearson Education (US) -
MCSE: Administering Microsoft SQL Server 7
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

MCSE: Administering Microsoft SQL Server 7

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA