July 29 |
Slides:
What is data? structured vs. unstructured data; What is
information? What is a database? database application
architecture; relational databases; table structure;
primary key; foreign keys; database queries; one-to-one,
one-to-many, many-to-many relationships; introduction to
SQL; SQL syntax; table joins; how queries work;
update, insert, and delete table rows; create and remove
tables; export and import tables; further study of tables;
database design; entity-relationship diagrams; conceptual,
logical, and physical models
Example "school" database: school.sql |
Query practice website
See queries made against the "school" database tables. See the SQL codes that implement the queries. Practice writing your own SQL code! |