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

📥 Download PDF

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

by Viescas, John L

Programming

Book Details

Book Title

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

Author

Viescas, John L

Publisher

Addison-Wesley Professional City: Boston

Publication Date

2018

ISBN

9780134858357

Number of Pages

1022

Language

English

Format

PDF

File Size

21.6MB

Subject

programming,sql-queries

Table of Contents

Introduction
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
III: WORKING WITH MULTIPLE TABLES
Chapter 7: Thinking in Sets
Chapter 8: INNER JOINs
Chapter 9: OUTER JOINs
Chapter 10: UNIONs
Chapter 11: Subqueries
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
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: Partitioning Data into Windows
In Closing
PART VII: APPENDICES
Appendix A: SQL Standard Diagrams
Appendix B: Schema for the Sample Databases
Appendix C: Date and Time Types, Operations, and Functions
Appendix D: Suggested Reading
Index