Home > Computing and Information Technology > Databases > Database Administration: The Complete Guide to DBA Practices and Procedures
Database Administration: The Complete Guide to DBA Practices and Procedures

Database Administration: The Complete Guide to DBA Practices and Procedures

          
5
4
3
2
1

International Edition


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

Database Administration, Second Edition, is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field’s latest realities and challenges. Drawing on more than thirty years of database experience, Mullins focuses on problems that today’s DBAs actually face, and skills and knowledge they simply must have.   Mullins presents realistic, thorough, and up-to-date coverage of every DBA task, including creating database environments, data modeling, normalization, design, performance, data integrity, compliance, governance, security, backup/recovery, disaster planning, data and storage management, data movement/distribution, data warehousing, connectivity, metadata, tools, and more.   This edition adds new coverage of “Big Data,” database appliances, cloud computing, and NoSQL. Mullins includes an entirely new chapter on the DBA’s role in regulatory compliance, with substantial new material on data breaches, auditing, encryption, retention, and metadata management. You’ll also find an all-new glossary, plus up-to-the-minute DBA rules of thumb.

Table of Contents:
How to Use This Book xxxiii Acknowledgments xxxv About the Author xxxvii   Chapter 1: What Is a DBA? 1 Why Learn Database Administration? 3 A Unique Vantage Point 4 The Management Discipline of Database Administration 9 Evaluating a DBA Job Offer 14 Database, Data, and System Administration 15 DBA Tasks 20 DBMS Release Migration 29 The Types of DBAs 31 Staffing Considerations 37 Multiplatform DBA Issues 42 Production versus Test 44 The Impact of Newer Technology on DBA 46 DBA Certification 56 The Rest of the Book 58 Review 58   Chapter 2: Creating the Database Environment 61 Defining the Organization’s DBMS Strategy 61 Installing the DBMS 75 Upgrading DBMS Versions and Releases 82 Database Standards and Procedures 92 DBMS Education 103 Summary 104 Review 104 Suggested Reading 105   Chapter 3: Data Modeling and Normalization 107 Data Modeling Concepts 108 The Components of a Data Model 113 Discovering Entities, Attributes, and Relationships 124 Conceptual, Logical, and Physical Data Models 125 What Is Normalization? 128 The Normal Forms 128 Normalization in Practice 135 Additional Data Modeling Issues 135 Summary 136 Review 137 Suggested Reading 138   Chapter 4: Database Design 141 From Logical Model to Physical Database 141 Database Performance Design 150 Denormalization 160 Views 175 Data Definition Language 177 Temporal Data Support 177 Summary 180 Review 181 Suggested Reading 182   Chapter 5: Application Design 185 Database Application Development and SQL 186 Defining Transactions 205 Locking 210 Batch Processing 221 Summary 222 Review 222 Suggested Reading 223   Chapter 6: Design Reviews 227 What Is a Design Review? 227 Types of Design Reviews 232 Design Review Output 239 Additional Considerations 240 Summary 241 Review 241 Suggested Reading 242   Chapter 7: Database Change Management 243 Change Management Requirements 244 Types of Changes 247 Impact of Change on Database Structures 250 Summary 262 Review 263 Suggested Reading 263   Chapter 8: Data Availability 265 Defining Availability 267 Cost of Downtime 271 Availability Problems 274 Ensuring Availability 287 Summary 296 Review 297 Suggested Reading 298   Chapter 9: Performance Management 299 Defining Performance 299 Service-Level Management 308 Types of Performance Tuning 311 Performance Tuning Tools 313 DBMS Performance Basics 315 Summary 316 Review 316 Suggested Reading 317   Chapter 10: System Performance 319 The Larger Environment 320 DBMS Installation and Configuration Issues 327 System Monitoring 345 Summary 346 Review 346 Suggested Reading 347   Chapter 11: Database Performance 349 Techniques for Optimizing Databases 349 Database Reorganization 365 Summary 371 Review 371 Suggested Reading 372   Chapter 12: Application Performance 373 Designing Applications for Relational Access 373 Relational Optimization 374 Additional Optimization Considerations 391 Reviewing Access Paths 394 SQL Coding and Tuning for Efficiency 399 Summary 407 Review 407 Suggested Reading 408   Chapter 13: Data Integrity 409 Types of Integrity 409 Database Structure Integrity 410 Semantic Data Integrity 414 Temporal Database Systems 444 Summary 446 Review 447 Suggested Reading 448   Chapter 14: Database Security 449 Data Breaches 449 Database Security Basics 451 Granting and Revoking Authority 456 Authorization Roles and Groups 466 Other Database Security Mechanisms 468 Encryption 470 SQL Injection 473 Auditing 477 External Security 478 DBMS Fixpacks and Maintenance 480 Summary 481 Review 481 Suggested Reading 482   Chapter 15: Regulatory Compliance and Database Administration 483 A Collaborative Approach to Compliance 486 Metadata Management, Data Quality, and Data Governance 488 Database Auditing and Data Access Tracking 490 Data Masking and Obfuscation 496 Database Archiving for Long-Term Data Retention 498 Closer Tracking of Traditional DBA Tasks 507 Summary 511 Review 511 Suggested Reading 512   Chapter 16: Database Backup and Recovery 515 The Importance of Backup and Recovery 515 Preparing for Problems 516 Backup 517 Recovery 537 Alternatives to Backup and Recovery 554 Summary 557 Review 557 Suggested Reading 558   Chapter 17: Disaster Planning 559 The Need for Planning 559 General Disaster Recovery Guidelines 563 Backing Up the Database for Disaster Recovery 569 Disaster Prevention 575 Summary 576 Review 576 Suggested Reading 577   Chapter 18: Data and Storage Management 579 Storage Management Basics 579 Files and Data Sets 583 Space Management 587 Fragmentation and Storage 595 Storage Options 596 Planning for the Future 608 Summary 609 Review 609 Suggested Reading 610   Chapter 19: Data Movement and Distribution 613 Loading and Unloading Data 614 EXPORT and IMPORT 622 Bulk Data Movement 623 Distributed Databases 626 Summary 633 Review 634 Suggested Reading 635   Chapter 20: Data Warehouse Administration 637 What Is a Data Warehouse? 637 Administering the Data Warehouse 640 Summary 658 Review 658 Suggested Reading 659   Chapter 21: Database Connectivity 661 Multitier, Distributed Computing 661 Network Traffic 670 Databases, the Internet, and the Web 675 Summary 681 Review 682 Suggested Reading 682   Chapter 22: Metadata Management 685 What Is Metadata? 685 Types of Metadata 689 Repositories and Data Dictionaries 691 Summary 696 Review 696 Suggested Reading 697   Chapter 23: DBA Tools 699 Types and Benefits of DBA Tools 699 Examine Native DBA Tools 728 Evaluating DBA Tool Vendors 729 Summary 733 Review 733   Chapter 24: DBA Rules of Thumb 735 Write Down Everything 735 Keep Everything 736 Automate! 737 Share Your Knowledge 739 Analyze, Simplify, and Focus 741 Don’t Panic! 742 Measure Twice, Cut Once 743 Understand the Business, Not Just the Technology 743 Don’t Become a Hermit 745 Use All of the Resources at Your Disposal 745 Keep Up-to-Date 746 Invest in Yourself 747 Summary 748 Final Exam 748   Appendix A: Database Fundamentals 753 What Is a Database? 753 Why Use a DBMS? 754 Summary 759   Appendix B: The DBMS Vendors 761 The Big Three 762 The Second Tier 763 Other Significant Players 763 Open-Source DBMS Offerings 764 Nonrelational DBMS Vendors 765 NoSQL DBMS Vendors 765 Object-Oriented DBMS Vendors 766 PC-Based DBMS Vendors 766   Appendix C: DBA Tool Vendors 769 The Major Vendors 769 Other DBA Tool Vendors 770 Data Modeling Tool Vendors 771 Repository Vendors 772 Data Movement and Business Intelligence Vendors 773   Appendix D: DBA Web Resources 775 Usenet Newsgroups 775 Mailing Lists 776 Web Sites, Blogs, and Portals 778   Appendix E: Sample DBA Job Posting 785 Job Posting 785   Bibliography 793 Database Management and Database Systems 793 Data Administration, Data Modeling, and Database Design 799 Database Security, Protection, and Compliance 802 Data Warehousing 804 SQL 805 Object Orientation and Database Management 807 Operating Systems 807 Related Topics 808 DB2 812 IMS 813 MySQL 813 Oracle 814 SQL Server 815 Sybase 816 Other Database Systems 817   Glossary 819 Index 853


Best Sellers


Product Details
  • ISBN-13: 9780133012736
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison Wesley
  • Language: English
  • Sub Title: The Complete Guide to DBA Practices and Procedures
  • ISBN-10: 0133012735
  • Publisher Date: 09 Oct 2012
  • Binding: Digital download
  • No of Pages: 928
  • Weight: 1 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
Database Administration: The Complete Guide to DBA Practices and Procedures
Pearson Education (US) -
Database Administration: The Complete Guide to DBA Practices and Procedures
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.

Database Administration: The Complete Guide to DBA Practices and Procedures

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