SQL Simplified

, by Allison, Cecelia L.

Write a Review

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9781410729743 | 1410729745
Cover: Paperback
Copyright: 8/1/2003

Buy New

Print on Demand: 2-4 Weeks. This item cannot be cancelled or returned.

$17.31

Supplemental Materials

About the Author

Dedication

Acknowledgments

xiii

Introduction

Platforms used in the Book

The Relational Database and Structured Query Language

(7)

The Relational Database Structure

(3)

Structured Query Language

(3)

Creating Tables and Working with Data

(17)

Table Creation

(7)

Inserting Data Into a Table

(4)

Transferring Data from One Table to an Existing Table

(1)

Transferring Data from One Table to a New Table

(1)

Updating Data in a Table

(2)

Deleting Data in a Table

(2)

Selecting and Retrieving Data

(13)

The SELECT Statement

(1)

Creating a SELECT Statement to Retrieve Multiple Columns

(1)

Creating a SELECT Statement to Retrieve Every Column

(1)

Using DISTINCT to display Unique Values in a Column

(1)

Using the AS Keyword to Create an Alternate Name for a Column

(2)

Merging Columns

(1)

Uniting Queries to Compare Records in Two Separate Tables

(5)

Filter Retrieved Data

(14)

The Where Clause

(2)

Using a Comparison Operator to Match a Condition

(2)

Using a Character Operator to Match a Condition

(3)

Using a Logical Operator to Match a Condition

(1)

Using a Logical Operator to Match a Condition Opposite of the One Defined

(1)

Using the IN Operator to Match a Condition

(2)

Using the BETWEEN Operator to Match a Condition

(3)

Creating Calculated Fields

(14)

Calculated Fields

(1)

Concatenation

(1)

Arithmetic Operators

(2)

Functions

(10)

Using Additional Clauses in Structured Query Language

(15)

Clauses

(1)

Using the Order by Clause

(7)

Using the Group by Clause

(2)

Using the Group by and Where Clause

(1)

Using the Having Clause

(4)

Creating Table Joins

(19)

Table Joins

(1)

Qualification

(4)

Self Join

(3)

Natural Join

(3)

Outer Join

(8)

Creating Subqueries

100

(17)

Subqueries

101

(1)

Using the IN keyword to link Queries

102

(2)

Using the Exists keyword to link Queries

104

(1)

Using the ANY keyword to link Queries

105

(2)

Using the ALL keyword to link Queries

107

(2)

Creating Subqueries to Query Three Tables

109

(3)

Creating Subqueries that Contain Aggregate Functions

112

(5)

Creating Views

117

(14)

Views

118

(1)

Creating a View on One Table

118

(3)

Creating a View on Multiple Tables

121

(3)

Filtering Table Data Using a View

124

(1)

Updating and Inserting Data into Tables Using Views

125

(4)

Deleting a View

129

(2)

Advanced Table Creation and Table Management

131

(12)

Table Creation

132

(2)

Constraints

134

(2)

Indexes

136

(3)

Table Management

139

(1)

Adding a Column

139

(2)

Deleting a Column

141

(1)

Deleting a Table

141

(2)

Advanced Topics: Transaction Processing, Stored Procedures, Triggers and Cursors

143

(19)

Transaction Processing

145

(3)

Stored Procedures

148

(7)

Triggers

155

(3)

Cursors

158

(4)

Appendix A

162

(9)

Answers to Quizzes and Assignments

162

(9)

Appendix B

171

(16)

SQL Script for the Tables Used in the Book

171

(16)

Appendix C

187

(3)

SQL Command Syntax

187

(3)

Appendix D

190

(3)

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

190

(3)

Index

193

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

SQL Simplified

Table of Contents

Supplemental Materials