1.
Introduction
Software Installation
Some Definitions
DB Browser for SQLite
2.
Working with a Database
Opening the staff database
Creating a Database
Saving your changes
3.
SQL
What is SQL?
The Select Statement
Solution to Exercise 1
The Where Clause
Solution to Exercise 2
Sorting Results
Aggregation
Joins
Views
4.
Import/Export
Import / Export a Database
Export to CSV
Create Database from CSV
More SQL
5.
Resources
Useful Links
Tutorial Files
Clear History
Built with
Grav
- The Modern Flat File CMS
Chapter 3
Structured Query Language
Objectives
SQL definition
Understand how to use SQL to access data
Create simple SQL queries