ConclusionΒΆ

Congratulations! You now have a well-rounded set of SQL skills that can help you wrangle and analyze the most ornery of datasets. SQL JOINs in particular will help you design well-structured databases and join to other data sets in pursuit of more sophisticated analyses.

Below are some topics we have not yet covered that are worth exploring:

  • The UNION operator, which allows you to combine results from multiple queries
  • Database optimization using indexes
  • Database views, which can be used to store complicated queries as a virtual table

Thanks for working through this tutorial! Please drop us a note on Github if you have thoughts on how the tutorial can be improved.

https://i.creativecommons.org/l/by-nc-nd/3.0/88x31.png

A Gentle Introduction to SQL Using SQLite by Troy Thibodeaux is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.