Sams Teach Yourself SQL in 10 Minutes
Sams Publishing (Verlag)
978-0-672-32128-3 (ISBN)
- Titel erscheint in neuer Auflage
- Artikel merken
Sams Teach Yourself SQL in 10 Minutes, 2E is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well targeted lessons teach you in 10 minutes what some books take several hours or days to teach. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.
The reader of this book will learn how to:
Retrieve and sort data
Filter data using comparisons and wildcards
Use the aggregate functions to analyze data
Perform insert, update, and delete operations
Join relational tables using inner, outer, and self joins
Combine queries using unions
Use views
Create and use stored procedures, triggers, and other advanced database features
Ben Forta is Allaire Corporation's product evangelist for the ColdFusion product line. Ben has over 15 years of experience in the computer industry, and spent 6 years as part of the development team responsible for creating OnTime, one of the most successful calendar and group-scheduling products, with over one million users worldwide. Ben is the author of the popular ColdFusion Web Application Construction Kit, and it's sequel Advanced ColdFusion 4 Application Development, as well as books on JSP (JavaServer Pages), WAP, and other technologies.
1. Understanding SQL.
2. Retrieving Data.
3. Sorting Retrieved Data.
4. Filtering Data.
5. Advanced Data Filtering.
6. Using Wildcard Filtering.
7. Calculated Fields.
8. Data Manipulation Functions.
9. Summarizing Data.
10. Grouping Data.
11. Subqueries.
12. Joining Tables.
13. Advanced Joins.
14. Combining Queries.
15. Inserting Data.
16. Data.
17. Tables.
18. Using Views.
19. Transaction Processing.
20. Advanced SQL Features.
A: Sample Table Scripts.
B: Popular Applications.
C: SQL Statement Syntax.
D: SQL Datatypes.
| Erscheint lt. Verlag | 11.5.2001 |
|---|---|
| Verlagsort | Indianapolis |
| Sprache | englisch |
| Maße | 139 x 210 mm |
| Gewicht | 308 g |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| ISBN-10 | 0-672-32128-9 / 0672321289 |
| ISBN-13 | 978-0-672-32128-3 / 9780672321283 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
