This chapter provided you with the steps to handle databases in QGIS. While QGIS can handle multiple databases, we used SpatiaLite as it provides a good amount of functionality with little overhead or administration.
Using the DB Manager you can perform a number of operations on databases. Operations of note are: creating indices, spatial and aspatial views, importing and exporting, and performing queries. From the introduction to DB Manager and SpatiaLite in this chapter, you are now well-equipped to write more complex queries that take full advantage of the SQL commands and SpatiaLite SQL extension commands. A full listing of SQLite SQL commands are available at http://www.sqlite.org/lang.html. A full listing of the SpatialLite SQL extension commands are available at http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html.
The next chapter moves us from the storage of geospatial data to the display of geospatial data. The styling capabilities of QGIS will be covered for both vector...