Sams Teach Yourself SQL in 24 Hours

Nonfiction, Computers, Programming, Programming Languages, SQL, Database Management
Cover of the book Sams Teach Yourself SQL in 24 Hours by Ryan Stephens, Ron Plew, Arie D. Jones, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Ryan Stephens, Ron Plew, Arie D. Jones ISBN: 9780132715126
Publisher: Pearson Education Publication: May 30, 2008
Imprint: Sams Publishing Language: English
Author: Ryan Stephens, Ron Plew, Arie D. Jones
ISBN: 9780132715126
Publisher: Pearson Education
Publication: May 30, 2008
Imprint: Sams Publishing
Language: English

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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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…

 

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.

More books from Pearson Education

Cover of the book Adobe Photoshop Lightroom 2 Classroom in a Book by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Real World Adobe Photoshop CS4 for Photographers by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book The Truth About Making Better Decisions by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Getting Investment Leverage in the Markets by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Where Does Social Security Fit Into Your Retirement? by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Computer Security Fundamentals by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Trading Techniques and Pitfalls That All Investors Should Know by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Communication Gaps and How to Close Them by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Introduction to Adobe Creative Cloud by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Essential GWT by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book The Design Method by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book The Truth About Protecting Your IRAs and 401(k)s by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Core HTML5 Canvas by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book How to be a Brilliant Manager by Ryan Stephens, Ron Plew, Arie D. Jones
Cover of the book Sams Teach Yourself Django in 24 Hours by Ryan Stephens, Ron Plew, Arie D. Jones
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy