Loading…
SQL queries for mere mortals : a hands-on guide to data manipulation in SQL /
| Call Number: | Libro Electrónico |
|---|---|
| Main Author: | |
| Other Authors: | |
| Format: | Electronic eBook |
| Language: | Inglés |
| Published: |
Upper Saddle River, N.J. :
Addison-Wesley,
2007.
|
| Edition: | 2nd ed. |
| Series: | For mere mortals series.
|
| Subjects: | |
| Online Access: | Texto completo (Requiere registro previo con correo institucional) |
Table of Contents:
- pt. I. Relational Databases and SQL
- Ch. 1. What Is Relational?
- Ch. 2. Ensuring Your Database Structure Is Sound
- Ch. 3. A Concise History of SQL
- pt. II. SQL Basics
- Ch. 4. Creating a Simple Query
- Ch. 5. Getting More Than Simple Columns
- Ch. 6. Filtering Your Data
- pt. III. Working with Multiple Tables
- Ch. 7. Thinking in Sets
- Ch. 8. INNER JOINs
- Ch. 9. Outer Joins
- Ch. 10. Unions
- Ch. 11. Subqueries
- pt. IV. Summarizing and Grouping Data
- Ch. 12. Simple Totals
- Ch. 13. Grouping Data
- Ch. 14. Filtering Grouped Data
- pt. V. Modifying Sets of Data
- Ch. 15. Updating Sets of Data
- Ch. 16. Inserting Sets of Data
- Ch. 17. Deleting Sets of Data
- App. A. SQL Standard Diagrams
- App. B. Schema for the Sample Databases
- App. C. Date and Time Functions.