Skip to Content
Database Administration: The Complete Guide to Practices and Procedures
book

Database Administration: The Complete Guide to Practices and Procedures

by Craig S. Mullins
June 2002
Intermediate to advanced
736 pages
17h 21m
English
Addison-Wesley Professional

Overview

"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, Senior Oracle Certified Instructor, Contemporary Technologies

"I think every business manager and every IT manager should have a copy of this book."—Dan Hotka, Senior Technical Advisor, Quest Software Inc.

With Database Administration, database professionals now have a comprehensive sourcebook of strategies for delivering quality administration across today's challenging multi-DBMS environments. Filled with practical guidelines and strategies, this book provides the most comprehensive survey available of the administrator's world for the existing or aspiring database professional.

Part tutorial and part reference, Database Administration explains and examines each of the components that comprise the discipline of database administration. The book opens by providing an overview of the responsibilities of database administrators (DBAs) along with the various "flavors" of DBAs and their tasks. From there, the book proceeds chronologically through every task a DBA is likely to encounter. Although designed as a comprehensive survey of the entire DBA environment, the book's individual chapters are also well suited for quick look-up of specific information.

Highlights include:

  • The world of the DBA: types, tasks, daily issues, and much more

  • The DBA environment—installation and upgrading issues, standards, and procedures

  • Data modeling and normalization

  • Database design and application design

  • Performance management, including system, database, and application performance

  • Ensuring data integrity and database security

  • Database back-up and recovery strategies and disaster planning

  • Storage management and data warehouse administration

  • Connectivity, metadata management, Internet-enabled database access, and additional DBA tools

  • Platform-independent coverage applicable for all the major DBMS products including DB2, Oracle, and SQL Server

  • Whether you're a database analyst, architect, or application engineer, this book will provide the strategies and solutions you need to navigate the rocky terrain of today's complex data environments.



    0201741296B05142002

    Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
    and much more.

    Read now

    Unlock full access

    More than 5,000 organizations count on O’Reilly

    AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

    QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
    Julian F.
    Head of Cybersecurity
    QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
    Addison B.
    Field Engineer
    QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
    Amir M.
    Data Platform Tech Lead
    QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
    Mark W.
    Embedded Software Engineer

    You might also like

    Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition

    Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition

    Craig S. Mullins
    Executing Successful Change Management

    Executing Successful Change Management

    MIT Sloan Management Review
    Three Essentials for Agentic AI Security

    Three Essentials for Agentic AI Security

    Paolo Dal Cin, Daniel Kendzior, Yusof Seedat, Renato Marinho
    Reporting, Predictive Analytics, and Everything in Between

    Reporting, Predictive Analytics, and Everything in Between

    Brett Stupakevich, David Sweenor, Shane Swiderek

    Publisher Resources

    ISBN: 0201741296Purchase book