The Complete SQL Queries Training Course [Hardcover]

Michael J. Hernandez (Author), John L. Viescas (Author)

Book Description

ISBN-10: 0130897272 | ISBN-13: 978-0130897275 | Publication Date: December 27, 2000

Now you can learn SQL hands-on -- and get the business information you need, faster than you ever imagined! No matter what database you use, you'll master ANSI standard SQL by practicing with hundreds of live queries and exercises -- and learning from hours of animations and audio commentary by two world-renowned database consultants! This package brings together the industry's #1 interactive SQL training CD-ROM, the SQL Multimedia Cyber Classroom, with the world's best SQL book for business professionals, SQL Queries for Mere Mortals -- provided in both hard copy and electronic format. Working with over 300 practice queries and five real-world sample databases, you'll master every business SQL skill you need: grouping, totaling, summaries, modifying databases, integrating data from multiple tables -- even advanced, high-performance SQL techniques. Test your knowledge with 100+ interactive questions; gain insight from hours of audio commentary by expert database consultants; and more. Full of plain-English guidance and useful examples, the SQL Multimedia Cyber Classroom is the fastest way to achieve real business results with SQL.

Editorial Reviews

From the Back Cover

• The fastest, easiest way to master SQL-no experience required!
• Master every business SQL skill you need! Grouping, totaling, summaries, modifying databases, integrating data from multiple tables, and much more!
• Includes video introduction, 2+ hours of expert audio commentary, 200+ animated figures, 100+ self-review questions, 100+ exercises, searching, hyperlinking, and more.

Now you can learn SQL hands on—and get the business information you need, faster than you ever imagined! This package brings together the industry's #1 interactive SQL training CD-ROM, the SQL Queries Multimedia Cyber Classroom, with the world's best SQL book for business professionals, SQL Queries for Mere Mortals! No matter what database you use, you'll master SQL by practicing with hundreds of live queries and exercises—and learning from hours of animations and audio commentary by two world-renowned database consultants!

• Over 200 animated figures, with expert audio commentary, illustrate key concepts
• Learning SQL is just one click away! With our state-of-the-art, interactive, multimedia CD-ROM
• Includes a fully searchable version of SQL Queries for Mere Mortals
• Test your knowledge with 100+ self-review questions and 100+ practice exercises
• BONUS: SECOND CD-ROM contains five real-world sample databases designed to support virtually any practice query.
• Starts from scratch! No unnecessary jargon: just plain-English help and useful examples!
• Real-world focus: Solutions for the problems businesspeople really encounter.
• Up to date! Covers the latest ANSI standard SQL—skills apply to virtually any current desktop or enterprise database!
• Includes advanced, high-performance techniques for solving even complex SQL problems.
• 100% Comprehensive, 100% Business-Focused

The Complete SQL Queries Training Course covers everything you need to know to succeed with SQL, including concepts, syntax, troubleshooting techniques, performance optimization, and more:

• Basic relational database concepts
• Fundamental SQL concepts
• SELECT statements
• Creating expressions
• Applying filters
• Working with joins
• Integrating data from multiple tables
• Grouping data
• Totaling data
• Summarizing data
• Updating data
• Inserting data
• Deleting data
• And much more — including advanced techniques!

Requirements

Windows(r) 95/98/2000/NT(r) 4.0Internet Explorer (included)20 MB disk space32 MB RAMCD-ROM driveSound card support

About the Author

Michael J. Hernandez is a top-rated Microsoft Access instructor, owner of DataTex Consulting Group in Seattle, WA, and author of the best-selling Database Design for Mere Mortals. John L. Viescas is President of Viescas Consulting, Inc., and author of the classic Quick Reference Guide to SQL.

Product Details

• Hardcover: 1 pages
• Publisher: Prentice Hall PTR (December 27, 2000)
• Language: English
• ISBN-10: 0130897272
• ISBN-13: 978-0130897275
• Product Dimensions: 9.7 x 7.4 x 2.8 inches
• Shipping Weight: 2.2 pounds
• Average Customer Review: 2.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #3,685,013 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

29 of 29 people found the following review helpful:

3.0 out of 5 stars Overpromises and Under-delivers, November 14, 2001

By 

335 "335" (Anywhere, United States) - See all my reviews

This review is from: The Complete SQL Queries Training Course (Hardcover)

I was originally going to purchase only the book - "SQL Queries for Mere Mortals". However, when I noticed that this set packaged the book with a Multimedia CD, I thought it offered the best of 2 worlds: (1) the book as a reference; and (2) the multimedia guide to pull me through the materials. The book is good. The CD-ROM under-delivers. First, it will not install on a Windows ME system. It does install on Win98. The CD has 5 parts: (1) static Web pages where you read information; (2) Assessments that allow you to test your knowledge of a subject (I liked this feature); (3) "Multimedia segments" -- no video, instead an audio file plays, a cryptic diagram shows on a pop-up Web page, and you see a section of code (this was the greatest disapointment -- after all -- when you hear "multimedia" you think video training or something with more pizzazz); (4) Search feature; (5) Resources -- all 3 of them -- the user guide, the book that you already bought as part of the package, and the credits.

Perhaps if you have the right expectation, this will be a good resource. Afterall, the book and the online assessment is good. However, I would purchase the book separately and save the money on the "multimedia" CD.

11 of 11 people found the following review helpful:

1.0 out of 5 stars Don't waste your money, August 28, 2004

By 

scg "scg" (Colorado Springs, CO, USA) - See all my reviews

Amazon Verified Purchase

This review is from: The Complete SQL Queries Training Course, Student Edition (Paperback)

First off Amazon won't let anyone give minus stars! I should have listened to "thestudent" review. The book is great but the software is as funcitonal as the nipples on a man's chest. It will not run on XP Pro with SP2 installed. The new pop up blocker M$ has installed can't be turned off and blocks all of the alleged multimedia. I went to the publishers website and guess what....they haven't updated a darn one of their "Interactive" products since 2001!!!!! Hello here its 2004. The book is great the software belongs in the trash! Get the book....burn the software. Mr. Hernandez get a new publisher or have them pull this product. Quite frankly your veracity is on the line for not having having an updated verson nor getting the publisher to advise potential buyers of what I have mentioned.