Practical Guide to Using SQL in Oracle
- 4h 42m
- Richard Walsh Earp, Sikha Saha Bagui
- Jones and Bartlett Learning
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
Query Development, Privileges, and Derived Structures
Subqueries versus Joins
GROUP BY and HAVING
CREATE TABLE and SQLLOADER
Multiple Commands, START Files, and Reports in SQLPLUS
Beginning PL/SQL—Anonymous Blocks, Procedures, Functions, and Packages
Introduction to Triggers
SQL and XML