Real World SQL and PL/SQL: Advice from the Experts

Contents

Foreword

Preface

Acknowledgments

Introduction

PART IThe Importance of SQL, PL/SQL, and a Good Data Model

1   SQL and PL/SQL

Introduction to SQL and PL/SQL

SQL

PL/SQL

Summary

2   Expert Data Modeling and Implementing Business Logic

Implementing Business Logic

Business Logic in Database Objects

Business Logic in the Code

Designing a Database and Data Models

The Design Process

Introduction to Oracle SQL Developer Data Modeler

Summary

PART IIUnderutilized Advanced SQL Functionality

3   Handling Advanced and Complex Data Sets

Some Tools for Designing the Database

Introduction to Tables

Table Cluster

Views and Materialized Views

Introduction ...