ENTR-451 SQL Intro

For educational purposes only.

Instructions

Open an existing database (or create a new database) via SQLite: sqlite3 [DB FILE]
- e.g. sqlite3 baseball.sqlite3*
- alternatively, start a brand new database: sqlite3 my_new_database.sqlite3
View the database schema: .schema
Configure sql output: .read config.sql
Execute sql commands directly via the console
- use a semicolon (;) to complete the command
Save and execute sql commands in *.sql files: .read [SQL FILE]
- e.g. .read demo.sql
Exit SQLite application: .quit

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
.devcontainer		.devcontainer
README.md		README.md
SCHEMA.sql		SCHEMA.sql
baseball.sqlite3		baseball.sqlite3
config.sql		config.sql
demo.sql		demo.sql
lab-1-1.sql		lab-1-1.sql
lab-1-2.sql		lab-1-2.sql
lab-1-3.sql		lab-1-3.sql
lab-2-1.sql		lab-2-1.sql
lab-2-2.sql		lab-2-2.sql
lab-2-3.sql		lab-2-3.sql
lab-3-1.sql		lab-3-1.sql
lab-3-2.sql		lab-3-2.sql
lab-3-3.sql		lab-3-3.sql
lab-4-1.sql		lab-4-1.sql
lab-4-2.sql		lab-4-2.sql
lab-4-3.sql		lab-4-3.sql
lab-4-4.sql		lab-4-4.sql
school-1-create.sql		school-1-create.sql
school-2-drop-and-create.sql		school-2-drop-and-create.sql
school-3-alter-add-column.sql		school-3-alter-add-column.sql
school-4-alter-drop-column.sql		school-4-alter-drop-column.sql
school-5-insert.sql		school-5-insert.sql
school-6-update.sql		school-6-update.sql
school-7-delete.sql		school-7-delete.sql
school-8-insert-again.sql		school-8-insert-again.sql
school-lab.sql		school-lab.sql
school.sqlite3		school.sqlite3