SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th edition

Published by Addison-Wesley Professional (January 31, 2018) © 2018

  • John L. Viescas
Products list
Products list

This product is expected to ship within 5-7 business days for Australian customers.

SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and will prove an essential reference guide for intermediate and advanced users. Step by step, John L. Viescas guides you through creating reliable queries for virtually any modern SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data.

The full text downloaded to your computer

With eBooks you can:

  • search for key concepts, words and phrases
  • make highlights and notes as you study
  • share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you'll gain instant access to this eBook.

Time limit

The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.

  • Part I: Relational Databases and SQL
  • Chapter 1: What Is Relational?
  • Chapter 2: Ensuring Your Database Structure Is Sound
  • Chapter 3: A Concise History of SQL
  • Part II: SQL Basics
  • Chapter 4: Creating a Simple Query
  • Chapter 5: Getting More Than Simple Columns
  • Chapter 6: Filtering Your Data
  • Part III: Working with Multiple Tables
  • Chapter 7: Thinking in Sets
  • Chapter 8: INNER JOINs
  • Chapter 9: OUTER JOINs
  • Chapter 10: UNIONs
  • Chapter 11: Subqueries
  • Part IV: Summarizing and Grouping Data
  • Chapter 12: Simple Totals
  • Chapter 13: Grouping Data
  • Chapter 14: Filtering Grouped Data
  • Part V: Modifying Sets of Data
  • Chapter 15: Updating Sets of Data
  • Chapter 16: Inserting Sets of Data
  • Chapter 17: Deleting Sets of Data
  • PART VI Introduction to Solving Tough Problems
  • Chapter 18 “NOT” And “AND” Problems
  • Chapter 19 Condition Testing
  • Chapter 20 Using Unlinked Data and “Driver” Tables
  • Chapter 21 Performing Complex Calculations on Groups
  • Chapter 22: More SQL Server Complex Problems to Solve
  • APPENDICES
  • Appendix A: SQL Standard Diagrams
  • Appendix B: Schema for the Sample Databases
  • Appendix C: Date and Time Functions
  • Appendix D: Suggested Reading

 

Need help? Get in touch