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.
A Gentle Introduction to SQL Using SQLite by Troy Thibodeaux is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.