Subscribe to DSC Newsletter

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

  • Selecting columns..9
  • Selecting rows......12

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

  • Updating data ..........29
  • Inserting records ...........29
  • Updating records ..........29
  • Deleting records ...........30

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

Views: 15304

Comment

You need to be a member of Data Science Central to add comments!

Join Data Science Central

Comment by Ram Pakath on August 3, 2018 at 5:54pm

The title does appear under "books" but the price has now morphed to $12 there. 

Comment by Prayson Wilfred Daniel on December 12, 2017 at 10:57am
Comment by Jean-Charles Forszpaniak on November 15, 2017 at 11:38pm

The title appears in the section "books", but it's $8, and availble on Amazon (not free as stated).

Comment by Sushant on November 1, 2017 at 10:05am

no book in the link shared

Videos

  • Add Videos
  • View All

Follow Us

© 2018   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service