Database Administration

Download or read book Database Administration written by Craig Mullins and published by Addison-Wesley Professional. This book was released on 2002 with total page 736 pages. Available in PDF, EPUB and Kindle. Book excerpt: Giving comprehensive, soup-to-nuts coverage of database administration, this guide is written from a platform-independent viewpoint, emphasizing best practices.

Download or read book Oracle Database Administration for Microsoft SQL Server DBAs written by Michelle Malcher and published by McGraw Hill Professional. This book was released on 2010-10-06 with total page 353 pages. Available in PDF, EPUB and Kindle. Book excerpt: Apply Your SQL Server DBA Skills to Oracle Database Administration Use your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. Install and configure Oracle Database on Windows or Linux systems Administer and monitor databases from Oracle Enterprise Manager Implement robust security using roles, permissions, and privileges Back up and restore databases with Oracle Recovery Manager Use the Oracle cost-based optimizer to tune performance Write, debug, and execute PL/SQL queries using Oracle SQL Developer Maximize availability with Oracle Real Application Clusters Build standby and failover servers using Oracle Data Guard

Download or read book Database Reliability Engineering written by Laine Campbell and published by "O'Reilly Media, Inc.". This book was released on 2017-10-26 with total page 309 pages. Available in PDF, EPUB and Kindle. Book excerpt: The infrastructure-as-code revolution in IT is also affecting database administration. With this practical book, developers, system administrators, and junior to mid-level DBAs will learn how the modern practice of site reliability engineering applies to the craft of database architecture and operations. Authors Laine Campbell and Charity Majors provide a framework for professionals looking to join the ranks of today’s database reliability engineers (DBRE). You’ll begin by exploring core operational concepts that DBREs need to master. Then you’ll examine a wide range of database persistence options, including how to implement key technologies to provide resilient, scalable, and performant data storage and retrieval. With a firm foundation in database reliability engineering, you’ll be ready to dive into the architecture and operations of any modern database. This book covers: Service-level requirements and risk management Building and evolving an architecture for operational visibility Infrastructure engineering and infrastructure management How to facilitate the release management process Data storage, indexing, and replication Identifying datastore characteristics and best use cases Datastore architectural components and data-driven architectures

Download or read book Beginning Oracle Database 12c Administration written by Ignatius Fernandez and published by Apress. This book was released on 2015-07-20 with total page 370 pages. Available in PDF, EPUB and Kindle. Book excerpt: Beginning Oracle Database 12c Administration is your entry point into a successful and satisfying career as an Oracle Database Administrator. The chapters of this book are logically organized into four parts closely tracking the way your database administration career will naturally evolve. Part 1 "Database Concepts" gives necessary background in relational database theory and Oracle Database concepts, Part 2 "Database Implementation" teaches how to implement an Oracle database correctly, Part 3 "Database Support" exposes you to the daily routine of a database administrator, and Part 4 "Database Tuning" introduces the fine art of performance tuning. Beginning Oracle Database 12c Administration provides information that you won't find in other books on Oracle Database. You'll discover not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." (It is the editor’s favorite chapter too!) If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. You will grasp the key aspects of theory behind relational database management systems and learn how to: • Install and configure an Oracle database, and ensure that it’s properly licensed; • Execute common management tasks in a Linux environment; • Defend against data loss by implementing sound backup and recovery practices; and • Improve database and query performance.

Download or read book Wiley Pathways Introduction to Database Management written by Mark L. Gillenson and published by John Wiley & Sons. This book was released on 2007-03-16 with total page 1011 pages. Available in PDF, EPUB and Kindle. Book excerpt: You can get there Where do you want to go? You might already be working in the information technology field and may be looking to expand your skills. You might be setting out on a new career path. Or, you might want to learn more about exciting opportunities in database management. Wherever you want to go, Introduction to Databases will help you get there. Easy-to-read, practical, and up-to-date, this text not only helps you learn fundamental database design and management concepts, it also helps you master the core competencies and skills you need to succeed in the classroom and in the real world. The book's brief, modular format and variety of built-in learning resources enable you to learn at your own pace and focus your studies. With this book, you will be able to: * Appreciate the key role of data in daily business operations and strategic decisions. * Understand databases, database management systems, and SQL, the software on which they are based, from the ground up. * Know how to gather and organize critical business information, design a database based on this information, and retrieve and modify that information in a useful manner. * Use accepted data modeling procedures to design a relational database. * Master the concept of data normalization and the use of standard normalization rules. * Explore critical real-world issues including application integration and securing data against disclosure and loss. Wiley Pathways helps you achieve your goals Not every student is on the same path, but every student wants to succeed. The Information Technology series in the new Wiley Pathways imprint helps you achieve your goals. The books in this series--Introduction to Databases, Introduction to Programming Using Visual Basic, Introduction to Operating Systems, Networking Basics, Windows Network Administration, Network Security Fundamentals, and PC Hardware Essentials--offer a coordinated information technology curriculum. Learn more at www.wiley.com/go/pathways

Download or read book Oracle 10g Database Administrator written by Gavin Powell and published by . This book was released on 2006-05 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: CD-ROM contains: Coverage of Oracle database, good preparation for the Oracle certification exam.

Download or read book Pro Oracle Database 18c Administration written by Michelle Malcher and published by Apress. This book was released on 2019-03-29 with total page 1009 pages. Available in PDF, EPUB and Kindle. Book excerpt: Database administration isn’t about passing a certified exam, or about pointing and clicking your way through a crisis. Database administration is about applying the right solution at the right time, avoiding risk, and making robust choices that get you home each night in time for dinner with your family. This book will help elevate you to the level of Professional Oracle Database Administrator. This book provides information and techniques for keeping an Oracle database stable and running on-premise, and is fully updated to cover Oracle Database 18c. New in this edition is coverage of cloud administration in the Oracle Public Cloud, automation of tasks using the autonomous database features, and data movement with multi-tenant databases. The book covers everything from architecture of the database engine, securing objects and users, strategies for performing maintenance tasks and resolving performance problems, through to backup and recovery. Pro Oracle Database 18c Administration takes a modern approach to database administration. Emphasis is given to automation, which is of growing importance as more databases are being moved into various cloud solutions and database administrators are being required to manage more instances than ever. Focus is given to multi-tenant container architecture and pluggable databases, and the book takes a refreshing, results-oriented approach that helps you get the job done. What You'll LearnUnderstand the differences between managing on-premise and cloud deployments Take advantage of new features in 18c while also managing older releases Manage more databases than ever by automating your environment Apply the latest techniques around pluggable databases and containerization Safeguard your data through good security and backup/recovery practices Troubleshoot common problems Who This Book Is For Database architects and administrators who want to level-up to the latest techniques around containerization, automation, and cloud deployment. The book also is appropriate for Oracle professionals desiring to present themselves as being competitive and up-to-date with the latest in the field.