SQL, Third Edition (Visual QuickStart Guide Series) / Edition 3
  • SQL, Third Edition (Visual QuickStart Guide Series) / Edition 3
  • SQL, Third Edition (Visual QuickStart Guide Series) / Edition 3

SQL, Third Edition (Visual QuickStart Guide Series) / Edition 3

5.0 1
by Chris Fehily
     
 

SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will

See more details below

Overview

SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users.

Product Details

ISBN-13:
9780321553577
Publisher:
Peachpit Press
Publication date:
06/13/2008
Series:
Visual QuickStart Guide Series
Edition description:
Third Edition
Pages:
483
Sales rank:
316,414
Product dimensions:
6.94(w) x 8.92(h) x 1.01(d)

Table of Contents


Introduction     xi
About SQL     xii
About This Book     xvi
What You'll Need     xx
DBMS Specifics     1
Running SQL Programs     2
Microsoft Access     5
Microsoft SQL Server     10
Oracle     17
IBM DB2     20
MySQL     27
PostgreSQL     30
The Relational Model     33
Tables, Columns, and Rows     34
Primary Keys     38
Foreign Keys     40
Relationships     42
Normalization     45
The Sample Database     51
Creating the Sample Database     57
SQL Basics     61
SQL Syntax     62
SQL Standards and Conformance     65
Identifiers     66
Data Types     68
Character String Types     70
Binary Large Object Type     72
Exact Numeric Types     73
Approximate Numeric Types     75
Boolean Type     76
Datetime Types     77
Interval Types     80
Unique Identifiers     82
Other DataTypes     83
Nulls     84
Retrieving Data from a Table     87
Retrieving Columns with SELECT and FROM     88
Creating Column Aliases with AS     91
Eliminating Duplicate Rows with DISTINCT     93
Sorting Rows with ORDER BY     95
Filtering Rows with WHERE     101
Combining and Negating Conditions with AND, OR, and NOT     105
Matching Patterns with LIKE     114
Range Filtering with BETWEEN     118
List Filtering with IN     121
Testing for Nulls with IS NULL     124
Operators and Functions     127
Creating Derived Columns     128
Performing Arithmetic Operations     130
Determining the Order of Evaluation     133
Concatenating Strings with [double vertical line]     134
Extracting a Substring with SUBSTRING()     137
Changing String Case with UPPER() and LOWER()     140
Trimming Characters with TRIM()     142
Finding the Length of a String with CHARACTER_LENGTH()     147
Finding Substrings with POSITION()     149
Performing Datetime and Interval Arithmetic     152
Getting the Current Date and Time      154
Getting User Information     156
Converting Data Types with CAST()     157
Evaluating Conditional Values with CASE     161
Checking for Nulls with COALESCE()     165
Comparing Expressions with NULLIF()     166
Summarizing and Grouping Data     169
Using Aggregate Functions     170
Creating Aggregate Expressions     171
Finding a Minimum with MIN()     172
Finding a Maximum with MAX()     173
Calculating a Sum with SUM()     174
Calculating an Average with AVG()     175
Counting Rows with COUNT()     178
Aggregating Distinct Values with DISTINCT     179
Grouping Rows with GROUP BY     183
Filtering Groups with HAVING     190
Joins     193
Qualifying Column Names     194
Creating Table Aliases with AS     196
Using Joins     198
Creating Joins with Join or WHERE     200
Creating a Cross Join with CROSS JOIN     204
Creating a Natural Join with NATURAL JOIN     206
Creating an Inner Join with INNER JOIN     210
Creating Outer Joins with OUTER JOIN     235
Creating a Self-Join      247
Subqueries     253
Understanding Subqueries     254
Subquery Syntax     256
Subqueries vs. Joins     257
Simple and Correlated Subqueries     262
Qualifying Column Names in Subqueries     267
Nulls in Subqueries     268
Using Subqueries as Column Expressions     270
Comparing a Subquery Value by Using a Comparison Operator     275
Testing Set Membership with IN     281
Comparing All Subquery Values with ALL     288
Comparing Some Subquery Values with ANY     291
Testing Existence with EXISTS     294
Comparing Equivalent Queries     301
Set Operations     303
Combining Rows with UNION     304
Finding Common Rows with INTERSECT     310
Finding Different Rows with EXCEPT     312
Inserting, Updating, and Deleting Rows     315
Displaying Table Definitions     316
Inserting Rows with INSERT     319
Updating Rows with UPDATE     327
Deleting Rows with DELETE     333
Creating, Altering, and Dropping Tables     337
Creating Tables     338
Understanding Constraints     339
Creating a New Table with CREATE TABLE     341
Forbidding Nulls with NOT NULL     343
Specifying a Default Value with DEFAULT     346
Specifying a Primary Key with PRIMARY KEY     350
Specifying a Foreign Key with FOREIGN KEY     353
Forcing Unique Values with UNIQUE     359
Adding a Check Constraint with CHECK     363
Creating a Temporary Table with CREATE TEMPORARY TABLE     366
Creating a New Table from an Existing One with CREATE TABLE AS     369
Altering a Table with ALTER TABLE     373
Dropping a Table with DROP TABLE     376
Indexes     377
Creating an Index with CREATE INDEX     378
Dropping an Index with DROP INDEX     383
Views     385
Creating a View with CREATE VIEW     386
Retrieving Data Through a View     391
Updating Data Through a View     394
Dropping a View with DROP VIEW     398
Transactions     399
Executing a Transaction     400
SQL Tricks     405
Calculating Running Statistics     406
Generating Sequences     409
Finding Sequences, Runs, and Regions     415
Limiting the Number of Rows Returned      421
Assigning Ranks     430
Calculating a Trimmed Mean     432
Picking Random Rows     433
Handling Duplicates     435
Creating a Telephone List     438
Retrieving Metadata     439
Working with Dates     445
Calculating a Median     451
Finding Extreme Values     453
Changing Running Statistics Midstream     454
Pivoting Results     456
Working with Hierarchies     458
Index     465

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >