Bentley College -- Computer Information Systems
CS361 DATA MANAGEMENT WITH SQL
| Course | Room | Day | Time |
| CS361OF1 | AGC 122 | Tues., Thurs. | 2:10 - 3:25 |
INSTRUCTOR: Dr. Mary Ann Robbert, CIS Department
OFFICE: Morison 126
PHONE: (617) 891- 2175
EMAIL: MROBBERT@BENTLEY.EDU
HOMEPAGE: HTTP://CIS.BENTLEY.EDU/MROBBERT
OFFICE HOURS:
| Tues: | 4:15 - 6:15 |
| Wed: | 4:00 - 6:30 |
| Thurs: | 1:00 - 2:00 |
Other times by appointment.
COURSE DESCRIPTION: A hands on, technology course utilizing Oracle, a commercially oriented, multi-user database management system, to teach data management. SQL will be used as a data manipulation and a data definition language. The use of a database for data storage, data protection and information retrieval will be presented. This first component will focus on the use and maintenance of data stored in a database management system. The second will focus on the creation of a database and the generation of required reports.
COURSE OBJECTIVES: Upon successful completion of the course, students will:
TEACHING METHODOLOGY: Lectures and demonstrations plus interactive instruction using Oracle to demonstrate concepts. Hands on exercises will be used to ensure students understand SQL and can solve business problems.
COMPUTER: Computers linked to the VAX through either the LAN or a modem, will be used to access course databases through Oracle. If possible bring a laptop computer to class for hands on experience.
REQUIRED TEXT:
A Guide to SQL featuring Oracle, Philip Pratt, published by Course Technology, 1997.
EVALUATION: The final course grade will be determined by the following:
| Item | % | Comments |
| Class Participation | 10 | Attendance and contribution |
| Homework | 45 | Lecture and lab reinforcement |
| Quizzes | 25 | Based on class work & lab assignments |
| Merge | 20 | Comprehensive |
Tentative Schedule of Topics
| WEEK | DATE | SUBJECT MATTER |
ASSIGNMENT DUE | |||
1 |
3/21 |
Relational database overview, Introduction to Oracle | Chapter 1, 2 (16-21)
|
|||
2 |
3/23 | Data storage and retrieval methods; SQL | Query zookeeper database | |||
3 |
3/28 |
Data Retrieval through SQL. Write queries to retrieve specified data from given databases. | Chapter 3, 4
|
|||
| 4 | 3/30 | Joining tables, complex queries | More zookeeper queries | |||
| 5 | 4/4 | Creating and modifying databases with SQL, designing views | Chapter 2, 5, 6 | |||
| 6 | 4/6 | Integrity, DDL | Create database | |||
| 7 | 4/11 | Advanced SQL commands | ||||
| 8 | 4/13 | NULLS | Query your database | |||
9 |
4/20 |
Report generation, using SQL to group data, summarize information, produce statistics | Chapter 7
|
|||
10 |
4/25 |
Front end tools, accessing database through GUI, Using Access | Generate reports, AppendixA | |||
11 |
4/27 |
Merging Data | Access assignment
|
|||
12 |
5/2 |
Merging Databases, Client/Server Systems, Embedded SQL | Merge Data, Chapter 8 | |||
| 13 | 5/4 | Presentations and Reflection | Merged Databases | |||