Advancing Indigenous Language Technologies
Databases dev
Initializing search
arizona-linguistics/ailt
Advancing Indigenous Language Technologies
arizona-linguistics/ailt
This Site
Salt River Workshop
Salt River Workshop
Prepare
Prepare
Start
Start
Refine
Refine
Imagine
Imagine
CoLang Workshop
CoLang Workshop
First Steps
First Steps
Day 1
Day 1
Day 2
Day 2
Day 3
Day 3
Day 4
Day 4
Tutorials
Tutorials
What's a Database? The Basics
From Spreadsheets to Databases
Create a Database and Build a Table with SQL
Create Tables and Load the Data from a Spreadsheet
Create Rows using INSERT
Retrieve Data using SELECT
The SQL WHERE clause
Order (Sort) Data with ORDER BY
Read a Range of Data - LIMIT and OFFSET
Indexes - Optimize Queries
Connect Tables with SQL JOINs
Connect Tables with SQL JOINs
Create Connected Tables
Read Connected Data
Primary and Foreign Keys
Update Data - UPDATE
Delete Data - DELETE
Insert, Update, and Delete Under Constraints
Databases dev