4: Basic SQL

This is a quick look at databases in general and the basic operations (CRUD) in Structured Query Language (SQL). We don't go too far into SQL because we will be using Django's model capabilities to build the databases for our application.

Slides

• SQL-01-Basics.pptx

Videos

References

• Sample SQLite Command Line Operations (SQL-01-Basics.txt)
• PythonAnywhere
• Liz Fong: Creating the SQL Database Standards
• Documentation: Command Shell for SQLite
• SQLite Browser

Discussions

• Basic SQL (Login Required)
  

Tools

• Quiz: SQL (Login Required)
  
• Auto-grader: Select User with WHERE Clause (Login Required)
  
• Auto-grader: Command Line SQL (Login Required)