Database Administration

Database Administration
Author: Craig Mullins
Publisher: Addison-Wesley Professional
Total Pages: 736
Release: 2002
Genre: Computers
ISBN: 9780201741292

Download Database Administration Book in PDF, Epub and Kindle

Giving comprehensive, soup-to-nuts coverage of database administration, this guide is written from a platform-independent viewpoint, emphasizing best practices.

Oracle Database Administration for Microsoft SQL Server DBAs

Oracle Database Administration for Microsoft SQL Server DBAs
Author: Michelle Malcher
Publisher: McGraw Hill Professional
Total Pages: 353
Release: 2010-10-06
Genre: Computers
ISBN: 0071744304

Download Oracle Database Administration for Microsoft SQL Server DBAs Book in PDF, Epub and Kindle

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

Oracle 10g Database Administrator

Oracle 10g Database Administrator
Author: Gavin Powell
Publisher:
Total Pages: 0
Release: 2006-05
Genre: Database management
ISBN: 9781418836658

Download Oracle 10g Database Administrator Book in PDF, Epub and Kindle

CD-ROM contains: Coverage of Oracle database, good preparation for the Oracle certification exam.

Oracle Database Administration: The Essential Refe

Oracle Database Administration: The Essential Refe
Author: David Kreines
Publisher: O'Reilly Media, Incorporated
Total Pages: 586
Release: 1999-04-14
Genre: Computers
ISBN: 9781565925168

Download Oracle Database Administration: The Essential Refe Book in PDF, Epub and Kindle

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 Oracle Database 11g Administration

Expert Oracle Database 11g Administration
Author: Sam Alapati
Publisher: Apress
Total Pages: 1376
Release: 2009-01-10
Genre: Computers
ISBN: 1430210168

Download Expert Oracle Database 11g Administration Book in PDF, Epub and Kindle

Sam Alapati's Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the 11g release of the Oracle Database. All key aspects of database administration are covered, including backup and recovery, day–to–day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done. Comprehensive handbook for Oracle Database administrators. Covers all major aspects of database administration. Tests and explains in detail key DBA commands. Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.

Database Administration

Database Administration
Author: Belkis Leong-Hong
Publisher:
Total Pages: 56
Release: 1978
Genre: Data base management
ISBN:

Download Database Administration Book in PDF, Epub and Kindle

Database Administration

Database Administration
Author: Craig S. Mullins
Publisher: Addison-Wesley
Total Pages: 1082
Release: 2012-10-11
Genre: Business & Economics
ISBN: 0133012727

Download Database Administration Book in PDF, Epub and Kindle

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.

Expert Oracle9i Database Administration

Expert Oracle9i Database Administration
Author: Sam Alapati
Publisher: Apress
Total Pages: 1228
Release: 2008-01-01
Genre: Computers
ISBN: 1430207736

Download Expert Oracle9i Database Administration Book in PDF, Epub and Kindle

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.

Understanding Database Administration

Understanding Database Administration
Author: Pablo Berzukov
Publisher: Createspace Independent Publishing Platform
Total Pages: 0
Release: 2010-01-12
Genre: Database management
ISBN: 9781450500913

Download Understanding Database Administration Book in PDF, Epub and Kindle

In the Information Technologies industry there are few domains less understood than Database Administration. People keep asking what the responsibilities of a Database Administrator are, what 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 or 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. The final intention is to help you understand the world of Database Administration without resorting to technicalities and independently of the technology of choice and, without a single SQL command. Enjoy it.

Professional Azure SQL Database Administration

Professional Azure SQL Database Administration
Author: Ahmad Osama
Publisher: Packt Publishing Ltd
Total Pages: 562
Release: 2019-07-19
Genre: Computers
ISBN: 1789804183

Download Professional Azure SQL Database Administration Book in PDF, Epub and Kindle

Leverage the features of Azure SQL database and become an expert in data management Key FeaturesExplore ways to create shards and elastic pools to scale Azure SQL databasesAutomate common management tasks with PowerShellImplement over 40 practical activities and exercises to reinforce your learningBook Description Despite being the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. This book shows you how to administer Azure SQL database to fully benefit from its wide range of features and functionality. Professional Azure SQL Database Administration begins by covering the architecture and explaining the difference between Azure SQL Database and the on-premise SQL Server to help you get comfortable with Azure SQL database. You’ll perform common tasks such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you’ll study how you can save costs and manage and scale multiple SQL Databases using elastic pools. You’ll also implement a disaster recovery solution using standard and active geo-replication. Whether it is learning different techniques to monitor and tune an Azure SQL database or improving performance using in-memory technology, this book will enable you to make the most out of Azure SQL database features and functionality for data management solutions. By the end of this book, you’ll be well versed with key aspects of an Azure SQL database instance, such as migration, backup restorations, performance optimization, high availability, and disaster recovery. What you will learnUnderstand Azure SQL Database configuration and pricing optionsProvision a new SQL database or migrate an existing on-premise SQL Server database to Azure SQL DatabaseBack up and restore Azure SQL DatabaseSecure an Azure SQL databaseScale an Azure SQL databaseMonitor and tune an Azure SQL databaseImplement high availability and disaster recovery with Azure SQL DatabaseAutomate common management tasks with PowerShellDevelop a scalable cloud solution with Azure SQL DatabaseManage, maintain, and secure managed instancesWho this book is for If you’re a database administrator, database developer, or an application developer interested in developing new applications or migrating existing ones with Azure SQL database, this book is for you. Prior experience of working with an on-premise SQL Server or Azure SQL database along with a basic understanding of PowerShell scripts and C# code is necessary to grasp the concepts covered in this book.