CSIS 3722 - Development of Databases
Fall 2026 Syllabus, Section 01, CRN 40797,
Credit hours: 3
Course Meeting Times
Log in to view more
Instructor
Todd Jones
Email: tajones01@ysu.edu
Course Description
3722. Development of Databases. This course covers concepts about data modelling, relational data model, Structured Query Language (SQL), relational database design and transaction processing. Storing, retrieving, updating and displaying data using Structured Query Language (SQL), functions and triggers. Secure operations performed by database administrators. Prereq.: C or better in CSIS 1590 or (CSIS 1595+CSIS 1595L) or (CSIS 2605+CSIS 2605L) or (CSIS 2610+CSIS 2610L). 3 s.h.
Course Readings
| Group | Title | Author | ISBN |
|---|---|---|---|
| Required | Guide to SQL | Shellman, Mark / Pratt, Philip J. / Last, Mary Z. | 9780357361689 |
The course readings are subject to change in the event of extenuating circumstances, research developments, current events, and/or to ensure better learning.
Assignments/Assessments
Log in to view more
Tentative Course Schedule
| Week of | Reading(s) | Proposed Topic | Due/To Prepare for Class |
|---|---|---|---|
| 8/24 | Introduction | ||
| 8/31 | Chapter 1 | Databases and SQL Introduction | |
| 9/7 | Chapter 2 | Database Design Fundamentals | What is Data? |
| 9/14 | Chapter 2 | Database Design Fundamentals | Storing Data |
| 9/21 | Chapter 3 | Creating Tables | Data Loaded into SQL Developer |
| 9/28 | Chapter 3 +4 | Viewing Table Data, Inserting New Data | |
| 10/5 | Chapter 4 | Single Table Queries | Chapter 4 Book Work |
| 10/12 | Chapter 4 | More on Single Table Queries | |
| 10/19 | Review | Review | Exam 1 Chapter 1 - 4 |
| 10/26 | Chapter 5 | Multitable Queries | Chapter 5 bookwork |
| 11/2 | Chapter 5 | Nesting Queries | Nesting Queries |
| 11/9 | Chapter 5 + 6 | Joins | Joins |
| 11/16 | Chapter 7 | Updating, Deleting, Altering Data | Advanced Joins |
| 11/23 | Chapter 8 | Transactions, Database Adminstration | Review |
| 11/30 | Chapter 8 | Functions, Procedures and Triggers, PLSQL | Exam 2 Chapter 5 - 8 |
| 12/7 | Finals | Finals | Finals |
The course schedule, policies, procedures, and assignments in this course are subject to change in the event of extenuating circumstances, by mutual agreement, and/or to ensure better learning.