Prentice Hall SQL Fundamentals 3rd Edition
By John J. Patrick
This Ebook is in Electronic PDF Format - 832 Pages
CONTENTS AT A GLANCE
Chapter No.1: Storing Information in Tables
Chapter No.2: Getting Information from a Table
Chapter No.3: Compound Conditions in the Where Clause
Chapter No.4: Saving Your Results
Chapter No.5: The Data Dictionary and Other Oracle Topics
Chapter No.6: Creating Your Own Tables
Chapter No.7: Formats, Sequences, and Indexes
Chapter No.8: Data Integrity
Chapter No.9: Row Functions
Chapter No.10: Using Row Functions
Chapter No.11: Summarizing Data
Chapter No.12: Controlling the Level of Summarization
Chapter No.13: Inner Joins
Chapter No.14: Outer Joins
Chapter No.15: Union and Union All
Chapter No.16: Cross Joins, Self Joins, and CrossTab Queries
Chapter No.17: Combining Tables in a Production Database
Chapter No.18: If-Then-Else, Parameter Queries, and Subqueries
Chapter No.19: The Multiuser Environment
Chapter No.20: The Design of SQL