Tarball has scripts to walk through the presentation.
IMDB data, messed it up to make it more inefficient. Available with attribution
Walk through the data doing work as if a DBA
List off some RDBMs.
Imported the CSV data
The schema that was created was the default based on the CSV file.
Convention of uppercasing the SQL keywords
- specify column by number or name
SELECT from the results of a
Normalization of data
Separate the table and normalize
Talk about temp tables
INSERT INTO table from SELECT
substr(), '||' (concat operator) Arrays in SQL are 1-based
INSERT into a new table with primary key
CREATE INDEX for some columns on table
AS on table name as well as columns
Removing title by building new table
Move person information into people table. Move role information Move show information
SELECT with multiple joins to replace the strings
with the appropriate ids. This is pretty complicated, but understandable.
Foreign key logic
We had 6 people attending the remote meeting (YouTube streaming) this month.