Beginning SQL Queries: From Novice to Professional, 2nd Edition
- Length: 250 pages
- Edition: 2nd ed. 2016
- Language: English
- Publisher: Apress
- Publication Date: 2016-07-19
- ISBN-10: 1484219546
- ISBN-13: 9781484219546
- Sales Rank: #728720 (See Top 100 Books)
Beginning Queries with SQL is a friendly and easily read guide to writing queries with the all-important ― in the database world ― SQL language. Anyone who does any work at all with databases needs to know something of SQL, and that is evidenced by the strong sales of such books as Learning SQL (O’Reilly) and SQL Queries for Mere Mortals (Pearson). Beginning Queries with SQL is written by the author of Beginning Database Design, an author who is garnering great reviews on Amazon due to the clarity and succinctness of her writing.
Table of Contents
Chapter 1: Relational Database Overview
Chapter 2: Simple Queries on One Table
Chapter 3: A First Look at Joins
Chapter 4: Subqueries
Chapter 5: Self Joins
Chapter 6: Multiple Relationships Between Tables
Chapter 7: Set Operations
Chapter 8: Aggregate Operations
Chapter 9: Window Functions
Chapter 10: Efficiency Considerations
Chapter 11: How to Tackle a Query
Chapter 12: Common Problems
Appendix 1: Example Database
Appendix 2: Relational Notation
