SQL from the Ground Up [Paperback]

Mary Pyefinch (Author)

Book Description

Publication Date: April 1, 1999 | Series: From the Ground Up

SQL (structured query language) is flexible, cross-platform language used to identify trends and relationships in data. SQL relational database business and services is a multi-billion dollar industry. The perfect introduction to SQL in an accelerated tutorial fashion. Real-world examples of how to design a database and retrieve data using queries and reports.

Editorial Reviews

From the Back Cover

Do you need to learn SQL for your job?

Whether you are new to programming or are an experienced programmer, SQL from the Ground Up will teach you how to design, build, and query a relational database with SQL - the most powerful and flexible query and programming language in use today. Whether you're an IS programmer who needs to create a database or a marketing professional who wants to retrieve information to generate leads, this acelerated tutorial is for you.

Inside you'll find step-by-step coverage of everything from mastering SQL building blocks to performing complex queries to creating forms and reports to using SQL with Oracle PL/SQL, SQL Server 7, and other database applications. SQL from the Ground Up is the only book you need to get up and running with SQL - in no time.

Learn how to:

• Write queries you can use today
• Design a database project with Access
• Write reports using Access, Business Objects, and Crystal Reports
• Program professional-quality applications in SQL
• Use SQL with Visual C++, Visual Basic, and Java
• Write SQL using the variations found in Oracle, SQL Server 7, and Sybase databases
• Handle errors, troubleshooting, and database security
• Get a heads up on the new SQL 3 standard
• Hit the ground running with SQL!

About the Author

Mary Pyefinch (Pittsburg, CA) is the CEO of Business Intelligence Agency, LLC, which specializes in enterprise reporting, database design, training and documentation. She has more than 12 years experience with clients such as Chevron, Chiron, Wells Fargo Bank, Safeway, PGE.

Product Details

• Paperback: 510 pages
• Publisher: McGraw-Hill Companies (April 1, 1999)
• Language: English
• ISBN-10: 0072119748
• ISBN-13: 978-0072119749
• Product Dimensions: 9.1 x 7.3 x 1.4 inches
• Shipping Weight: 2.2 pounds
• Average Customer Review: 2.7 out of 5 stars  See all reviews (13 customer reviews)
• Amazon Best Sellers Rank: #3,107,478 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

2.0 out of 5 stars Errors abound, February 10, 2000

By 

L. MCGREGOR (Lansdale, PA) - See all my reviews

This review is from: SQL from the Ground Up (Paperback)

After reading just 3 chapters of this text, I was forced to put it to rest. The number of errors, particularly in the examples, were frustrating and confusing. I am an IT professional. My company would never accept work that wasn't as error-free as possible. Obviously, the editors are not placed under similar expectations.

2 of 2 people found the following review helpful:

2.0 out of 5 stars Too many errors!, January 28, 2000

By 

New Student (Southern California) - See all my reviews

This review is from: SQL from the Ground Up (Paperback)

I can't believe this was the required textbook for my "Introduction to Oracle" class. Luckily I had taken an earlier class that covered the basics of SQL, because this book has so many errors in the examples that it can be very confusing. I'm very disappointed in the quality of the proof-reading of this text.

1 of 1 people found the following review helpful:

3.0 out of 5 stars A good book but not the best, July 25, 2001

By 

Milady (TH) - See all my reviews

This review is from: SQL from the Ground Up (Paperback)

This book does not properly match my requirements because I had expected a more advanced book on SQL before I bought this one but it still is an OK book to have. (the title says 'from the group UP' so I thought that it would take me up to be an expert SQL scriptor) It gives me lots of basic SQL commands such as SELECT, INSERT, CREATE TABLE, etc.. but not complex commands to use in real situations. So if you are an SQL novice, this book will do but if you are looking for SQL book for using as a referrence book, try to find another book.