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
Videos
- How Databases Work (18:57)
- Introduction to Structured Query Language (SQL) (11:45)
- Demonstration: Basic SQL (6:36)
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: Basic SQL (Login Required)