Craig Mullins' 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 environment, this book fully reflects the field's latest realities and challenges. Drawing on his unsurpassed database experience, Mullins focuses on the problems today's DBAs actually face, and the skills and knowledge they simply must have. Mullins covers every aspect of the DBA role, including creating database environments; data modeling and normalization; design; performance; data integrity; compliance and governance; security; backup/recovery; disaster planning; data and storage management; data movement/distribution; data warehousing; database connectivity; metadata; tools, and more. This edition's updates and improvements include: * New coverage of Big Data database appliances, cloud computing, NoSQL, and other crucial trends * An all-new chapter on regulatory compliance and the DBA * New material on data breaches, auditing, data encryption, data retention, database archiving, data masking and sound metadata management policies * Coverage of important new features in leading databases (e.g. temporal data, multi-level security) * End of chapter questions that reinforce readers' understanding and can serve as project-oriented classroom assignments * New glossary and updated DBA rules of thumb""
“I’ve forgotten how many times I’ve recommended this book to people. It’s well written, to the point, and covers the topics that you need to know to become an effective DBA.”
—Scott Ambler, Thought Leader, Agile Data Method
“This is a well-written, well-organized guide to the practice of database administration. Unlike other books on general database theory or relational database theory, this book focuses more directly on the theory and reality of database administration as practiced by database professionals today, and does so without catering too much to any specific product implementation. As such, Database Administration is very well suited to anyone interested in surveying the job of a DBA or those in similar but more specific roles such as data modeler or database performance analyst.”
—Sal Ricciardi, Program Manager, Microsoft
“One of Craig’s hallmarks is his ability to write in a clear, easy-to-read fashion. The main purpose of any technical book is to transfer information from writer to reader, and Craig has done an excellent job. He wants the reader to learn—and it shows.”
—Chris Foot, Manager, Remote DBA Experts and Oracle ACE
“A complete and comprehensive listing of tasks and responsibilities for DBAs, ranging from creating the database environment to data warehouse administration, and everything in between.”
—Mike Tarrani, Computer Consultant
“I think every business manager and every IT manager should have a copy of this book.”
—Dan Hotka, Independent Consultant and Oracle ACE
“This book by Craig Mullins is wonderfully insightful and truly important. Mullins describes the role and duties of data administrators and database administrators in modern organizations with remarkable insight and clarity.”
—Michael Tozer, Author and former U.S. Navy officer
