SQL for SQLite

Abstract

Congratulations, you have learned the select command for SQLite’s implementation of SQL. Not only have you learned how the command works, but you’ve learned some relational theory in the process. You should now be comfortable with using select statements to query your data, join, aggregate, summarize, and dissect it for various uses.

We’ll continue the discussion of SQL in the next chapter, where we’ll build on your knowledge of select by introducing the other members of DML, as well as DDL and other helpful SQL constructs in SQLite.