Oracle 11g for Dummies 1st Edition by Chris Zeis ,Chris Ruel ,Michael Wessler ISBN 0470277653 978-0470277652

Oracle 11g for Dummies 1st Edition by Chris Zeis ,Chris Ruel ,Michael Wessler – Ebook PDF Instant Download/Delivery:0470277653 ,978-0470277652
Full download Oracle 11g for Dummies 1st Edition after payment

Product details: 

ISBN 10:0470277653 

ISBN 13:978-0470277652

Author:Chris Zeis ,Chris Ruel ,Michael Wessler

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle.

This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers:

• The building blocks behind the database engine as well as Oracle’s physical and logical structures
• Hardware, software, system, and storage requirements for implementation
• How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX
• Daily and intermittent tasks necessary to keep your database running properly
• How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures
• When to use online, offline, controlfile, and archivelog backups
• Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities
• Different ways to manage your database
• How to automate jobs with the Oracle Scheduler
• Using SQL in Oracle, and a great deal more

Completely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

Table of contents: 

Part I: You Don’t Have to Go to Delphi to Know Oracle
Chapter 1: A Pragmatic Introduction to Oracle
Introducing a New Kind of Database Management
Pooling Resources with Grid Computing
Anticipating Technology and Development Trends
Meeting Oracle in the Real World
Making the Oracle Decision

Chapter 2: Understanding Oracle Database Architecture
Defining Databases and Instances
Deconstructing the Oracle Architecture
Walking Down Oracle Memory Structures
Trotting around the System Global Area
Program Global Area
Managing Memory
Following the Oracle Processes
Getting into Physical Structures
Getting Physical with Files
Applying Some Logical Structures

Chapter 3: Preparing to Implement Oracle in the Real World
Understanding Oracle Database Deployment Methodology
Checking on the Requirements

Part II: Implementing Oracle on Your Own
Chapter 4: Creating an Oracle Database
Feeling at Home in Your Environment
Sticking with the Oracle Universal Installer and oraenv
Configuring an Instance
Creating Your Oracle Database
Bossing the Database Configuration Assistant (DBCA)
Feeling the Post-Configuration Glow

Chapter 5: Connecting to and Using an Oracle Database
Starting and Stopping the Database
Connecting to the Database Instance
Sidestepping Connection Gotchas

Chapter 6: Speaking the SQL Language
Using SQL in Oracle
Sharpening the SQLPlus Tool
Using SQL Connection Commands
SQLPlus Profile Scripts glogin.sql and login.sql
Getting Help from SQL*Plus
Getting a PL/SQL Overview

Chapter 7: Populating the Database
Creating Tablespaces
Creating Users and Schemas
Creating Database Objects

Part III: Caring for an Oracle Database
Chapter 8: Protecting Your Oracle Database
Assessing Database Threats
Getting Your Oracle Recovery Manager
Putting It in the Archives
Backup File Types with RMAN
Maintaining the Archives
Viewing Backup Information
Recovering Your Oracle Database

Chapter 9: Protecting Your Oracle Data
Authentication
Granting the Privileged Few
Role Playing
Virtual Private Database Concept
Auditing Oracle’s Big Brother
Encrypting a Database

Chapter 10: Keeping the Database Running
Doing Your Chores
Automating Jobs with the Oracle Scheduler
Using Oracle Data Pump
Creating Oracle Directories
Using Data Pump with a Parameter File

Chapter 11: Tuning an Oracle Database
Evaluating Tuning Problems
Tuning Your Database
Gathering Performance Information with Automatic Workload Repository
Using the Automatic Database Diagnostic Monitor (ADDM)
Improving Queries with SQL Tuning

Chapter 12: Troubleshooting an Oracle Database
Troubleshooting with System Methodology
Troubleshooting Using Oracle Database Logs
Benefiting from Other Diagnostic Utilities

Chapter 13: Monitoring and Managing with Enterprise Manager

People also search for:

oracle pl sql for dummies by michael rosenblum

oracle for dummies tutorial

is oracle database 11g still supported

what is oracle 11g client

is oracle 19c faster than 11g

Tags: Chris Zeis, Chris Ruel, Michael Wessler, Oracle, 11g