Database Administration

The Complete Guide to Practices and Procedures

Author: Craig Mullins

Publisher: Addison-Wesley Professional

ISBN: 9780201741292

Category: Computers

Page: 703

View: 3330

A thorough reference on database administration outlines a variety of DBA roles and responsibilities and discusses such topics as data modeling and normalization, database/application design, change management, database security and data integrity, performance issues, disaster planning, and other essentials. Original. (Advanced)

Database Administration

The Complete Guide to DBA Practices and Procedures

Author: Craig S. Mullins

Publisher: Addison-Wesley

ISBN: 0133012727

Category: Business & Economics

Page: 928

View: 8343

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 platform or environment, this text fully reflects the field’s latest realities and challenges. Drawing on more than thirty years of database experience, Mullins focuses on problems that today’s DBAs actually face, and skills and knowledge they simply must have. Mullins presents realistic, thorough, and up-to-date coverage of every DBA task, including creating database environments, data modeling, normalization, design, performance, data integrity, compliance, governance, security, backup/recovery, disaster planning, data and storage management, data movement/distribution, data warehousing, connectivity, metadata, tools, and more. This edition adds new coverage of “Big Data,” database appliances, cloud computing, and NoSQL. Mullins includes an entirely new chapter on the DBA’s role in regulatory compliance, with substantial new material on data breaches, auditing, encryption, retention, and metadata management. You’ll also find an all-new glossary, plus up-to-the-minute DBA rules of thumb.

Oracle Database Administration: The Essential Refe

Author: David Kreines,Brian Laskey

Publisher: O'Reilly Media, Incorporated

ISBN: 9781565925168

Category: Computers

Page: 580

View: 6436

Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis. This book provides a concise reference to the enormous store of information an Oracle DBA needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert DBAs will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions. Oracle Database Administration provides two types of material: DBA tasks--chapters summarizing how to perform critical DBA functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities DBA reference--chapters providing a quick reference to the Oracle instance and database, the initialization (INIT.ORA) parameters, the SQL statements commonly used by DBAs, the data dictionary tables, the system privileges and roles, and the SQL*Plus, Export, Import, and SQL*Loader syntax The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle DBAs. Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book.

Expert Oracle9i Database Administration

Author: Sam Alapati

Publisher: Apress

ISBN: 1430207736

Category: Computers

Page: 1248

View: 4774

This 1,000-page book enables a beginner or intermediate level Oracle DBA or Oracle Developer/Manager to master the art of building and managing complex Oracle 9i databases.

Database administration

concepts, tools, experiences, and problems

Author: Belkis Leong-Hong,Beatrice Marron

Publisher: N.A

ISBN: N.A

Category: Computers

Page: 41

View: 9068

Oracle 10g Database Administrator II

Backup/recovery & Network Administration

Author: Claire Rajan

Publisher: Cengage Learning

ISBN: 1418836648

Category: Computers

Page: 627

View: 7995

Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. This text drills down key tools and techniques for Oracle database backup, recovery and network administration and provides good preparation for the update Oracle certification exam, Database Fundamentals I (#1Z0-043). In addition to extensive review material, the end of chapter content also includes comprehensive coverage of the exam objectives and exam-like practice questions. This text is the perfect compliment to the Oracle 10g: Database Administrator: Implementation and Administration (DBA1) text and the 1Z0-042.

Oca Oracle Database 11g Database Administration I

A Real-World Certification Guide

Author: Steve Ries

Publisher: Packt Publishing Ltd

ISBN: 1849687315

Category: Computers

Page: 582

View: 4714

Developed as a practical book, "Oracle Database 11g Administration I Certification Guide" will show you all you need to know to effectively excel at being an Oracle DBA, for both examinations and the real world. This book is for anyone who needs the essential skills to become an Oracle DBA, pass the Oracle Database Administration I exam, and use those skills in the real world to manage secure, high performance, and highly available Oracle databases.

DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide

Author: George Baklarz,Bill Wong

Publisher: Prentice Hall Professional

ISBN: 9780130463616

Category: Computers

Page: 883

View: 1309

DB2 Universal Database v8 builds on the world's #1 enterprise database to simplify anytime/anywhere information integration, streamline management, automate resource tuning, enhance business intelligence, and maximize performance, scalability, and reliability. Now, IBM offers complete, start-to-finish coverage of DB2 Universal Database v8 administration and development for UNIX, Linux, and Windows platforms... "and authoritative preparation for IBM's newest DB2 certification exam." This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database v8, including best practices for DB2 database design and development; day-to-day administration and backup; expert techniques for deploying networked, Internet-centered, and XML-based database applications; migrating to DB2 UDB v8; and much more.You'll also find an unparalleled collection of IBM tips and tricks for maximizing the performance, availability, and value of any database system. Coverage includes: Manageability and serviceability enhancements, including new tools for storagemanagement and monitoring database health Performance improvement withmultidimensional clustering, enhanced prefetching, threading of Java UDFs and storedprocedures, and materialized query tables New Setup wizards, configuration assistants, GUItools, and DB2 Administration Server (DAS) improvements Availability andscalability enhancements New DB2 v8 Replication and Data Warehouse Centers Major improvements for developers, including SQL, XML, JDBC, and CLIenhancements Whether you're a DBA, a developer, a DB2 certification candidate, or all three, "DB2Universal Database v8 for Linux, UNIX, and Windows Database AdministrationCertification Guide" is the one book you can't afford to be without. Straight from IBM, the ultimate guide to running DB2 v8 and preparing for IBM's latest DB2certification exam! In-depth coverage of DB2 v8 database administration and development Covers new DB2 v8 enhancements in manageability, serviceability, reliability, availability, and performance Contains in-depth coverage of new DB2 v8 tools, including the Replication, Data Warehouse, and Development Centers Presents expert tips and best practices from IBM's own DB2 customer support organization About the CDThe CD-ROM included with this book contains a complete trial version of DB2 UDB V8Personal Edition, plus the DB2DEMO program to help explore the many features of DB2.

Understanding Database Administration

Author: Pablo Berzukov

Publisher: CreateSpace

ISBN: 9781450500913

Category: Computers

Page: 138

View: 8065

In the Information Technologies industry there are few domains less understood than Database Administration. People keep asking what are the responsibilities of a Database Administrator, what are the specific tasks and processes Database Administrators rely on to fulfill those responsibilities and, by which rules Database Administrators abide to deal with whatever they do. Some people ask those questions out of simple curiosity, others because they are in or close to a DBA role, others because they have to deal with DBAs in a user, developer, management, etc. capacity and, want to have a better understanding of the DBA world. Everyone has its own reasons to ask questions about the database administration world; questions are always the same. This book intends to answer those questions. This is a technology agnostic book meaning that it applies to the field of database administration in general rather than focusing on any specific database vendor technology in particular. Enjoy it.

Oracle Database Administration for Microsoft SQL Server DBAs

Author: Michelle Malcher

Publisher: McGraw Hill Professional

ISBN: 0071744304

Category: Computers

Page: 352

View: 1440

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

Database Management Systems

A Business-Oriented Approach Using ORACLE, MySQL and MS Access

Author: Sotirios Zygiaris

Publisher: Emerald Group Publishing

ISBN: 178756696X

Category: Business & Economics

Page: 224

View: 7254

Zygiaris provides an accessible walkthrough of all technological advances of databases in the business environment. Readers learn how to design, develop, and use databases to provide business analytical reports with the three major database management systems: Microsoft Access, Oracle Express and MariaDB (formerly MySQL).

Professional Azure SQL Database Administration

Equip yourself with the skills you need to manage and maintain your SQL databases on the Microsoft cloud

Author: Ahmad Osama

Publisher: Packt Publishing Ltd

ISBN: 1789535670

Category: Computers

Page: 398

View: 3133

Discover how you can migrate a traditional on-premise SQL server database to a cloud-based solution with Microsoft Azure. Built with database administrators in mind, this book emulates different scenarios you might come across while working with large, complex SQL database migrations and provides solutions for effectively managing the migrated databases. Key Features Implement backup, restore, and recovery of Azure SQL databases Create shards and elastic pools to scale Azure SQL databases Automate common management tasks with PowerShell Implement over 40 practical activities and exercises across 24 topics to reinforce your learning Book Description As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It’s important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses important aspects of an Azure SQL Database instance such as migration, backup restorations, pricing policies, security, scalability, monitoring, performance optimization, high availability, and disaster recovery. It is a complete guide for database administrators, and ideal for those who are planning to migrate from on premise SQL Server database to an Azure SQL Server database. What you will learn Learn how to provision a new database or migrate an existing on-premise solution Understand how to backup, restore, secure, and scale your own Azure SQL Database Optimize the performance by monitoring and tuning your cloud-based SQL instance Implement high availability and disaster recovery procedures with SQL Database Develop a roadmap for your own scalable cloud solution with Azure SQL Database Who this book is for This book is ideal for database administrators, database developers, or application developers who are interested in developing or migrating existing applications with Azure SQL Database. Prior experience of working with an on-premise SQL Server deployment and brief knowledge of PowerShell and C# are recommended prerequisites.

Concepts of Database Management

Author: Philip J. Pratt,Joseph J. Adamski

Publisher: Cengage Learning

ISBN: 1133684378

Category: Computers

Page: 400

View: 586

CONCEPTS OF DATABASE MANAGEMENT fits perfectly into any introductory database course for information systems, business or CIS programs. This concise text teaches SQL in a database-neutral environment with all major topics being covered, including E-R diagrams, normalization, and database design. Now in its seventh edition, CONCEPTS OF DATABASE MANAGEMENT prepares students for success in their field using real-world cases addressing current issues such as database design, data integrity, concurrent updates, and data security. Special features include detailed coverage of the relational model (including QBE and SQL), normalization and views, database design, database administration and management, and more. Advanced topics covered include distributed databases, data warehouses, stored procedures, triggers, data macros, and Web databases. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Beginning Oracle Database 11g Administration

From Novice to Professional

Author: Iggy Fernandez

Publisher: Apress

ISBN: 1590599683

Category: Computers

Page: 464

View: 311

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity. The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter. In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." 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. What you’ll learn Theory of relational database management systems Oracle Database internals Licensing, architecture, and sizing Software installation and database creation Using indexes to improve performance User management and data loading How to monitor all aspects of your database How to solve and fix problems Database backups and database recovery Database maintenance Database tuning SQL tuning Who this book is for If you are an IT professional who has been thrust into an Oracle database administration role without the benefit of formal training, or you just want to understand how Oracle Database works, this book is for you. It's the book the author wishes he'd had when he first started using Oracle Database many years ago. It's the book that he would have liked to have given to the many IT colleagues and friends who, over the years, have asked him to teach them the basics of Oracle Database.

Expert Oracle Practices

Oracle Database Administration from the Oak Table

Author: Pete Finnigan,Alex Gorbachev,Tim Gorman,Charles Hooper,Jonathan Lewis,Niall Litchfield,Robyn Sands,Joze Senegacnik,Riyaj Shamsudeen,Jeremiah Wilton,Graham Wood,Connie Green,Karen Morton,Randolf Geist,Uri Shaft,Melanie Caffrey

Publisher: Apress

ISBN: 1430226684

Category: Computers

Page: 592

View: 2882

This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you. What you’ll learn Adopt a rational approach to database management; eliminate guesswork Add value to your organization as a database professional Manage and optimize performance Exploit different platform technologies Secure your organization's data Gain deep understanding of database internals and structures Who this book is for This book is aimed at Oracle database administrators who want to further their careers by implementing sound and proven database administration practices—and especially repeatable and predictable practices—in their daily work. Table of Contents Battle Against Any Guess A Partly Cloudy Future Developing a Performance Methodology The DBA as Designer Running Oracle on Windows Managing SQL Performance PL/SQL and the CBO Understanding Performance Optimization Methods Choosing a Performance Optimization Method Managing the Very Large Database Statistics Troubleshooting Latch Contention Measuring for Robust Performance User Security Securing Data

Oracle8 Database Administration on Windows NT

Author: Lynnwood Brown

Publisher: Prentice Hall Ptr

ISBN: 9780139274435

Category: Computers

Page: 267

View: 3096

Provides database administrators with step-by-step instructions for running Oracle 8 on Windows NT Server, covering installation, tuning, security, networking, application development with PL/SQL, and the latest Oracle enhancements of the Windows NT platform. Original. (Intermediate).

Concepts of Database Management

Author: Philip Pratt,Joseph Adamski

Publisher: Cengage Learning

ISBN: 1423901479

Category: Computers

Page: 386

View: 2834

This concise yet comprehensive introduction to fundamental database concepts is an indispensable resource to develop your knowledge of database management concepts. Now in its sixth edition, Concepts of Database Management maintains the focus on real-world cases that made previous editions so effective addressing the most current database issues faced today such as database design, data integrity, concurrent updates, and data security. Special features include detailed coverage of the relational model (including Query-By-Example (QBE) and SQL), normalization and views, database design, database administration and management, and more. This book's advanced topics include distributed databases, data warehouses, stored procedures, and triggers fostering an in-depth understanding of database management that will prepare users for success in their fields. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Database Management Concepts

Author: Joseph J. Adamski,Philip J. Pratt

Publisher: Cengage Learning

ISBN: 1133191312

Category: Database management

Page: 432

View: 7532

CONCEPTS OF DATABASE MANAGEMENT fits perfectly into any introductory database course for information systems, business or CIS programs. This concise text teaches SQL in a database-neutral environment with all major topics being covered, including E-R diagrams, normalization, and database design.DATABASE MANAGEMENT CONCEPTS, 7E, International Edition prepares students for success in their field using real-world cases addressing current issues such as database design, data integrity, concurrent updates, and data security. Special features include detailed coverage of the relational model (including QBE and SQL), normalization and views, database design, database administration and management, and more. Advanced topics covered include distributed databases, data warehouses, stored procedures, triggers, data macros, and Web databases.