Information Security in Systems and Networks

Primary Instructor (Contact)
Name: Sanjay Goel
Email: goel@albany.edu
Phone: (518) 442-4925
Office Location: BA 310b, University at Albany, SUNY

Guest Instructors
Damira Pon & Christopher Brown
Ph.D. Students
Information Science
College of Computing & Information

Class Information

Date: February 26-27, 2007
Time: 9:00am - 4:00pm
Location: University at Albany, Earth Science Building, Room ES-B19
Credit(s): Professional Development (12 hours)
Website: http://www.albany.edu/~goel/classes/spring2007/pwsp/database
Syllabus: http://www.albany.edu/~goel/classes/spring2007/pwsp/database/syllabus.pdf

Course Overview

This two-day workshop provides a broad introduction to modeling, design, and implementation of database applications using the relational model. It also provides students with a working knowledge of Structure Query Language (SQL) using Microsoft Access. The class will include several hands-on exercises in the laboratory for database design as well as SQL. The class will also discuss the architecture and implementation issues, such as, performance, management, concurrency, and recovery.

Learning Objectives

The objective of the class is to teach the students how to translate abstract problems into databases as well as to understand how databases work. The students will:

Agenda

TimeTopicInstructor
Day 1
9:00-9:30am Introductions and Overview Sanjay Goel
9:30-10:30am Relational Database Design
Database Design & ERD Presentation
Sanjay Goel
10:30-10:45am Break
10:45-12:30pm Entity Relationship Diagrams
ERD Assignment 1
ERD Assignment 2
ERD Assignment 3
ERD Supplementary Problems
Sanjay Goel
12:30-1:30pm Lunch  
1:30-3:00pm Database Administration
Power Point Presentation
Damira Pon
3:00-4:00pm Microsoft Access Tutorial Christopher Brown
Day 2
9:00-10:30am SQL (Data Definition Language)
SQL (DDL & DML) Presentation
Sanjay Goel
10:30-10:45am Break
10:45-12:30pm SQL (Data Manipulation Language) Sanjay Goel
12:30-1:30pm Lunch  
1:30-3:00pm SQL Query Tutorial
SQL Problems (University)
SQL Problems (University) Solutions
All
3:00-4:00pm SQL Queries in MS Access
DDL Project Database
DML Sales Database
Sales Database
All
[an error occurred while processing this directive]