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’