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.
Chapter 1 What Is a DBA?
Chapter 2 Creating the Database Environment
Chapter 3 Data Modeling and Normalization
Chapter 4 Database Design
Chapter 5 Application Design
Chapter 6 Design Reviews
Chapter 7 Database Change Management
Chapter 8 Data Availability
Chapter 9 Performance Management
Chapter 10 System Performance
Chapter 11 Database Performance
Chapter 12 Application Performance
Chapter 13 Data Integrity
Chapter 14 Database Security
Chapter 15 Regulatory Compliance and Database Administration
Chapter 16 Database Backup and Recovery
Chapter 17 Disaster Planning
Chapter 18 Data and Storage Management
Chapter 19 Data Movement and Distribution
Chapter 20 Data Warehouse Administration
Chapter 21 Database Connectivity
Chapter 22 Metadata Management
Chapter 23 DBA Tools
Chapter 24 DBA Rules of Thumb
Appendix A Database Fundamentals
Appendix B The DBMS Vendors
Appendix C DBA Tool Vendors
Appendix D DBA Web Resources
Appendix E Sample DBA Job Posting
