Table of Contents
INTRODUCTION ................................................................................................... 1
| 1 | UNDERSTANDING DATABASE STRUCTURE .................................................13
| 2 | SQL TOOLS AND STRATEGIES ......................................................................33
| 3 | EXPLORING A DATABASE IN SQLITE ...........................................................39
| 4 | GETTING STARTED WITH QUERIES ..............................................................51
| 5 | TURNING DATA INTO INFORMATION ..........................................................65
| 6 | WORKING WITH MULTIPLE TABLES .............................................................91
| 7 | USING FUNCTIONS ....................................................................................115
| 8 | SUBQUERIES ............................................................................................... 145
| 9 | VIEWS ......................................................................................................... 157
| 10 | DATA MANIPULATION LANGUAGE (DML) ............................................... 167
CONCLUSION .................................................................................................... 175
APPENDIX I .......................................................................................................183
APPENDIX II ......................................................................................................203
ABOUT THE AUTHOR ........................................................................................213
ABOUT CLYDEBANK MEDIA .............................................................................215
GLOSSARY .........................................................................................................217
REFERENCES .....................................................................................................221
INDEX ................................................................................................................223