Creating SQL Queries Using Oracle SQL Made Easy

Overview
If you have been looking for a book that has a lot of easy to understand step-by-step instructions and screen shots that show you how to create queries using Oracle SQL, this is the book for you. This book has been designed to have you creating queries quickly, by teaching you the basics and more. It is written from the perspective that you have not created queries using Oracle SQL. This book is for the beginner. To help you become familiar with the options and features, this book contains over 650 illustrations that provide a visual tour of the results of the queries that you create. There are also over 450 ready to use queries in the examples and exercises.

This book will show you how to use some of the most used features of Oracle SQL, by completing the tasks in each exercise. Topics are explained as you go along. You will cover enough of Oracle SQL to know whether or not it will handle a large percent of your needs, without investing weeks of your time, trying to learn about a larger number of features and options. This book will get you up and running quickly, by teaching a little more than the basics, so that you can use Oracle SQL effectively.

Table Of Contents

Chapter 1 - Getting Started With Oracle SQL
Chapter 2 - Using SQL Developer
Chapter 3 - Creating Single Table Queries
Chapter 4 - Filter Data
Chapter 5 - Using Sngle Row Functions
Chapter 6 - Creating Advanced Single Table Queries
Chapter 7 - Creating Queries That Use Multiple Tables
Chapter 8 - Using Outer Joins To Link Tables
Chapter 9 - Using Text And Numeric Functions
Chapter 10 - Using Date Functions
Chapter 11 - Using Aggregate Functions And Creating Summary Queries
Chapter 12 - Advanced Summary Queries
Chapter 13 - Creating Subqueries
Chapter 14 - Creating And Using Views

Oracle SQL Home Page | Errata |