Sanjay Goel, School of Business, UAlbany

PH: (518) 442-4925
FX: (518) 442-2568
Email: goel@albany.edu

Business Administration 310b
1400 Washington Ave.
Albany, NY 12222

Warning! The navigation menu needs JavaScript to work.

On IE, click on the yellow bar and select "Allow Blocked Content". And then, select Tools --> Internet Options, click the Advanced tab, and check "Allow active content to run in files on my computer" under Security.

For Mozilla Firefox, click on Tools --> Options --> Content --> and check the enable JavaScript box.

If using the NoScript add-on, click on the icon at the bottom of the browser and select "Allow albany.edu".

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:

Learn skills for creation of entity relationship diagrams
Learn how to normalize databases
Learn how to write queries to access databases
Become familiar with both data definition language and data manipulation language
Develop specific skills for MS Access databases, which is the reference database for the class
Become familiar with database architecture and implementation issues such as performance, management, concurrency, and recovery

Agenda

Time	Topic	Instructor
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	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	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