What is a relational database?

---

Using DB Browser for SQLite

---

Figure 1

Image 1 of 1: ‘DB Browser run’

---

Figure 2

Image 1 of 1: ‘DB Browser initial screen’

---

Figure 3

Image 1 of 1: ‘Data Browser Preferences’

---

Figure 4

Image 1 of 1: ‘Table Actions’

---

Figure 5

Image 1 of 1: ‘SQL Query results’

---

The Select Statement

---

Missing Data

---

Figure 1

Image 1 of 1: ‘Farms NULLs’

---

Figure 2

Image 1 of 1: ‘Farms_csv’

---

Figure 3

Image 1 of 1: ‘Farms_csv’

---

Creating New Columns

---

Figure 1

Image 1 of 1: ‘Conversion failure’

---

Aggregations

---

Figure 1

Image 1 of 1: ‘Villages’

---

Creating tables and views

---

Figure 1

Image 1 of 1: ‘Import table’

---

Figure 2

Image 1 of 1: ‘Modify Table’

---

The SQLite command line

---

Figure 1

Image 1 of 1: ‘SQLite shell’

---

Figure 2

Image 1 of 1: ‘SQLite shell query example’

---

Figure 3

Image 1 of 1: ‘SQLite shell dot commands’

---

Figure 4

Image 1 of 1: ‘SQLite my.filename’

---

Joins

---

Figure 1

Image 1 of 1: ‘Maize’

---

Figure 2

Image 1 of 1: ‘Maize’

---

Figure 3

Image 1 of 1: ‘Join1’

---

Figure 4

Image 1 of 1: ‘Left Outer Join1’

---

Figure 5

Image 1 of 1: ‘Left Outer Join1’

---

Using database tables in other environments

---

Figure 1

Image 1 of 1: ‘SQL_10_DataSource’

---

Figure 2

Image 1 of 1: ‘SQL_10_No_Tables’

---

Figure 3

Image 1 of 1: ‘SQL_10_Choose_Columns’

---

Figure 4

Image 1 of 1: ‘SQL_10_Choose_Columns_2’

---

Figure 5

Image 1 of 1: ‘SQL_10_return_data’

---

Figure 6

Image 1 of 1: ‘SQL_10_place_data’

---