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
$68.50 NZD

Price Reduced From: $91.33 NZD

Free delivery

Details

  • A print text
  • Free shipping

This product is expected to ship within 10-12 business days for New Zealand customers

Products list
$68.50 NZD

Price Reduced From: $91.33 NZD

Free delivery

Details

  • A print text
  • Free shipping

This product is expected to ship within 10-12 business days for New Zealand customers

Title overview

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.

Table of contents

  • 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