CSIS 3722 - Development of Databases
Fall 2026 Syllabus, Section A01, CRN 43584,
Credit hours: 3
Course Meeting Times
Log in to view more
Instructor
Feng Yu
Email: fyu@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 |
|---|---|---|---|
| Optional | A Guide to SQL (10ed) | Mark Shellman/Hassan Afyouni/Philip J. Pratt/Mary Z. Last | 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
Schedule of Topics and Assignments
| Week of | Proposed Topic | Due/To Prepare for Class |
|---|---|---|
| 8/24 | Introduction to Example Databases Database Design Foundation |
|
| 8/31 | SQL Developer Tutorial, Import Example Database Creating Tables Single Table Queries |
|
| 9/7 | Multiple Table Queries Updating Data |
|
| 9/14 | Database Administration SQL Functions and Procedures |
|
| 9/21 | Big Data and NoSQL | |
| 9/28 | Review | |
| 10/5 | Exam |
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.