Oracle Database 12c Install, Configure & Maintain Like a Professional

Oracle Database 12c Install, Configure & Maintain Like a Professional
  • Author: Ian Abramson and Michael Abbey
    Publisher: McGraw-Hill Education
    Genres: Computer Science
    Publish Date: September 25, 2013
    ISBN-10: 0071799338
    Pages: 472
    File Type: Epub
    Language: English


Book Preface

This book provides the reader with an introduction to Oracle Database 12c and some of the state-of-the-art offerings of Oracle. It has been a long journey for technicians who have focused their careers on Oracle’s technology all the way back to the late 1970s. Many skills acquired along the way are portable, and are upwardly compatible to the latest release. This is true for Database 12c. A large portion of what some readers may already know is applicable to this new release. What this book will do for the reader is

Provide a foundation for people just getting started with the software

Enhance existing skill sets with an idea of what is new with this latest release

Pinpoint the highlights of what is important to get to know in the database, development, and engineered machine areas of 12c

Introduce SQL*Plus and PL/SQL, the original and omni-powerful query languages with which one creates and manipulates data in the data repository

What’s in This Book

The following chapter-by-chapter outline will guide you through the plethora of information presented in Oracle Database 12c: Install, Configure & Maintain Like a Professional.

Chapter 1: The Database: The Foundations of 12c

You are introduced to the volume of information and how it can be stored in the database. The chapter gives a brief introduction to data types and highlights concepts related to managing that data. It closes with an overview of some of the most important new features of the 12c offering.

Chapter 2: Installing Oracle

We show how the database software is installed and guide the reader through the network of screens and suggested answers to the many questions posed by the GUI installer. Many different types of configurations are available for the database, and this chapter follows one of the most common.

Chapter 3: SQL: Accessing and Retrieving Data

SQL*Plus is the heart of this chapter, which introduces fundamentals and covers syntax that will allow you to get started writing queries. We cover a number of ways to work with the data and familiarize the reader with how to go about creating, manipulating, and deleting data.

Chapter 4: Programming in the Database

Here we cover Oracle’s procedural programming language called PL/SQL. Once you start programming with SQL*Plus, a more procedural approach is required to be able to process data sets in a sequential manner, similar to how aging developers may have used third-generation languages in the ’80s and ’90s.

Chapter 5: The Database Administrator

The database administrator plays the role of the technical gatekeeper of the database. The DBA manages the day-to-day operations of the database and serves the technology and end-user requirements to carry on a company’s business. We cover some of the most common ongoing activities played by this all-important person, thereby giving the reader a taste of this role from the start.

Chapter 6: Backup and Recovery

We delve into the ever-popular and strong Recovery Manager (RMAN) tool and highlight its strengths and syntax. We include discussions on the types of backups you can write using RMAN and delve into the important topics of restore and recovery.

Chapter 7: High Availability: RAC, ASM, and Data Guard

This chapter is dedicated to the functionality embedded in Oracle Database 12c that keeps your applications running 24/7. One of the earliest questions new DBAs and managers ask is how one ensures that the database is always available. This chapter introduces the reader to a handful of the most important ways to bring that desire to fruition.

Chapter 8: Using and Managing Large Databases

One cannot listen to any form of media on the Internet or traditional airwaves without hearing about the ever-expanding size of data stores and the need to store larger and large volumes of data. Many new buzzwords have surfaced over the past few years, of which “big data” may be the most commonly heard. With the need to store and retrieve more and more unstructured data, the size of many databases has become overwhelming. This chapter dives into some of what Oracle has put together to manage this explosion of data.

Chapter 9: Oracle’s Engineered Systems: From the Database Appliance to Exadata

Given the complexities of managing hardware and software, many corporations have thirsted for off-the-shelf solutions that can deliver an out-of-the-box solution for their business requirements. In this chapter, we discuss the heart of the solutions offered by Oracle in this very competitive arena.

  • File Type: Epub
  • Upload Date: August 10, 2018

Do you like this book? Please share with your friends!

How to Read and Open File Type for PC ?


You may also be interested in the following ebook:

Invitation to Computer Science 7th Edition Invitation to Computer Science 7th Edition
  • G.Michael Schneider and Judith Gersting
Applied Scientific Computing: With Python Applied Scientific Computing: With Python
  • Peter R. Turner and Thomas Arildsen
Mastering Windows Server 2016 Mastering Windows Server 2016
  • Brian Svidergol and Vladimir Meloski