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 * 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"
This book is a guide to the discipline of modern database administration and gives detailed instructions and requirements of database administration. It is an excellent book for learning database administration activities, processes and procedures. All stages from creating a database to managing and maintaining the database are detailed. This book is useful for novice DBAs, database professionals and system administrators.
The author gives real-time solutions and examples from database administration experience and explains how to successfully deal with the problems and issues of managing and maintaining databases in software projects.
This book consists of 24 chapters, each detailing a specific topic, such as roles and responsibilities of database administrator; database design; database change management; performance management systems; database and application performances; database security, and rules of thumb for databases such as Oracle, DB2, SQL Server and Sybase. This book also gives a comprehensive sequential overview of a DBA job.
The appendix section provides an extremely useful list of DBMS vendors, DBA tool vendors, DBA web resources, and sample DBA job postings.
Reviewed by Sreerekha Bakaraju MBCS, Software Professional