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: 7257

Comment

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

Join Data Science Central

Comment by Jean-Charles Forszpaniak on Thursday

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

Follow Us

Videos

  • Add Videos
  • View All

Resources

© 2017   Data Science Central   Powered by

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