Publishers of technology books, eBooks, and videos for creative people
Register your product to gain access to bonus material or receive a coupon.
SQL: Visual QuickStart Guide
- By Chris Fehily
- Published Jul 19, 2002 by Peachpit Press. Part of the Visual QuickStart Guide series.
Book
- Sorry, this book is no longer in print.
About
Features
- Proven QuickStart visual learning format—Combines an open, welcoming design, hundreds of screen captures, expert tips, and concise step-by-step instructions.
-
Relies on a format designed to make learning as easy as possible—even for students with little or no database programming experience.
-
- Easy to understand overview of databases and SQL—Presents crystal-clear, plain-English explanations of databases, the relational model, and SQL's goals.
-
Helps students quickly understand the key concepts that underlie all databases and queries.
-
- Comprehensive coverage of the fundamentals—Covers all the skills required for writing basic SQL queries and applications, including retrieving, summarizing, and grouping data; working with rows and tables, and more.
-
Covers everything students need to quickly become productive and effective with SQL.
-
- Introductions to indexes, views, and transactions—Presents simple introductions to the advanced SQL features that are likely to be of most value to typical students.
-
Shows students how to begin using advanced SQL features that can significantly improve the reliability and performance of their database applications and queries.
-
- ANSI SQL standards compliant—Covers SQL from a vendor-independent, standards compliant point of view, while also providing occasional high-value tips for proprietary platforms.
-
Will be valuable to students regardless of the database platform they are currently utilizing, proprietary or “open”—and will remain useful if they change platforms in the future.
-
- Expert tutorial and handy quick reference—Designed not only to teach SQL exceptionally well, but also to serve as an outstanding task-based reference.
-
Will remain valuable to students long after they've mastered the fundamentals of SQL.
-
Description
- Copyright 2003
- Edition: 1st
- Book
- ISBN-10: 0-321-11803-0
- ISBN-13: 978-0-321-11803-5
Database management. It may sound daunting, but it doesn't have to be, even if you've never programmed before. SQL: Visual QuickStart Guide isn't an exhaustive guide to SQL written for aspiring programming experts. It's simply an invaluable resource for those who want a fast, easy way to harness information living in complex databases.
Because author Chris Fehily assumes no prior programming experience on your part (just a familiarity with your OS's file system), he spends the first few chapters laying out the basics, including clear explanations of the relational database model and SQL syntax. Then he jumps into step-by-step tasks designed to get you comfortable using SQL right away. You'll learn how to use SQL's most popular statements and commands to maintain, retrieve, and analyze database information, and to create and edit database objects. Each visually oriented task features the actual code and plenty of screenshots to keep you on track. Fehily takes a software-independent approach to teaching SQL, but includes tips for specific database software. You may not be a programming expert, but with SQL: VQS, who will be able to tell?
Downloads
Files
Click below for the files related to this title:
http://www.fehily.com/books/sql1.htm
Sample Content
Online Sample Chapter
Summarizing and Grouping Data in SQL
Table of Contents
Introduction.
1. DBMS Specifics.
2. The Relational Model.
3. SQL Basics.
4. Retrieving Data From a Table.
5. Operators and Functions.
6. Summarizing and Grouping Data.
7. Retrieving Data From Multiple Tables.
8. Subqueries.
9. Inserting, Updating, and Deleting Rows.
10. Creating, Altering, and Dropping Tables.
11. Indexes.
12. Views.
13. Transactions.
Appendix.
Index.
Updates
Updates & Corrections
Corrections and Updates
http://www.fehily.com/books/sql1.htm