 |
Teach Yourself SQL in 10 Minutes, 3rd Edition View Larger Image | Ben Forta
Sams, Paperback, 3rd edition, Published March 2004, 242 pages, ISBN 0672325675 | List Price: $19.99
Our Price: $13.50
You Save: $6.49 (32% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Macromedia ColdFusion MX 7 Web Application Construction Kit; Ben Forta, et al, $38.50, 36% Off!
- Advanced Macromedia ColdFusion MX 7 Application Development; Ben Forta, et al, $34.95, 36% Off!
- Teach Yourself Regular Expressions in 10 Minutes; Ben Forta, $11.50, 32% Off!
- MCTS Self-Paced Training Kit: Microsoft SQL Server 2005 Implementation and Maintenance (Exam 70-431); Solid Quality Learning, $35.95, 40% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Features
- NEW—Fully updated to reflect the latest versions of SQL used by
every leading commercial platform, from Access to Oracle.
- Teaches students techniques they will be able to utilize for many years
to come.
- NEW—Now also covers MySQL and PostgreSQL, the leading open source
database solutions.
- Enables students to learn SQL using increasingly popular databases that
are available to them at no cost.
- SQL organized into modular 10-minute lessons—Starts with the
simplest SQL techniques, then gradually builds on those skills to introduce
complex topics such as views and transactions.
- Prepares students for whatever tasks theyll need to perform with SQL,
while providing a firm foundation of key concepts and techniques they will
constantly rely upon.
- Examples tested in every leading SQL dialect—Sample code will
work regardless of platform, with any differences or issues clearly explained.
- Students can be confident that their SQL code will work regardless of
the platform they are using.
- Broad coverage of core SQL skills—Covers data retrieval, sorting,
filtering, insertion, calculation, manipulation, summaries, grouping, subqueries,
joins, table creation, and much more.
- Gives students a single source for a wide range of techniques, from basic
to expert-level.
- Complete e-commerce database available for download—Companion
Web site includes a fully populated Microsoft Access database that can be
used for practice.
- Gives students practice data files they can practice essential SQL techniques
with.
- By Ben Forta, one of the worlds most experienced authors—Authored
by an expert who has helped millions of students and professionals master
database and Web development technologies.
- Gives students confidence that they are receiving information that is
thorough, accurate, clear, and useful—and reflects the challenges
they will actually face.
Table of Contents
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.
About the Author
Ben Forta is Macromedia?s Senior Product Evangelist for server products.
Be has 20 years of experience in the computer industry in areas ranging from
development to teaching to marketing. Ben is the author of the popular ColdFusion
Web Application Construction Kit, and it?s sequel Advanced ColdFusion
Application Development, as well as books on SQL, Flash, JSP, HomSite, WAP,
Windows 2000, and other technologies.
|
|
