Part I

• Hello SQL!
• Installing DB Browser for SQLite
• Creating the First Database
• Creating a Table
• Inserting Data
• Querying Data
• Using DISTINCT to get a distinct set
• The WHERE Clause
• Combining conditions with AND and OR
• Sorting results with ORDER BY
• Changing values with UPDATE
• Deleting data
• Further References

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