SQL Simplified: Learn To Read and Write Structured Query Language focuses extensively on the implementation of Structured Query Language (SQL) rather than on database design or on the Database Management System’s (DBMS’s) that implement SQL, like many SQL books.

The easy to follow step-by-step chapters of this book will provide beginners with the practice necessary to develop the skills and knowledge required to program in SQL with ease. The concepts of SQL are simplified enabling anyone to quickly grasp the fundamentals of SQL. Each chapter introduces a new concept and includes examples, key notes and important key terms. This book also highlights many key differences in SQL script used in a number of different database management system platforms. Your comprehension of each chapter is tested through the use of quizzes and assignments. After completion of this book, you should feel confident using SQL in any relational database environment.

Cecelia L. Allison is originally from St. Petersburg, Florida. She is a freelance Webmaster and also works as an author/facilitator instructing students on Structured Query Language (SQL) over the Internet through universities, colleges, and other educational facilities around the world.

Cecelia has been using SQL for many years. Through her past and present employment she has gained extensive experience in writing and implementing SQL. She holds a Bachelor of Science degree in Finance and a Master of Science degree in Computer Information Systems.

 

Dedication

Acknowledgments

Introduction

Platforms used in the Book

Chapter 1. The Relational Database and Structured Query Language

The Relational Database Structure
Structured Query Language

Chapter 2. Creating Tables and Working with Data

Table Creation
Inserting Data Into a Table
Transferring Data from One Table to an Existing Table
Transferring Data from One Table to a New Table
Updating Data in a Table
Deleting Data in a Table

Chapter 3. Selecting and Retrieving Data

The SELECT Statement
Creating a SELECT Statement to Retrieve Multiple Columns
Creating a SELECT Statement to Retrieve Every Column
Using DISTINCT to display Unique Values in a Column
Using the AS Keyword to Create an Alternate Name for a Column
Merging Columns
Uniting Queries to Compare Records in Two Separate Tables

Chapter 4. Filter Retrieved Data

The WHERE Clause
Using a Comparison Operator to Match a Condition
Using a Character Operator to Match a Condition
Using a Logical Operator to Match a Condition
Using a Logical Operator to Match a Condition Opposite of the One
Defined
Using the IN Operator to Match a Condition
Using the BETWEEN Operator to Match a Condition

Chapter 5. Creating Calculated Fields

Calculated Fields
Concatenation
Arithmetic Operators
Functions

Chapter 6. Using Additional Clauses in Structured Query

Language
Clauses
Using the ORDER BY Clause
Using the GROUP BY Clause
Using the GROUP BY and WHERE Clause
Using the HAVING Clause

Chapter 7. Creating Table Joins

Table Joins
Qualification
Self Join
Natural Join
Outer Join

Chapter 8. Creating Subqueries

Subqueries
Using the IN keyword to link Queries
Using the EXISTS keyword to link Queries
Using the ANY keyword to link Queries
Using the ALL keyword to link Queries
Creating Subqueries to Query Three Tables

Chapter 9. Creating Views

Views
Creating a View on One Table
Creating a View on Multiple Tables
Filtering Table Data Using a View
Updating and Inserting Data into Tables Using Views
Deleting a View

Chapter 10. Advanced Table Creation and Table Management

Table Creation
Constraints
Indexes
Table Management
Adding a Column
Deleting a Column
Deleting a Table

Chapter 11. Advanced Topics: Transaction Processing, Stored Procedures, Triggers and Cursors

Transaction Processing
Stored Procedures
Triggers
Cursors

Appendix A

Answers to Quizzes and Assignments

Appendix B

SQL Script for the Tables Used in the Book:
http://www.angelfire.com/ca2/n4systems/BookScript.html

Appendix C

SQL Command Syntax

Appendix D

Instructions on Where to Type SQL Script in Microsoft Access and Microsoft SQL Server

Index

 

 

 

View the SQL script for creating tables used in the book.
http://www.jaffainc.com/SQLBookScript.html

 

View the SQL course entitled “Introduction to SQL”.
http://www.jaffainc.com