Limit search to available items
Record 18 of 23
Previous Record Next Record
Book Cover
E-book
Author Forta, Ben.

Title Sams teach yourself SQL in 10 minutes / Ben Forta
Published Indianapolis, Ind. : Sams, [2000]
©2000
Online access available from:
Safari O'Reilly books online    View Resource Record  

Copies

Description 1 online resource (xii, 208 pages)
Contents Understanding SQL -- Database Basics -- Retrieving Data -- The Select Statement -- Retrieving Individual Columns -- Retrieving Multiple Columns -- Retrieving All Columns -- Sorting Retrieved Data -- Sorting Data -- Sorting by Multiple Columns -- Sorting by Column Position -- Specifying Sort Direction -- Filtering Data -- Using the Where Clause -- The Where Clause Operators -- Advanced Data Filtering -- Combining Where Clauses -- Using the In Operator -- Using the Not Operator -- Using Wildcard Filtering -- Using the Like Operator -- Tips for Using Wildcards -- Creating Calculated Fields -- Understanding Calculated Fields -- Concatenating Fields -- Performing Mathematical Calculations -- Using Data Manipulation Functions -- Understanding Functions -- Using Functions -- Summarizing Data -- Using Aggregate Functions -- Aggregates on Distinct Values -- Combining Aggregate Functions -- Grouping Data -- Understanding Data Grouping -- Creating Groups -- Filtering Groups -- Grouping and Sorting -- Select Clause Ordering -- Working with Subqueries -- Understanding Subqueries -- Filtering by Subquery -- Using Subqueries As Calculated Fields -- Joining Tables -- Understanding Joins -- Creating a Join -- Creating Advanced Joins -- Using Table Aliases -- Join Types -- Using Joins with Aggregate Functions -- Using Joins and Join Conditions -- Combining Queries -- Understanding Combined Queries -- Creating Combined Queries -- Inserting Data -- Understanding Data Insertion -- Copying from One Table to Another
Notes Print version record
Subject SQL (Computer program language)
Form Electronic book
ISBN 0585131163 (electronic bk.)
9780585131160 (electronic bk.)
9780672316647
Other Titles Teach yourself SQL in 10 minutes