SQL Faculty Demo

This is another SQL demo that illustrates the process of designing tables and creating complex SELECT statements from those tables to get different views of the data. The primary table we want to create is as follows:

name	email	twitter	courses
Greg Benson	benson@usfca.edu	@gregorydbenson	CS 315, CS 326
David Guy Brizan	dgbrizan@usfca.edu	@davidguybrizan	CS 245
Sophie Engle	sjengle@usfca.edu	@sjengle	CS 212, CS 360
Jeffrey Johnson	jajohnson9@usfca.edu		CS 107, CS 110, CS 490
Kristin Jones	kjones12@usfca.edu		CS 107, CS 345
Alark Joshi	apjoshi@usfca.edu	@alark	CS 110, CS 112, CS 360
EJ Jung	ejung2@usfca.edu		CS 112, CS 245
Olga Karpenko	okarpenko@usfca.edu		CS 112, CS 212, CS 245, CS 490
Matthew Malensek	mmalensek@usfca.edu	@MatthewMalensek	CS 220, CS 326
Peter Pacheco	peter@usfca.edu		CS 220, CS 315, CS 411
Terence Parr	tjparr@usfca.edu	@the_antlr_guy	CS 345
Vahab Pournaghshband	vpournaghs@usfca.edu		CS 221, CS 336
Sami Rollins	snrollins@usfca.edu	@samirollins	CS 112, CS 212
David Wolber	wolberd@usfca.edu	@wolberd	CS 107, CS 110, CS 112
Beste Yuksel	byuksel@usfca.edu	@BesteFYuksel	CS 107, CS 110, CS 490

Create Tables

SQL Faculty Demo: Create Tables

Select Statements

SQL Faculty Demo: Select Statements