Syllabus Sections
Publish Date
01/19/2021 10:38:43
Database Programming: Oracle
ITSE-2309
Credit Spring 2021
01/19/2021 - 05/16/2021
Course Information
Section 005
Distance Learning
MW 11:00 - 12:20
DLS DIL
Richard Smith
Section 005
Laboratory
MW 12:20 - 12:45
DLS DIL
Richard Smith
Office Hours
-
M W
10:00 AM - 11:00 AM
Collaborate on Blackboard
On Mondays I will be available for BCIS2390 on Collaborate.
On Wednesdays I will be available for ITSE2309 on Collaborate
If these hours meet your needs, please contact me via phone or Email to schedule a better time.
All Class hours will be held on Blackboard Collaborate as scheduled
Course Requirements
Course Description: Applications development using database programming techniques emphasizing database structures, modeling, and database access. This course instructs the student in the essential concepts and design methodology for the Relational Database Model as implemented by Oracle. Other topics include: the Data Definition Language, the Data Manipulation Language, database normalization, transaction processing, security, multi-user problems and solutions.
Readings
Database Systems: Design, Implementation and Management13e
By Coronel and Morris
ISBN-10: 1-337-62790-9
Oracle 12c SQL By Joan Casteel
ISBN-10: 1-305-25103-2
Course Subjects
Tentative Lecture Schedule:
Week |
Coronel/Morris |
Casteel – Oracle SQL |
Topic |
Lab Assignments |
1 |
Chapters 1 & 2 |
Chapters 1 & 2 |
File Systems and Databases |
|
2 |
Chapter 3 |
Chapters 3 & 4 |
The Relational Database Model |
|
3 |
Chapters 4 & 7 |
Chapters 4 & 8 |
Table Creation & Management |
Start Lab #1 |
4 |
Chapter 8 |
Chapter 9 |
Constraints, Rows & Joining Tables |
End Lab #1 |
5 |
Rev. Chapters 1, 2, 3, 4, 7 & 8 |
Rev. Chapters 1, 2, 3, 4, 8 & 9 |
Review & Exam. #1 |
|
6 |
Chapter 5 & 6 |
Chapter 10 |
Normalization of Database Tables & Single Row Functions |
Start Lab #2 |
7 |
Chapter 9 |
Chapter 11 |
Database Design & Group Functions |
End Lab #2 |
8 |
Chapter 10 |
Chapter 12 |
Transaction Management & Concurrency and Subqueries and merge statements |
Start Lab #3 |
|
Spring Break |
|
|
|
9 |
Chapter 12 |
|
Distributed Database Management Systems |
End Lab #3 |
10 |
Rev. Chapters 5, 6, 9, 10 & 12 |
Rev. Chapters 10, 11, 12, |
Review & Exam. #2 |
|
11 |
Handouts |
Chapter 13 |
Report Generation & Clusters And Views |
Start Project |
12 |
Chapter 14 |
Handouts Chapter 15 |
Client/Server Systems Database and the Internet |
|
13 |
Chapter 13 |
|
Business Intelligence & Data Warehouses |
|
14 |
Chapter 11 Chapter 14 |
|
Database Tuning & Query Optimization Big Data Analytics and NoSQL |
|
15 |
Chapter 15 |
|
Database Administration & Security |
End Project |
16 |
Rev. Chapters 11, 13, 14, 15 and Handouts |
Rev. Chapter 13 and Handouts |
Review & Exam. #3 |
|
Tentative Laboratory/Homework Assignments:
1. SQL Queries
2. SQL Queries & Modification Commands
3. Table Creation and Normalization
4. Database Project
Student Learning Outcomes/Learning Objectives
Establish a basic understanding of the analysis and design of a database.
Establish a basic understanding of the process of Database Development and
Administration using SQL.
Enhance Programming and Software Engineering skills and techniques using SQL.
Establish a basic understanding of background materials needed for technical
support using SQL.
Solve Database problems using Oracle 9i SQL by applying SQL commands to
Create, Insert, Update, and Retrieve a simple database.
Understand the services provided by a Database Management System.
Understand the use and application of the Relational Database Model.
Understand Transaction Processing and Multi-user Database support.
Understand the difference between a Production transaction database and a
Data Warehouse.
Understand the Client/Server structures used in Database Management Systems.
Design and Implement a basic database using the Oracle Database Management
System.