| 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 |
|
