Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself SQL in 10 Minutes

by: Forta, Ben

Sams Teach Yourself SQL in 10 Minutes

by: Forta, Ben

ISBN 13:
9780672316647
ISBN 10:
0672316641
Format: Paperback
Copyright: 08/01/1999
Publisher: Sams
Newer Edition

Rent

Sorry, this item is currently unavailable.

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

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

In easy, 10-minute lessons, beginners can learn how to retrieve and store data, combine queries, create triggers and more in SQL. Perfect for those who can't sift through heavy manuals, light chapters bright insight on the basics of this popular program.

Introduction

Understanding SQL

(7)

Database Basics

(4)

What Is SQL?

(2)

Summary

(1)

Retrieving Data

(6)

The SELECT Statement

(1)

Retrieving Individual Columns

(2)

Retrieving Multiple Columns

(1)

Retrieving All Columns

(1)

Summary

(1)

Sorting Retrieved Data

(6)

Sorting Data

(2)

Sorting by Multiple Columns

(1)

Sorting by Column Position

(1)

Specifying Sort Direction

(1)

Summary

(1)

Filtering Data

(6)

Using the WHERE Clause

(1)

The WHERE Clause Operators

(4)

Summary

(1)

Advanced Data Filtering

(7)

Combining WHERE Clauses

(4)

Using the In Operator

(1)

Using the Not Operator

(1)

Summary

(1)

Using Wildcard Filtering

(5)

Using the LIKE Operator

(4)

Tips for Using Wildcards

(1)

Summary

(1)

Creating Calculated Fields

(9)

Understanding Calculated Fields

(1)

Concatenating Fields

(6)

Performing Mathematical Calculations

(1)

Summary

(1)

Using Data Manipulation Functions

(9)

Understanding Functions

(2)

Using Functions

(6)

Summary

(1)

Summarizing Data

(9)

Using Aggregate Functions

(6)

Aggregates on Distinct Values

(1)

Combining Aggregate Functions

(1)

Summary

(1)

Grouping Data

(8)

Understanding Data Grouping

(1)

Creating Groups

(2)

Filtering Groups

(1)

Grouping and Sorting

(2)

SELECT Clause Ordering

(1)

Summary

(1)

Working with Subqueries

(7)

Understanding Subqueries

(1)

Filtering by Subquery

(4)

Using Subqueries as Calculated Fields

(2)

Summary

(1)

Joining Tables

(10)

Understanding Joins

(3)

Creating a Join

(6)

Summary

(1)

Creating Advanced Joins

(11)

Using Table Aliases

(2)

Join Types

(6)

Using Joins with Aggregate Functions

(1)

Using Joins and Join Conditions

(1)

Summary

100

(1)

Combining Queries

101

(7)

Understanding Combined Queries

101

(1)

Creating Combined Queries

102

(5)

Summary

107

(1)

Inserting Data

108

(8)

Understanding Data Insertion

108

(6)

Copying from One Table to Another

114

(1)

Summary

115

(1)

Updating and Deleting Data

116

(6)

Updating Data

116

(2)

Deleting Data

118

(2)

Guidelines for Updating and Deleting Data

120

(1)

Summary

121

(1)

Creating and Manipulating Tables

122

(9)

Creating Tables

122

(6)

Updating Tables

128

(2)

Deleting Tables

130

(1)

Renaming Tables

130

(1)

Summary

130

(1)

Using Views

131

(10)

Understanding Views

131

(3)

Creating Views

134

(6)

Summary

140

(1)

Using Transaction Processing

141

(7)

Understanding Transaction Processing

141

(2)

Controlling Transactions

143

(4)

Summary

147

(1)

Understanding Advanced SQL Features

148

(12)

Understanding Constraints

148

(6)

Understanding Indexes

154

(2)

Understanding Stored Procedures

156

(1)

Understanding Triggers

157

(2)

Summary

159

(1)

A Sample Table Scripts

160

(18)

Sample Tables Overview

160

(4)

Creating the Sample Tables

164

(4)

Populating the Sample Tables

168

(10)

B Working in Popular Applications

178

(10)

Configuring ODBC Data Sources

178

(1)

Using Allaire ColdFusion

179

(1)

Using DB2

180

(1)

Using Informix Dynamic Server 7.x

181

(1)

Using Microsoft Access

181

(1)

Using Microsoft ASP

182

(1)

Using Microsoft Query

183

(1)

Using Microsoft SQL Server 6.x

184

(1)

Using Microsoft SQL Server 7

184

(1)

Using Microsoft Visual Basic

185

(1)

Using Microsoft Visual C++

186

(1)

Using Oracle 8

186

(1)

Using Sybase

187

(1)

C SQL Statement Syntax

188

(4)

Alter Table

188

(1)

Commit

189

(1)

Create Index

189

(1)

Create Table

189

(1)

Create View

189

(1)

Delete

190

(1)

Drop

190

(1)

Insert

190

(1)

Insert Select

190

(1)

Rollback

190

(1)

Select

191

(1)

Update

191

(1)

D SQL Datatypes

192

(6)

String Datatypes

193

(2)

Numeric Datatypes

195

(1)

Date and Time Datatypes

196

(1)

Binary Datatypes

197

(1)

E SQL Reserved Words

198

(7)

Index

205

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself SQL in 10 Minutes

Sams Teach Yourself SQL in 10 Minutes

9780672316647

0672316641

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself SQL in 10 Minutes

Sams Teach Yourself SQL in 10 Minutes

9780672316647

0672316641

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products