Sams Teach Yourself SQL in 10... | Buy

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

1

(5)

Understanding SQL

5

(8)

Database Basics

5

(6)

What Is SQL?

11

(1)

Try It Yourself

12

(1)

Summary

12

(1)

Retrieving Data

13

(6)

The SELECT Statement

13

(1)

Retrieving Individual Columns

14

(2)

Retrieving Multiple Columns

16

(1)

Retrieving All Columns

17

(1)

Summary

18

(1)

Sorting Retrieved Data

19

(7)

Sorting Data

19

(2)

Sorting by Multiple Columns

21

(1)

Sorting by Column Position

22

(1)

Specifying Sort Direction

23

(2)

Summary

25

(1)

Filtering Data

26

(6)

Using the WHERE Clause

26

(1)

The WHERE Clause Operators

27

(4)

Summary

31

(1)

Advanced Data Filtering

32

(8)

Combining WHERE Clauses

32

(4)

Using the IN Operator

36

(1)

Using the NOT Operator

37

(2)

Summary

39

(1)

Using Wildcard Filtering

40

(6)

Using the LIKE Operator

40

(5)

Tips for Using Wildcards

45

(1)

Summary

45

(1)

Creating Calculated Fields

46

(10)

Understanding Calculated Fields

46

(1)

Concatenating Fields

47

(6)

Performing Mathematical Calculations

53

(2)

Summary

55

(1)

Using Data Manipulation Functions

56

(10)

Understanding Functions

56

(2)

Using Functions

58

(7)

Summary

65

(1)

Summarizing Data

66

(10)

Using Aggregate Functions

66

(7)

Aggregates on Distinct Values

73

(1)

Combining Aggregate Functions

74

(1)

Summary

75

(1)

Grouping Data

76

(9)

Understanding Data Grouping

76

(1)

Creating Groups

77

(2)

Filtering Groups

79

(2)

Grouping and Sorting

81

(3)

SELECT Clause Ordering

84

(1)

Summary

84

(1)

Working with Subqueries

85

(8)

Understanding Subqueries

85

(1)

Filtering by Subquery

85

(4)

Using Subqueries As Calculated Fields

89

(3)

Summary

92

(1)

Joining Tables

93

(11)

Understanding Joins

93

(3)

Creating a Join

96

(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

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.