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
Donate to keep this site alive
How to download source code?
1. Go to: https://github.com/Apress
2. In the Find a repository… box, search the book title: Beginning SQL Queries: From Novice to Professional, 2nd Edition
, sometime you may not get the results, please search the main title.
3. Click the book title in the search results.
3. Click Code to download.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.