11:30AM Seminars for April 20, 27,
May and June of 2011

Intelligent Technologies Seminar Series

From 11:30AM to 1PM, Click here for details



Evening Tutorial for April 27 2011

"Relational Databases".

(SEE SLIDES)

Speaker

Tim Gustafson
Webmaster at Jack Baskin School
of Engineering at UC Santa Cruz


Date: Wed, April 27, 2011
        6:30pm: Refreshments, Food, and Social Time
        7:00pm: Technical Presentation
Cosponsored by: IEEE UCSC Student Chapter (more) and CITRIS
Place:Simularium Room at the University of California in Santa Cruz (Room 180, Engineering Bldg 2). Follow directions and parking Information at the bottom of this page. There will be a two dollar fee for parking, but food is on us.
RSVP: by emailing to siero@ee.com (please put RSVP on subject).


Abstract

Databases are the backbone of a huge percentage of computer applications. At first glance, relational databases can be intimidating. This talk aims to walk you through what a relational database is and how relational databases can be used to store and analyze virtually any type of data. The talk will cover basic database concepts, table structure, indexes, foreign keys, referential integrity, stored procedures, triggers and more.

Biography


Tim Gustafson started out his IT career in 1994 by running a dial-up BBS. In 1996, he became a network engineer and server administrator for a dial-up ISP in New York. His interests quickly branched out into network engineering, Internet protocols and web applications development. During the dot-com boom during the late 1990's and early 2000's, Tim spent most of his time developing database-driven web sites for clients using the FAMP stack (FreeBSD, Apache, mySQL and PHP). After the dot-com bubble burst, his focus shifted from forward-facing web sites to inward-facing web applications for businesses. Since late 2007, he has been managing more than 250 web sites for the Jack Baskin School of Engineering, including the conversion of approximately 50 web sites from Bricolage and other content management systems to Drupal. During that time, he has developed dozens of Drupal modules to support the needs of a diverse and growing campus, almost all of which rely heavily on a mySQL relational database server.

Directions and Parking Information

For directions to UCSC from different parts of the bay area, click here .

The Baskin Engineering Buildings are located in the northwest corner of UCSC, on "Science Hill." Once at UCSC proceed up Coolidge Drive following the main road onto McLaughlin Drive. as McLaughlin Drive ends, turn left onto Heller Drive, then left again into the multi-level "West Core Parking" Structure (the closest parking to Baskin Engineering).

The best parking choice is to buy a Core West night parking permits at the Main Entrance Kiosk (Bay & High) for $2. The kiosk is open until 7:00AM to 8:00 p.m., Monday-Friday. These permits will be valid for any Core West Parking space (except specially marked spaces).

For any additional details related to parking in Core West click here. You can also just feed a meter in the parking lot as an alternative. A complete UCSC campus map(.pdf) is available, as well as a map/web site which shows the location of the Jack Baskin Engineering Bldg and Engineering Bldg 2.

Once in the Parking lot, to get to the Simularium go to the streeet level (2nd) floor of the Parking Space, cross the street go past the Baskin Engineering Bldg 1 to Bldg 2, the Simularium is off the courtyard lying between Baskin (E1) and Engineering 2 (E2) buildings.