BIBLIO is the largest independent book marketplace in the world, with over 100 million books.

Skip to content

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL Paperback - 2014 - 3rd Edition

by Hernandez, Michael J

Add to wish list
  • Used
  • very good
  • Paperback
Used - Very good

Description

Paperback. Very Good.
Ask the seller a question Add to wish list
A$11.65
A$16.53 Delivery to USA
Standard delivery: 7 to 40 days
More delivery options
Ships from World of Books Ltd (West Sussex, United Kingdom)

Details

About World of Books Ltd West Sussex, United Kingdom

Biblio member since 2007

In 2002, World of Books was founded on an ethos to do good, protect the planet, and support charities by enabling more goods to be reused. Since then, we've grown into a global pioneer, dedicated to helping people read more and waste less. Through the World of Books brand, customers can now buy and sell with us! We provide affordable, preloved books to book lovers all around the world, while also giving people the opportunity to contribute to the circular economy, earn money and protect the planet by trading in their unwanted books and media for cash. Through the B2B side of our business we've developed technology to help charities sell in bulk, meaning they can clear much needed floor space and make money for great causes at the same time. A new book will be sold once but their stories can be enjoyed by more than one owner. After all, a story doesn't change because it's been read before!

Terms of Sale:

If you are not completely satisfied with your purchase for any reason, simply email customerservice@worldofbooks.com and we will quickly resolve any issues you may have. If you have any other queries about your order, please email customerservice@worldofbooks.com. Our goal is to deliver to our customers the best possible service and we hope your experience of dealing with us lives up to our promise. If for whatever reason we fail to meet your expectations then please let us know.

Browse books from World of Books Ltd

Reader reviews for SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

From the publisher

The #1 Easy, Common-Sense Guide to SQL Queries--Updated for Today's Databases, Standards, and Challenges

SQL Queries for Mere Mortals (R) has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques.

Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data.

Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You'll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think "outside the box" using unlinked tables.

Coverage includes

-- Getting started: understanding what relational databases are, and ensuring that your database structures are sound

-- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE

-- Summarizing and grouping data with GROUP BY and HAVING clauses

-- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries

-- Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more

Practice all you want with downloadable sample databases for today's versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you're a DBA, developer, user, or student, there's no better way to master SQL.

informit.com/aw

forMereMortals.com

About the author

John L. Viescas is an independent database consultant with more than 45 years of experience. He began his career as a systems analyst, designing large database applications for IBM mainframe systems. He spent 6 years at Applied Data Research in Dallas, Texas, where he directed a staff of more than 30 people and was responsible for research, product development, and customer support of database products for IBM mainframe computers. While working at Applied Data Research, John completed a degree in business finance at the University of Texas at Dallas, graduating cum laude.

John joined Tandem Computers, Inc., in 1988, where he was responsible for the development and implementation of database marketing programs in Tandem's U.S. Western Sales region. He developed and delivered technical seminars on Tandem's relational database management system, NonStop SQL. John wrote his first book, A Quick Reference Guide to SQL (Microsoft Press, 1989), as a research project to document the similarities in the syntax among the ANSI-86 SQL standard, IBM's DB2, Microsoft's SQL Server, Oracle Corporation's Oracle, and Tandem's NonStop SQL. He wrote the first edition of Running Microsoft Access (Microsoft Press, 1992) while on sabbatical from Tandem. He has since written four editions of Running, three editions of Microsoft Office Access Inside Out (Microsoft Press, 2003, 2007, and 2010-the successor to the Running series), and Building Microsoft Access Applications (Microsoft Press, 2005).

John formed his own company in 1993. He provides information systems management consulting for a variety of small to large businesses around the world, with a specialty in the Microsoft Access and SQL Server database management products. He maintains offices in Nashua, New Hampshire, and Paris, France. He has been recognized as a "Most Valuable Professional" (MVP) since 1993 by Microsoft Product Support Services for his assistance with technical questions on public support forums. He set a landmark 20 consecutive years as an MVP in 2013.

You can visit John's Web site at www.viescas.com or contact him by e-mail at john@viescas.com.

Michael J. Hernandez has been an independent relational database consultant specializing in relational database design. He has more than 20 years of experience in the technology industry, developing database applications for a wide variety of clients. He's been a contributing author to a wide variety of magazine columns, white papers, books, and periodicals, and is coauthor of the best-selling SQL Queries for Mere Mortals.

Mike has been a top-rated and noted technical trainer for the government, the military, the private sector, and companies throughout the United States. He has spoken at numerous national and international conferences, and has consistently been a top-rated speaker and presenter.

Aside from his technical background, Mike has a diverse set of skills and interests that he also pursues, ranging from the artistic to the metaphysical. His greatest interest is still the guitar, as he's been a practicing guitarist for more than 40 years and played professionally for 15 years. He's also a working actor, a great cook, loves to teach (writing, public speaking, music), has a gift for bad puns, and even reads Tarot cards.

He says he's never going to retire, per se, but rather just change whatever it is he's doing whenever he finally gets tired of it and move on to something else that interests him.

tracking-