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: 8588

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: 2753

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.

Understanding Database Administration

Author: Pablo Berzukov

Publisher: CreateSpace

ISBN: 9781450500913

Category: Computers

Page: 138

View: 7236

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.

Expert Oracle9i Database Administration

Author: Sam Alapati

Publisher: Apress

ISBN: 1430207736

Category: Computers

Page: 1248

View: 6707

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.

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: 9989

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

Oracle Database Administration for Microsoft SQL Server DBAs

Author: Michelle Malcher

Publisher: McGraw Hill Professional

ISBN: 0071744304

Category: Computers

Page: 352

View: 9424

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

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: 5633

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.

Oracle 10g Database Administrator II

Backup/recovery & Network Administration

Author: Claire Rajan

Publisher: Cengage Learning

ISBN: 1418836648

Category: Computers

Page: 627

View: 8641

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.

Database administration

concepts, tools, experiences, and problems

Author: Belkis Leong-Hong,Beatrice Marron

Publisher: N.A

ISBN: N.A

Category: Computers

Page: 41

View: 2642

Oracle 8 DBA

Database Administration Exam Cram

Author: Paul Collins

Publisher: Coriolis Group

ISBN: 9781576106037

Category: Computers

Page: 404

View: 9383

The Oracle8 DBA: Database Administration Exam Cram contains information previously available only in training materials from Oracle, including key terms and definitions. The book covers all technologies covered on the Oracle8 DBA Database Administration test, and provides practice questions with detailed explanations of why the right answer is correct and the wrong answers are wrong. The Oracle8 DBA: Database Administration Exam Cram outlines the Oracle8 DBA Database Administration exam objectives in a condensed format 100% focused on passing the exam.

Database Management Concepts

Author: Joseph J. Adamski,Philip J. Pratt

Publisher: Cengage Learning

ISBN: 1133191312

Category: Database management

Page: 432

View: 8599

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.

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: 580

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.

Concepts of Database Management

Author: Philip J. Pratt,Mary Z. Last

Publisher: Cengage Learning

ISBN: 1285427106

Category: Computers

Page: 432

View: 6871

Delivering concise, cutting-edge coverage, CONCEPTS OF DATABASE MANAGEMENT, 8e uses real-world cases, examples, and illustrations to give readers a thorough understanding of such critical issues as database design, data integrity, concurrent updates, data security, and more. Completely updated to Microsoft Access 2013 standards, the text presents SQL in a database-neutral environment and covers all major topics, including E-R diagrams, normalization, and database design. It provides detailed coverage of the relational model (including QBE and SQL), normalization and views, database administration and management, and more. Advanced topics 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.

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: 4186

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).

Basic Database Administration

การบริหารฐานข้อมูลเบื้องต้น

Author: Somrawee Aramkul,สมรวี อร่ามกุล

Publisher: PSIbook

ISBN: N.A

Category:

Page: 159

View: 9038

หนังสือการบริหารฐานข้อมูลเบื้องต้นนี้ประกอบด้วย เนื้อหา 9 บท คือ ความรูเบื้องตนเกี่ยวกับการบริหารฐานขอมูล การจัดเตรียมสภาพแวดลอมสําหรับฐานขอมูล แบบจําลองขอมูลและนอรมัลไลเซชัน การออกแบบฐานขอมูล การออกแบบแอปพลิเคชัน การจัดการความเปลี่ยนแปลงฐานขอมูล ความพรอมใชของขอมูล การรักษาความมั่นคงของฐานขอมูล และการสํารองและการกูคืนฐานขอมูล

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: 9985

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.

Oracle8 Database Administration on Windows NT

Author: Lynnwood Brown

Publisher: Prentice Hall Ptr

ISBN: 9780139274435

Category: Computers

Page: 267

View: 3164

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).

Database management

Author: Fred R. McFadden

Publisher: Benjamin-Cummings Publishing Company

ISBN: N.A

Category: Computers

Page: 723

View: 9345

Oracle 10g: Database Administration Concepts & Implementation Made Simple

Author: Asim Abbasi

Publisher: Lulu Press, Inc

ISBN: 1257256386

Category: Computers

Page: N.A

View: 4725

The Topics Covered In This Book Are: Visualizing the Complete Oracle Environment, SQL: Structured Query Language, Oracle Database Concepts, Oracle Instance Concepts, Oracle in Action, Complete Oracle System Design: Steps of Implementation, Oracle Database Design, Oracle Network Administration, Oracle Database Management, Oracle Backup & Recovery Techniques, Oracle Performance Tuning Everything in this book is covered in a step by step manner by first building reader's concept using analogies, real world examples and then taking him/her to the steps of design implementation. The book covers Oracle 10g Database Administration for both Unix as well as Windows OS. The concepts and most of the stuff discussed in this book are equally good for other Oracle versions including 11g.

Beginning Oracle Database 12c Administration

From Novice to Professional

Author: Ignatius Fernandez

Publisher: Apress

ISBN: 1484201930

Category: Computers

Page: 384

View: 4381

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.