Oracle Database Administration for Microsoft SQL Server DBAs

by Malcher, Michelle

• ISBN13: 9780071744317
• ISBN10: 0071744312
• Edition: 1st
• Format: Paperback
• Copyright: 2010-09-22
• Publisher: McGraw-Hill Education

Summary

Written by an Oracle ACE, this Oracle Press guide helps experienced Microsoft SQL Server database administrators (DBAs) work seamlessly with the Oracle Database in a mixed-database environment.Oracle Database Administration for Microsoft SQL Server DBAstakes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments.This is not designed to be an "Oracle is better than SQL Server" book or vice versa. With step-by-step examples throughout as well as code listings, this unique resource takes a practical, day-to-day approach to job functionality as opposed to attempting a feature-by-feature comparison of Oracle versus SQL Server.Oracle Database Administration for Microsoft SQL Server DBAs Includes realistic, step-by-step procedures for tasks such as database installation plus practical code examples to back up content Explains how to perform everyday administration tasks on the Oracle Database Shows how to optimize existing SQL Server skills in the Oracle environment, and teaches the most compelling features unique to Oracle Includes coverage of working with different operating systemsFull coverage of Oracle DBA skills The Database Administrator; Oracle Internals; Installations; Servers, Databases, Instances or Schemas; DBA Tools; Backup Database; Database Maintenance; Performance and Tuning; PL/SQL; High Availability Architecture

Author Biography

Michelle Malcher, Oracle ACE, is a senior database administrator with more than 11 years’ experience in database development, design, and administration. She is a contributing author to Oracle Database 11g: A Beginner’s Guide and to the IOUG Best Practices Tip Booklet. Michelle is on the Board of the Independent Oracle User Group (IOUG).

Table of Contents

Chapter 1: The Database Administrator; Chapter 2: Oracle Internals; Chapter 3: Oracle Installation; Chapter 4: Database Definitions and Setup; Chapter 5: DBA Tools; Chapter 6: Database Backup, Restore, and Recovery; Chapter 7: Database Maintenance; Chapter 8: Performance and Tuning; Chapter 9: PL/SQL; Chapter 10: High-Availability Architecture; Appendix; Index