Sams Teach Yourself SQL in 24 Hours (4th Edition) and over 2 million other books are available for Amazon Kindle . Learn more

Trade in Yours
For a 0.25 Gift Card
Trade in
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Sams Teach Yourself SQL in 24 Hours (4th Edition) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Sams Teach Yourself SQL in 24 Hours [Paperback]

Ryan Stephens , Ron Plew , Arie D. Jones
4.0 out of 5 stars  See all reviews (2 customer reviews)

Available from these sellers.


Formats

Amazon Price New from Used from
Kindle Edition 15.66  
Paperback --  
Paperback, 30 May 2008 --  
Trade In this Item for up to 0.25
Trade in Sams Teach Yourself SQL in 24 Hours for an Amazon Gift Card of up to 0.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
There is a newer edition of this item:
Sams Teach Yourself SQL in One Hour a Day (Sams Teach Yourself...in One Hour) Sams Teach Yourself SQL in One Hour a Day (Sams Teach Yourself...in One Hour)
31.10
In stock.

Book Description

30 May 2008 0672330180 978-0672330186 4

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.


Product details

  • Paperback: 504 pages
  • Publisher: Sams; 4 edition (30 May 2008)
  • Language: English
  • ISBN-10: 0672330180
  • ISBN-13: 978-0672330186
  • Product Dimensions: 2.8 x 16.9 x 23.1 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 653,991 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

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.

 


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

5 star
0
3 star
0
2 star
0
1 star
0
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
4.0 out of 5 stars Very good 2 Jun 2013
By U. Sule
Format:Paperback|Verified Purchase
Taught me everything I needed to know to pass my exams, and has a great deal more. There are many examples and it is quite a light book to read.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars Basic Introduction 20 May 2009
Format:Paperback
This book is a low level introduction to sql. It keeps it language simple and will allow the user to become proficient in sql. It suffers from it's simplicity with some of the explanations of complex ideas like types being less than correct.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.0 out of 5 stars  1 review
1 of 2 people found the following review helpful
4.0 out of 5 stars Review of SQL 14 Sep 2009
By Edwin D. Dodson - Published on Amazon.com
Format:Paperback
The book is very helpful. I like the way it is layed out and it is a great help to me. I reference it quiet often to see how to do a specific thing in my code.
Was this review helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback