Update on 5/20/2019: it is no longer a free book, now available on Amazon, here.
This book is a guide to using SQL to retrieve data from databases. This site includes a 'Practice SQL' environment where you can try out the examples from the book and experiment with SQL queries. This book is available here.
Contents
1. Prerequisites..............4
2. Instructions................4
3. Joining tables.............6
4. SQL ...........................8
5. Single-table operations ..........9
6. Sorting result tables.14
7. Counting rows.........15
8. Summing totals........16
9. Cartesian Joins.........20
10. Retrieving data from multiple tables...........21
11. Distinct values.........25
12. Union.......................27
13. Subqueries...............28
15. NULL values...........31
16. About the Author.....32
17. Appendix A – Implementation variations..........33
18. Appendix B – Summary of operators...........34
19. Appendix C – Other statements ...........35
20. Appendix D – Test environment ...............36
Comment
dead link
The title does appear under "books" but the price has now morphed to $12 there.
PDF is freely found here http://www.markmcilroy.com/downloads/sql_essentials.pdf
The title appears in the section "books", but it's $8, and availble on Amazon (not free as stated).
no book in the link shared
© 2021 TechTarget, Inc.
Powered by
Badges | Report an Issue | Privacy Policy | Terms of Service
Most Popular Content on DSC
To not miss this type of content in the future, subscribe to our newsletter.
Other popular resources
Archives: 2008-2014 | 2015-2016 | 2017-2019 | Book 1 | Book 2 | More
Most popular articles
You need to be a member of Data Science Central to add comments!
Join Data Science Central