|
SQL Simplified:
Learn To Read and Write
Structured Query Language (SQL)
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.50 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.
|
|
Click
here to purchase the book ($17.50).
|
|
|
Click here to obtain the SQL script to create the tables used in
the book.
|
Note: SQL Simplified: Learn To Read and Write Structured
Query Language is also available for purchase through most on-line
bookstores.
About the Author
Dr. Cecelia L. Allison wrote and facilitates an on-line SQL course (Introduction to SQL) that is offered on-line
through hundreds of accredited colleges, universities, and other accredited
educational facilities worldwide. She is an experienced software
tester and technical specialist with many years of hands-on
experience using and teaching SQL. Dr. Allison is the author of SQL Simplified: Learn to
Read and Write Structured Query Language and SQL for Microsoft Access. She teaches on-line
technical courses for Park University.
Dr. Allison holds a Bachelor of Science in finance, a Master of Science in information systems, and a Doctor of Business Administration in management information systems.
Top
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 Hill
Top
|
