Download Ebook Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins
As we mentioned in the past, the modern technology aids us to consistently recognize that life will certainly be constantly easier. Reviewing e-book Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins routine is additionally one of the perks to get today. Why? Innovation could be made use of to give guide Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins in only soft file system that can be opened up every time you want as well as almost everywhere you require without bringing this Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins prints in your hand.
Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins
Download Ebook Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins
Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins. What are you doing when having extra time? Talking or searching? Why do not you try to read some book? Why should be reading? Reading is among enjoyable and also pleasurable activity to do in your extra time. By checking out from lots of resources, you could locate brand-new details and also encounter. Guides Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins to read will certainly many beginning with scientific publications to the fiction publications. It implies that you could review guides based upon the need that you intend to take. Certainly, it will certainly be different as well as you can read all book kinds whenever. As here, we will certainly reveal you an e-book should be checked out. This e-book Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins is the selection.
Why should be this publication Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins to check out? You will certainly never obtain the understanding as well as encounter without managing yourself there or attempting on your own to do it. For this reason, reviewing this book Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins is needed. You can be great and correct sufficient to obtain how crucial is reading this Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins Also you always review by obligation, you could support on your own to have reading e-book practice. It will certainly be so beneficial as well as fun after that.
However, how is the method to obtain this book Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins Still puzzled? No matter. You can enjoy reviewing this e-book Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins by online or soft file. Simply download and install the e-book Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins in the web link provided to go to. You will obtain this Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins by online. After downloading and install, you could save the soft documents in your computer or gizmo. So, it will certainly alleviate you to review this book Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins in particular time or location. It might be unsure to appreciate reviewing this e-book Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins, due to the fact that you have bunches of work. But, with this soft file, you can appreciate checking out in the extra time also in the voids of your jobs in workplace.
Once again, reading habit will consistently provide beneficial advantages for you. You could not should spend sometimes to check out guide Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins Simply reserved numerous times in our spare or spare times while having dish or in your workplace to review. This Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins will show you brand-new thing that you could do now. It will help you to enhance the top quality of your life. Occasion it is merely an enjoyable publication Database Administration: The Complete Guide To Practices And Procedures, By Craig S. Mullins, you can be healthier and also a lot more fun to appreciate reading.
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.
- Sales Rank: #1012368 in Books
- Published on: 2002-06-24
- Original language: English
- Number of items: 1
- Dimensions: 8.90" h x 1.60" w x 7.40" l, 2.75 pounds
- Binding: Paperback
- 736 pages
From the Back Cover
"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
About the Author
Craig S. Mullins is a data management strategist for BMC Software. Craig has more than fifteen years of experience in all facets of database systems development, including developing and teaching DB2 and SQL Server classes, systems analysis and design, database and system administration, and data analysis. He has used DB2 for OS/390 since Version 1 and has experience with Oracle, Sybase, and Microsoft SQL Server. Craig has worked as a DBA, developer, instructor, and analyst in multiple industries.
0201741296AB05142002
Excerpt. � Reprinted by permission. All rights reserved.
A Database Management System (DBMS) is used to create databases. Most of today's applications deploy databases to store information like names, addresses, account balances, etc. This information can be accessed and manipulated by application programs to perform business processes (like payroll processing, sales processing, and customer billing). Every DBMS requires database administration to ensure efficient and effective usage of databases by applications. This means that every user of Oracle, Microsoft SQL Server, DB2, Informix, Sybase, mySQL, Teradata, PostgreSQL, Ingres and any other popular DBMS will benefit from the information in this book.
Many organizations have multiple of these products and will benefit from a consolidated view of DBA that does not focus on the internals and nuances of each particular DBMS product. Such a view is presented in this text.This book provides the industry's first non-product based description of database administration techniques and practices. The book defines the job of database administrator and outlines what is required of a DBA in clear, easy-to-understand language. The book can be used:
* As a text for learning the discipline of database administration
* As the basis for setting up a DBA group
* To augment a DBMS-specific manual or text book
* To help explain to upper-level management what a DBA is, and why it is required.
Every organization that deploys databases using a DBMS needs to understand the concepts outlined in this book. Many small to medium organizations attempt to implement DBMS products without DBA. This book explains the practice of DBA and can be used to educate these organizations as to the necessity of DBA in order for DBMS implementation to succeed. Other organizations implement only subsets of the DBA practices that are covered in this book. With a thorough reading of Database Administration: Practices and Procedures, it will become quite clear that a comprehensive approach to DBA is required. This book examines and explains each of the components that comprise the discipline of database administration.
As technology advances new IT techniques emerge that impact the discipline of DBA. Two such areas are Internet-enabled database access and storing procedural logic in the DBMS in the form of triggers, user-defined functions, and stored procedures. Because the impact of these newer technologies and techniques on the role of the DBA is examined in this book, even seasoned database professionals will find the book useful. Indeed, the book will be helpful for any and all of the following folks:
* Anyone who want to understand what DBAs do
* DBA Managers
* IT professionals who want to become DBAs
* IT professionals new to implementing a DBMS
* Students of Database Management
* DBAs
* Systems Programmers and System Administrators who interface with DBAs and need to understand what it is that DBAs do
Because this book covers heterogeneous database administration without focusing on just one DBMS, it can be used by organizations to set up a DBA function when more than one DBMS product is being used. This is particularly important because Gartner Group, the industry analyst firm, estimates that most medium to large organizations have from 3 to 10 different DBMS products in use that require administration. The single-DBMS shop is a rarity these days.
Additionally, DBA positions are currently very hot, with DBAs demanding and obtaining very high salaries. As such, many technicians aspire to become DBAs and this book will help them to do just that. If you are an IT professional with interest in becoming a DBA, this book will help you to achieve that objective.Other books about database administration are available, but they approach the subject from the perspective of a single DBMS. Many of these books are quite good. I wrote one myself for DB2. This book is not intended to replace such books, but to augment these books with an independent treatment of database administration tasks. How to Use This book
This book can be used as both a tutorial and a reference. The book is organized to proceed chronologically through DBA tasks that are likely to be encountered. So, if you read the book sequentially from Chapter 1 through Chapter 23 you will get a comprehensive chronological overview of the DBA job. Or you can read any chapter independently if you wish because each chapter deals with a single subject matter. References to other chapters are clearly made where appropriate if other material in the book would aid the reader's understanding.
0201741296P02252002
Most helpful customer reviews
26 of 27 people found the following review helpful.
Comprehensive, thorough and unique
By Mike Tarrani
This book has three things going for it:
(1) It describes the DBA function as it exists in the real world. More importantly, it breaks the categories of "DBA" out into specialities, such as system DBA, data architect, analysts and modelers, developers and data warehouse DBAs - each speciality is vastly different in practice - and provides skill profiles and roles and responsibilities for each.
(2) Proposes an organizational structure for all DBAs, regardless of database (DB2, Oracle, SQL Server, etc.) and skill. As a consultant who specializes in IT organizational management and processes I heartily endorse this structure. It's also consistent with recommendations made in "IT Organization: Building A Worldclass Infrastructure " by Harris Kern, Stuart Galup and Guy Nemiro, and "Building Operational Excellence: Strategies to Improve It People and Processes" by Dale Kutnick and Bruce Allen.
(3) 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 (data modelling, performance and capacity management, tuning, back-up and recovery, etc.)
While achieving the recommendations for organizational structure is a daunting and complex task, assimilating the extensive list of tasks and recommendations can be accomplished quickly. One way to attain immediate value from this book at the organizational level is to derive database administration policies and processes from this book, and refer to this book for the procedures.
The ideal audience for this book includes IT managers who need to understand the complexity and scope of the DBA function under their cognizance, senior DBAs who want to implement consistent procedures, and HR specialists who develop job descriptions and recruit DBAs.
15 of 16 people found the following review helpful.
Highly Recommended
By Sal Ricciardi
This is a well-written, well-organized guide to the practice of data base 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.
Yet, even with that direct focus on database administration, the author succeeds in covering a great deal of ground and cutting a rather wide swathe across the database spectrum, doing so with rigor and expertise and the benefit of experience. While the book will not and is not intended to serve as a reference substitute for product documentation, it will nonetheless enhance your knowledge, and I find it of such quality and utility that I recommend it to anyone in the database field in general. Consider it a base text to serve alongside Date and Codd.
Among the nice touches, the author includes discussion of database denormalization, often missing in discussions on database design. Chapters end with both a set of review questions and a Suggested Reading section, and I find myself in agreement with most of the suggestions. An excellent Bibliography section follows the text. I would have liked to see some discussion of the difference between relational domains in theory and their implementation in practice, particularly as it impacts the design of integrity constraints. Even so, Database Administration is an excellent book and I highly recommend it.
- Sal Ricciardi
20 of 20 people found the following review helpful.
A great referecne on database administration
By Frank Lu
1. This is one of very few titles on general database administration. Most other similar books focus on particular DBMS products.
2. It has a very comprehensive and broad coverage on the subject. The table of contents speaks for itself. Due to its extensiveness, the coverage by and large stays at the strategic and conceptual level, which serves its purpose very well.
3. It compares features of major database products on handling similar jobs.
4. The author clearly has extensive real life DBA experience with different DBMS products and has shared that with a very easy to understand language.
5. It has good resource links.
6. This book would be a great introduction and reference to those who are not only interested in a particular DBMS product but would also like to have a holistic view of database administration.
7. Finally the book has 660 pages before the index rather than 352 pages as stated on this site.
Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins PDF
Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins EPub
Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins Doc
Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins iBooks
Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins rtf
Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins Mobipocket
Database Administration: The Complete Guide to Practices and Procedures, by Craig S. Mullins Kindle
Tidak ada komentar:
Posting Komentar