Preview added to your library
Sams Teach Yourself SQL in 24 Hours By: Ryan Stephens

Sams Teach Yourself SQL in 24 Hours

  • 1
  • 2
  • 3
  • 4
  • 5
Rate this book!

( 0 customer ratings)

In order to rate this item, you must sign in first.

Sams, May 2008

Synopsis

This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version.

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

$21.29 List price: $27.99 You save: 24% ($6.70)

BUY NOW

Sams Teach Yourself SQL in 24 Hours

Sams, May 2008
  • 1
  • 2
  • 3
  • 4
  • 5
( 0 customer ratings)

eBook Information

ISBN: 9780768682762
Language:  English
Download options: Adobe DRM PDF

Files Available for Download

If you use one of Kobo's free reading apps you won't need to worry about download options most of the time. Your Kobo reading app can easily add Kobo Store books to your library for a seamless reading experience.

Download options matter when:

  • You want to read your book on an eReader other than the Kobo eReader (see here for a list of supported eReaders).
  • The book you want is only available as an Adobe DRM PDF.

In both of these cases you will need to:

  1. Download a copy of your book to your computer.
  2. Open the book using a free application called Adobe Digital Editions.

You can also use Digital Editions to transfer the book to your eReader. See here for more information on Digital Editions.

Read this on:

  • Adobe Digital Editions More

    Adobe Digital Editions

    You can read this item using Adobe Digital Editions, a free application. Read on your computer, or use Digital Editions to copy your book to a compatible eReader.

    Get Adobe Digital Editions v1.7.2

    Download Now!
  • eReaders More

    eReaders

    You can read this item on your Kobo eReader or other select eReaders (see a list of supported eReaders). You will need a free application called Adobe Digital Editions to open your book and transfer it to your eReader.

    Get Adobe Digital Editions v1.7.2

    Download Now!

    Download it now for Mac!

    Download App!

    PC user? Click here

Goodreads Reviews for Sams Teach Yourself SQL in 24 Hours

{1}

By: {2}

Available on: {3}

Coming soon

Secure Transaction

Subtotal

Store Credit

Total

We'll charge your credit card {4} on {3}.

We'll charge your credit card {4} when the book is added to your Library.

Your store credit covers the cost of this purchase, so we don't charge your credit card

Use Quick Buy for all eBook purchases.
{0}
By clicking Buy Now, I agree to Kobo's Terms of Sale. BUY NOW Pre-Order

Thank you for your purchase

Thanks for pre-ordering

{2} is now in your library. You'll receive an email confirming your purchase very soon.

{2} has been pre-ordered. You'll receive a confirmation email confirming your pre-order very soon.

You were charged:

You will be charged: on {3}

You will be charged: when the book is added to your Library

Rakuten Super Points earned: {1}

Rakuten Super Points {1} earned after the book is added to your Library

{0}
Continue shopping