Murach's Oracle SQL and PL/SQL
An introduction to relational databases and SQL

This chapter introduces you to the basic concepts and terms that apply to database systems. In particular, it explains what a relational database is and shows you some of the basic SQL statements and features you use to work with an Oracle database.

Chapter 1 An introduction to relational databases and SQL
An introduction to client/server systems 4
The hardware components of a client/server system 4
The software components of a client/server system 6
Other client/server system architectures 8
An introduction to the relational database model 10
How a table is organized 10
How tables are related 12
How columns in a table are defined 14
An introduction to SQL and SQL-based systems 16
A brief history of SQL 16
A comparison of Oracle, DB2, and Microsoft SQL Server 18
MySQL and other SQL-based systems 18
The SQL statements 20
An introduction to the SQL statements 20
How to work with database objects 22
How to query a single table 24
How to join data from two or more tables 26
How to add, update, and delete data in a table 28
How to work with views 30
SQL coding guidelines 32
An introduction to PL/SQL 34
How to work with stored procedures 34
How to work with user-defined functions 36
How to work with triggers 36
How to use SQL from an application program 38
Common data access models 38
Java code that retrieves data from an Oracle database 40


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.