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