Archive for December, 2009
Tonight: introduction to SQL databases!
Posted by whisk in Uncategorized on December 7th, 2009
Hello all! Quick update for you. Here’s an email from Linda Mahoney, a member who is putting on an introductory database class tonight.
There isn’t a time listed on the ENTS calendar for the talks to start
tonight, so I’m going with 6:30pm based on past events.
Agenda
========================
This is a two-hour presentation split into two sections:
Hour 1: Introduction to SQL and Databases
No prior knowledge of SQL or databases is assumed.
Topics covered:
- what databases are and what they are good for
- brief survey of popular relational database management systems (RDMS)
- SQL tutorial (SELECT, INSERT UPDATE, DELETE) based on W3Schools:
http://www.w3schools.com/sql/sql_intro.asp
- Q & A (15 minutes)
Hour 2: Intermediate SQL and RDMS topics
Minimal experience with querying, creating, or managing databases is
assumed.
Topics covered:
- simple database creation and design (CREATE and ALTER statements)
- database normalization
- may vary according to attendees’ wishes
- Q & A (15 minutes)
========================
As an experiment, I’m going to try running this as a DimDim conference
for those who can’t make it in person. To join, go to
http://www.dimdim.com/registration/Dimdim_join.html and enter meeting
room ‘lmahoney’. There is a maximum of 20 participants.
The keyword is ‘experiment’, as in, ‘this may not work’. Showing up in
person is the safer bet if you really want to see this presentation.
Linda Mahoney
