Information Security in Systems and Networks
Primary Instructor (Contact)
Name: Sanjay Goel
Email: [email protected]
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, 2007Time: 9:00am - 4:00pm
Location: University at Albany, Earth Science Building, Room ES-B19
Credit(s): Professional Development (12 hours)
Website: https://www.albany.edu/~goel/classes/spring2007/pwsp/database
Syllabus: https://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 | |
| 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 | |