A new edition of this title is now available, ISBN-10: 0137126026 ISBN-13: 9780137126026
1. Storing Information in Tables.
Introduction. The Parts of a Table. Examples of Tables. Summary.
The Select Statement. The Select Clause. The Where Clause. The Order By Clause. Summary. Exercises.
Compound Conditions in the Where Clause. Constant Values. Punctuation Matters. Some Exercises Solved for You. Summary. Exercises.
Saving Your Results in a New Table or View. Modifying the Data in a Table. Summary. Exercises.
Transactions. Modifying Data Through a View. Oracle SQLplus. Finding Information About Tables and Views. Summary. Exercises.
Creating Tables. Changing Tables. Tables with Duplicate Rows. Loading a Large Amount of Data from a Flat File. Summary. Exercises.
Formats. Sequences. Indexes. Finding More Information in the Data Dictionary. An Exercise Solved for You. Summary. Exercises.
Referential Integrity. The Delete Options and Update Options of RI. Variations of Referential Integrity. Other Types of Constraints. Summary. Exercises.
Introduction to Row Functions. Number Functions. Text Functions. Date Functions. Summary. Exercises.
Other Functions. Using the Documentation of Row Functions. Creating Patterns of Numbers and Dates. Summary. Exercises.
Introduction to the Column Functions. Maximum and Minimum. Count. Sum and Average. Other Topics. Summary. Exercises.
Dividing a Table into Groups of Rows and Summarizing Each Group. Eliminating Some of the Summarized Data. Restrictions on Summarization. Summary. Exercises.
Introduction to Joins. Inner Joins of Two Tables. Variations of the Join Condition. Applications of Joins. Summary. Exercises.
Introduction to Outer Joins. Applications of Outer Joins. Summary. Exercises.
Unions. Unconventional Unions. Applications of a Union. Set Intersection and Set Difference in Oracle. Summary. Exercises.
Cross Joins. Self Joins. Summary. Exercises.
Methods of Joining Three or More Tables. Losing Information. Caring About the Efficiency of Your Computer. Standardizing the Way That Tables Are Joined. Summary.
If-Then-Else Logic. Parameter Queries. Subqueries. Applications of Subqueries. Older Features of Subqueries. Summary.
Database Configurations. Operating in a Multiuser Environment. Security and Privileges. Several People Using the Same Table at the Same Time. Locks. The Data Dictionary and the Multiuser Environment. How to Create a Shared Application. Summary.
Original SQL Design Objectives. Newer Interfaces. Typical Application. Summary.
Getting Current Information. Which Product Should You Get? Downloading Oracle from the Internet. Ordering Oracle on a CD. Installing Oracle. Setting Up to Run the Examples in This Book. Setting Up a New Userid. Installing the Tables Used in This Book. How to Build the Tables and Assign Other Tablespace Names.
Starting Oracle. Entering a Query. Other Ways to Edit Your SQL Code. Error Messages Are Sometimes Correct. Using the Scrollbars. If Oracle Does Not Respond. Installing the LOGIN Script. Running All the SQL for a Chapter.
You Can Use Access 2000 or 2002. Starting Access. Entering an SQL Query. Dealing with Errors. Printing.
Join Conditions. Data Validation Rules.
SQL is now one of the most important computer languages. It is used in over 100 software products, and new ones are being added all the time. This book shows you how to get the most out of your database. It explains how to use SQL to solve practical problems, using the most widely used SQL products Oracle and Microsoft Access. Oracle and Access are both widely used, easily available and run on personal computers. By learning these two products in detail, you will have all the basic skills to use any of the many products based on SQL.
Every concept in this book is illustrated with an example of SQL code. In most cases, a task is set, then the SQL code is given to complete that task. The beginning and result tables of data are also shown. There are more than 200 of these examples. Each part stands on its own. You can read this book sequentially or skip around to find the parts that you need.
Be sure to look at the appendices for practical tips on how to run Oracle and Access. The CD-ROM contains the database files and the code for all the examples.
In several places throughout this book, I have expressed opinions about computer technology, something that many other technical books avoid doing. These opinions are my own and I take full responsibility for them. I also reserve the right to change my mind. If I do so, I will put my revised opinion and the reasons that have caused me to change my thinking on the Web site for this book,