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:
9780672321283
ISBN 10:
0672321289
Edition: 2nd
Format: Paperback
Copyright: 01/01/2001
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

Sams Teach Yourself SQL in 10 Minutes, 2E is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well targeted lessons teach you in 10 minutes what some books take several hours or days to teach. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.The reader of this book will learn how to: Retrieve and sort data Filter data using comparisons and wildcards Use the aggregate functions to analyze data Perform insert, update, and delete operations Join relational tables using inner, outer, and self joins Combine queries using unions Use views Create and use stored procedures, triggers, and other advanced database features

Introduction

(5)

Understanding SQL

(8)

Database Basics

(6)

What Is SQL?

(1)

Try It Yourself

(1)

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

(7)

Sorting Data

(2)

Sorting by Multiple Columns

(1)

Sorting by Column Position

(1)

Specifying Sort Direction

(2)

Summary

(1)

Filtering Data

(6)

Using the WHERE Clause

(1)

The WHERE Clause Operators

(4)

Summary

(1)

Advanced Data Filtering

(8)

Combining WHERE Clauses

(4)

Using the IN Operator

(1)

Using the NOT Operator

(2)

Summary

(1)

Using Wildcard Filtering

(6)

Using the LIKE Operator

(5)

Tips for Using Wildcards

(1)

Summary

(1)

Creating Calculated Fields

(10)

Understanding Calculated Fields

(1)

Concatenating Fields

(6)

Performing Mathematical Calculations

(2)

Summary

(1)

Using Data Manipulation Functions

(10)

Understanding Functions

(2)

Using Functions

(7)

Summary

(1)

Summarizing Data

(10)

Using Aggregate Functions

(7)

Aggregates on Distinct Values

(1)

Combining Aggregate Functions

(1)

Summary

(1)

Grouping Data

(9)

Understanding Data Grouping

(1)

Creating Groups

(2)

Filtering Groups

(2)

Grouping and Sorting

(3)

SELECT Clause Ordering

(1)

Summary

(1)

Working with Subqueries

(8)

Understanding Subqueries

(1)

Filtering by Subquery

(4)

Using Subqueries As Calculated Fields

(3)

Summary

(1)

Joining Tables

(11)

Understanding Joins

(3)

Creating a Join

(7)

Summary

103

(1)

Creating Advanced Joins

104

(11)

Using Table Aliases

104

(2)

Join Types

106

(6)

Using Joins with Aggregate Functions

112

(1)

Using Joins and Join Conditions

113

(1)

Summary

114

(1)

Combining Queries

115

(7)

Understanding Combined Queries

115

(1)

Creating Combined Queries

116

(5)

Summary

121

(1)

Inserting Data

122

(9)

Understanding Data Insertion

122

(6)

Copying from One Table to Another

128

(2)

Summary

130

(1)

Updating and Deleting Data

131

(6)

Updating Data

131

(2)

Deleting Data

133

(2)

Guidelines for Updating and Deleting Data

135

(1)

Summary

136

(1)

Creating and Manipulating Tables

137

(10)

Creating Tables

137

(6)

Updating Tables

143

(2)

Deleting Tables

145

(1)

Renaming Tables

146

(1)

Summary

146

(1)

Using Views

147

(11)

Understanding Views

147

(3)

Creating Views

150

(7)

Summary

157

(1)

Working with Stored Procedures

158

(8)

Understanding Stored Procedures

158

(1)

Why to Use Stored Procedures

159

(2)

Executing Stored Procedures

161

(1)

Creating Stored Procedures

162

(3)

Summary

165

(1)

Managing Transaction Processing

166

(7)

Understanding Transaction Processing

166

(2)

Controlling Transactions

168

(4)

Summary

172

(1)

Using Cursors

173

(7)

Understanding Cursors

173

(2)

Working with Cursors

175

(4)

Summary

179

(1)

Understanding Advanced SQL Features

180

(12)

Understanding Constraints

180

(6)

Understanding Indexes

186

(3)

Understanding Triggers

189

(1)

Database Security

190

(1)

Summary

191

(1)

A Sample Table Scripts

192

(19)

Sample Tables Overview

192

(4)

Creating the Sample Tables

196

(4)

Populating the Sample Tables

200

(11)

B Working in Popular Applications

211

(14)

Configuring ODBC Data Sources

211

(2)

Using Allaire ColdFusion

213

(1)

Using Allaire JRun 3.x

214

(1)

Using DB2

214

(1)

Using Informix Dynamic Server 7.x

215

(1)

Using Microsoft Access

215

(2)

Using Microsoft ASP

217

(1)

Using Microsoft Query

218

(1)

Using Microsoft SQL Server 6.x

219

(1)

Using Microsoft SQL Server 7

219

(1)

Using Microsoft SQL Server 2000

220

(1)

Using Microsoft Visual Basic

221

(1)

Using Microsoft Visual C++

221

(1)

Using Oracle 8

222

(1)

Using Query Tool

223

(1)

Using Sybase

224

(1)

C SQL Statement Syntax

225

(5)

Alter Table

225

(1)

Commit

226

(1)

Create Index

226

(1)

Create Procedure

226

(1)

Create Table

226

(1)

Create View

227

(1)

Delete

227

(1)

Drop

227

(1)

Insert

228

(1)

Insert Select

228

(1)

Rollback

228

(1)

Select

228

(1)

Update

229

(1)

D Using SQL Datatypes

230

(6)

String Datatypes

231

(2)

Numeric Datatypes

233

(1)

Date and Time Datatypes

234

(1)

Binary Datatypes

235

(1)

E SQL Reserved Words

236

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself SQL in 10 Minutes

Sams Teach Yourself SQL in 10 Minutes

9780672321283

0672321289

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

9780672321283

0672321289

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products