Product Description

Written by college instructors, Sams Teach Yourself SQL in 24 Hours quickly teaches beginning- to intermediate-level SQL users how to create, store, access and manipulate data using a proven step-by-step format that teaches SQL by example. This book contains a thorough explanation of database concepts, SQL procedures, and low-level programming, enabling readers to gain an understanding of the whys as well as the hows behind SQL.

This book presents complete code listings and output, followed with analysis that explains exactly what the listings are doing. These practical code examples can be incorporated easily by the reader into other projects. Coverage includes SQL, as well as SQL in an enterprise setting and on the Web and Intranet.

Authors Ryan Stephens and Ronald Plew are President and Vice President of Perpetual Technologies, Inc., where their duties include Oracle database administration and consulting and Oracle, SQL, and UNIX training. They have both been teaching at the collegiate level for over three years as adjunct professors at Indiana University-Purdue University in Indianapolis. Both are Oracle Certified Professionals, having specialized in Oracle and UNIX for more than 10 years each.

Product Details

• Amazon Sales Rank: #476816 in Books
• Published on: 2000-04-17
• Original language: English
• Number of items: 1
• Binding: Paperback
• 439 pages

From the Back Cover

Sams Teach Yourself SQL in 24 Hours, Second Edition

Learn how to...

• Build and manage relational database objects;
• Effectively query the database;
• Master functions and clauses to query data;
• Manage database transactions;
• Summarize data with views;
• Uncover ways to summarize, sort and group, and restructure the appearance of data;
• Performance tune SQL statements;
• Use SQL to implement database security.

Get Started Now!
24 proven one-hour lessons

In just 24 sessions of one hour or less, you will be up and running with SQL. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of SQL from the ground up.

• Tips point out shortcuts and solutions;
• Notes clarify concepts and procedures in a straightforward manner;
• Cautions help you avoid common pitfalls.

  Ryan Stephens and Ronald Plew are President and Vice President of Perpetual Technologies, Inc., where their duties include Oracle database administration and consulting and Oracle, SQL, and UNIX training. They have both been teaching at the collegiate level for over three years as adjunct professors at Indiana University-Purdue University in Indianapolis. Both are Oracle Certified Professionals, having specialized in Oracle and UNIX for more than 10 years each. Ryan and Ron have co-authored other books for Sams including Sams Teach Yourself SQL in 21 Days, Second Edition and Third Edition, Oracle Unleashed, Second Edition, Oracle Development Unleashed, and Oracle8 Server Unleashed.

About the Author

Ronald R. Plew is vice president and CIO for Perpetual Technologies, Inc., in Indianapolis, Indiana. Ron is a Certified Oracle Professional, and his duties include Oracle database consulting and training. Ron is an adjunct professor at Indiana University-Purdue University in Indianapolis and Indiana University at Kokomo, where he teaches SQL and various database courses. He holds a Bachelor of Science degree in Business Management/Administration from Indiana Institute of Technology, Fort Wayne, Indiana. Ron also serves in the Indiana Army National Guard, where he is the programmer/analyst for the 433rd Personnel Detachment. Ron's hobbies include golf, chess, and collecting Indianapolis 500 racing memorabilia. He shares ownership of Plew's Indy 500 Museum with is brothers, Mark and Dennis; his sister Arleen; and mother, Betty. Ron lives in Indianapolis with his wife Linda. Ron and Linda have four children and nine grandchildren.

Ryan K. Stephens is president and CEO for Perpetual Technologies, Inc., an Oracle training and consulting firm in Indianapolis, Indiana, that is partnered with Oracle Corporation. He has specialized in Oracle database and SQL for over 10 years, working as an Oracle programmer/analyst and Oracle Database Administrator. Ryan is a Certified Oracle Professional and is also an adjunct professor at Indiana University-Purdue University in Indianapolis and Indiana University at Kokomo, where he teaches SQL, PL/SQL, UNIX, Oracle Designer, Oracle Forms, and Oracle database administration. Ryan resides in Indianapolis with his wife Tina and their son Daniel.

Customer Reviews

Obvious Mistakes Make For A Difficult Read
This book is sadly not much use to a beginner of SQL. There are numerous errors throughout, especially in the examples which don't tally with the relevant text making the examples very difficult. Unfortunately, there are no corrections at the SAMS website either.

If you are looking for your first SQL book, then you would be better off looking elsewhere.

Full of mistakes which will confuse a Beginner
This was my first computer language to learn, and this book made sure I did it the hard way. It is full of mistakes and examples that do not demonstrate what they claim to. I threw the book away and bought another one. Don't buy this book, you'll regret it...

Nice book for Starting SQL
the book is great for anyone wishing to learn SQL like me; the book is maily set out for the Oracle SQL standard. But it covers MySQL, Microsoft and parts of dBase. The main problem with the book it that the number of times you come across errors and mistakes is just to many you could expect. i feel that if the 3rd edition of the book could be proof read so that you could understand it better , it would make a great read.

This book is set out so you can learn SQL (the basics) in 24 hours, but it feels like the book was written in 24 hours!