Publisher Description

This book teaches you all of the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of programming Oracle. This book is aimed at would-be Oracle developers and administrators alike. No matter what your background might be, this book takes a simple approach to teaching you Oracle technology. By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence. Oracle is the world's leading relational database. It provides a rich environment to store, handle, and extract data and, when used properly, is the fastest and most scaleable database on which to build enterprise scale applications. However, with power comes complexity and mastering the Oracle database is not an overnight job. It takes time, practice, and a lot of real world experience. The authors of this book have that experience. They understand the challenges that are going to be met when developing an application or administering the database and can guarantee you that the techniques taught in this book are proven and have led them through many successful implementations.

Table of Contents

Getting To Know Oracle.- SQL*Plus and Basic Querying.- Creating and Managing Users and Tables.- The New 9i Sample Schemas.- Architecture.- Processing Statements in Oracle.- Tables.- Indexes.- Mastering SQL*Plus.- PL/SQL.- Procedures, Functions, and Packages.- Transactions and Concurrency.- Security.- Views.- Triggers.- Objects.- Advanced Querying.- Tuning Tools.- A SQL Toolkit.- Case Study 1 — Debugging PL/SQL.- Case Study 2 — Finding People.

Promotional

Springer Book Archives

Long Description

Why Read This Book? When you opened the cover of this book, you had a notion of what you would find. With a title like Beginning Oracle Programming, it's fairly obvious what this book is all about. Simply put, the purpose of this book is to teach you how to manage data using an Oracle database. The goal of Beginning Oracle Programming is to introduce you to those concepts that are important to understand as a beginning-level Oracle user. You are setting out on the same journey we traveled some years ago. We know the things you are going to run into time and time again. We understand the challenges you are going to meet when you have to develop an application or administer your database. We can guarantee you that the techniques you'll learn in this book are proven and have led us through many successful implementations. So instead of talking about the things we want to teach you in an abstract kind of way, let's talk specifics.

Feature

A detailed tutorial that takes you from no knowledge of Oracle programming to mastery, teaching you how to write correct, production quality code right from the start A clear, step-by-step guide to every aspect of programming the Oracle database, with practical programming techniques and troubleshooting advice from Oracle experts Provides an extensive SQL toolkit to tackle common day-to-day database tasks

Description for Sales People

This book teaches you all of the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of programming Oracle. This book is aimed at would-be Oracle developers and administrators alike. No matter what your background might be, this book takes a simple approach to teaching you Oracle technology. By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence.

Details