Oracle Database 12c Install, Configure & Maintain Like a Professional
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.
|Download Ebook||Read Now||File Type||Upload Date|
|Epub||August 10, 2018|
Do you like this book? Please share with your friends, let's read it !! :)How to Read and Open File Type for PC ?