Book description
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
- Title Page
- Copyright Page
- Accolades for Database Administration
- Dedication Page
- Contents
- Preface
- Acknowledgments
- About the Author
- 1. What Is a DBA?
- 2. Creating the Database Environment
- 3. Data Modeling and Normalization
- 4. Database Design
- 5. Application Design
- 6. Design Reviews
- 7. Database Change Management
- 8. Data Availability
- 9. Performance Management
- 10. System Performance
- 11. Database Performance
- 12. Application Performance
- 13. Data Integrity
- 14. Database Security
- 15. Regulatory Compliance and Database Administration
- 16. Database Backup and Recovery
- 17. Disaster Planning
- 18. Data and Storage Management
- 19. Data Movement and Distribution
- 20. Data Warehouse Administration
- 21. Database Connectivity
- 22. Metadata Management
- 23. DBA Tools
- 24. DBA Rules of Thumb
- A. Database Fundamentals
- B. The DBMS Vendors
- C. DBA Tool Vendors
- D. DBA Web Resources
- E. Sample DBA Job Posting
- Bibliography
- Glossary
- Index
- Footnotes
Product information
- Title: Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition
- Author(s):
- Release date: October 2012
- Publisher(s): Addison-Wesley Professional
- ISBN: 9780133012743
You might also like
book
Database Administration: The Complete Guide to Practices and Procedures
"One of Craig's hallmarks is his ability to write in a clear, easy-to-read fashion. The main …
book
Introduction to Database Management Systems
Introduction to Database Management Systems is designed specifically for a single semester, namely, the first course …
book
Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition
The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by …