Cargando…
Sams teach yourself SQL in 10 minutes /
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Sams,
©2000.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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.