Beginning Oracle Programming

This book is for you if you: Want to be either an Oracle administrator or developer; Need a tutorial that takes you from no knowledge to mastery of the Oracle database; Understand the underlying concepts behind relational databases; Have experience of basic SQL. What you will learn from this book: By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence. We will cover: Core Oracle terminology, tools, concepts, and architecture; The functionality of the different versions and editions of Oracle (8, 8i, and 9i); Basic and advanced Oracle SQL; Mastering SQL*Plus as an Oracle development tool; Understanding tables, indexes, transactions and concurrency, views, triggers, and objects; Using PL/SQL to write and package procedural code in the database; Securing your Oracle applications; Evaluating performance and tuning your Oracle application; A SQL Toolkit of useful scripts that you can use in your database; Case studies that apply this knowledge to create two practical Oracle applications