SQL Simplified

Click here to obtain the SQL script to create the tables used in the book.

About the Book

Structured Query Language (SQL) is the industry standard database programming language. It is used to create databases, manipulate and retrieve data, and to provide security for relational databases. Some of the more popular Database Management Systems (DBMSs) that implement SQL include Microsoft Access, Microsoft SQL Server, Oracle and MySQL. If you manage data or plan to work in a field managing data, you should make learning SQL a priority.

SQL Simplified: Learn To Read and Write Structured Query Language is a low cost book ($17.75 paperback) that focuses extensively on the implementation of Structured Query Language (SQL) rather than on database design or on the Database Management Systems (DBMSs) that implement SQL.

This book simplifies the concepts of SQL, enabling anyone to quickly grasp the fundamentals of SQL. Each chapter includes examples, important notes and key terms. Additionally, this book highlights many key differences in SQL script used in a number of different database management system platforms and tests your comprehension of each chapter using quizzes and assignments. After completion of this book, you should feel confident using SQL in any relational database environment.

About the Author

Dr. Cecelia L. Allison is originally from St. Petersburg, Florida. She authored SQL for Microsoft Access 1st and 2nd Edition. She wrote and developed the online courses Introduction to SQL and Intermediate SQL which are offered on-line through hundreds of accredited colleges, universities, and other accredited educational facilities worldwide. She also writes books for Jones & Bartlett Learning and teaches on-line technical courses for Park University.

Dr. Allison has been using SQL for many years. Through her past employment she has gained extensive experience in writing and implementing SQL. She holds a Bachelor of Science in finance, a Master of Science in information systems, and a Doctor of Business Administration in management information systems.

Topics Covered

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

Appendix C

  • SQL Command Syntax

Appendix D

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

Index

Editors

Editor: John F. Allison

Development Editor: Panzina Elizabeth Coney