San Jose State University : Site Name

Navigation

Main Content

Reading to Buddy

Ronald Mak

Department of Computer Engineering
Department of Computer Science
Department of Applied Data Science
Summer Semester 2021

Office hours: None during the summer
Office location: ENG 250 (but working from home)
E-mail: ron.mak@sjsu.edu

MIS Association Summer Technology Workshop:
Relational Databases and SQL Programming


Thursday, July 29, 6:00 - 8:00 PM online via Zoom

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!