Practical Guide to Using SQL in Oracle

  • 4h 42m
  • Richard Walsh Earp, Sikha Saha Bagui
  • Jones and Bartlett Learning
  • 2008

Structured Query Language has become the standard for generating, manipulating, and retrieving database information. The dramatic increase in the popularity of relational databases, coupled with Oracle’s having the largest market share, has created a demand for programmers who can write SQL code correctly and efficiently.

This book provides a systematic approach to learning SQL in Oracle. Each chapter is written in a step-by-step manner and includes examples that can be run using Oracle. Using the sample tables and data provided, readers will be able to perform the examples to gain hands-on experience with Oracle programming. Specifically, this book will help you:

  • Gain an understanding of basic SQL principles.
  • Learn to generate, store, and edit SQL queries in Oracle.
  • Develop joins, subqueries, and correlated subqueries.
  • Work with XML and Oracle databases.
  • Test your SQL knowledge with the exercises at the end of each chapter.

About the Authors

Dr. Richard Walsh Earp is a former chair of and former associate professor in the Department of Computer Science and former dean of the College of Science and Technology at the University of West Florida in Pensacola. Dr. Earp was also an instructor with Learning Tree International and worked for Computer Sciences Corporation at the Naval Air Station in Pensacola as a database consultant after his retirement from academia. He has co-authored several books with Dr. Bagui.

Dr. Sikha Saha Bagui is an associate professor in the Department of Computer Science at the University of West Florida. She teaches a variety of computer science and database courses, and her research areas of concentration are database design, web databases, data mining, and statistical computing. Dr. Bagui has published many journal articles and co-authored several books with Dr. Earp including Advanced SQL Functions in Oracle 10g.

In this Book

  • Getting Started with Oracle
  • More “Beginning” SQL Commands
  • Joins
  • Functions
  • Query Development, Privileges, and Derived Structures
  • Set Operations
  • Subqueries versus Joins
  • Correlated Subqueries
  • Multiple Commands, START Files, and Reports in SQLPLUS
  • Beginning PL/SQL—Anonymous Blocks, Procedures, Functions, and Packages
  • Introduction to Triggers
  • SQL and XML