Product Description

In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up.

Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL.

Step-by-step instructions carefully walk you through the most common SQL tasks.

Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge.

Notes and Tips point out shortcuts and solutions.

New terms are clearly defined and explained.

Learn how to…

• Use SQL-2003, the latest standard for the Structured Query Language
• Design and deploy efficient, secure databases
• Build advanced queries for information retrieval
• Sort, group, and summarize information for best presentation
• Tune databases and queries for maximum performance
• Understand database administration and security techniques

For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems.

Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University—Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems.

Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles.

Category: Database

Covers: ANSI SQL

User Level: Beginning—Intermediate

Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections

as they become available.

$34.99 USA / $ 37.99 CAN / £ 24.99 Net UK

Product Details

• Amazon Sales Rank: #70815 in Books
• Published on: 2008-06-12
• Original language: English
• Number of items: 1
• Binding: Paperback
• 504 pages

From the Back Cover

In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up.

Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL.

Step-by-step instructions carefully walk you through the most common SQL tasks.

Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge.

Notes and Tips point out shortcuts and solutions.

New terms are clearly defined and explained.

Learn how to…

• Use SQL-2003, the latest standard for the Structured Query Language
• Design and deploy efficient, secure databases
• Build advanced queries for information retrieval
• Sort, group, and summarize information for best presentation
• Tune databases and queries for maximum performance
• Understand database administration and security techniques

For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems.

Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University—Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems.

Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles.

Category: Database

Covers: ANSI SQL

User Level: Beginning—Intermediate

Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections

as they become available.

$34.99 USA / $ 37.99 CAN / £ 24.99 Net UK

About the Author

For more than 10 years, the authors have studied, applied, and documented the SQL standard and its application to critical database systems in this book. Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm. PTI specializes in database technologies, primarily Oracle and SQL servers running on all Unix, Linux, and Microsoft platforms. Starting out as data analysts and database administrators, Ryan and Ron now lead a team of impressive technical subject matter experts who manage databases for clients worldwide. They authored and taught database courses for Indiana University-Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and high availability of critical systems.

Arie D. Jones is Senior SQL Server database administrator and analyst for Perpetual Technologies, Inc. (PTI) in Indianapolis, Indiana. Arie leads PTI’s team of experts in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. He is a regular speaker at technical events and has authored several books and articles pertaining to database-related topics. The most recent is SQL Functions Programmer’s Reference from Wrox Publishing.

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.

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!

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...