Home CIOS 330 CIOS 185 CIOS 340

340 Syllabus
340 Schedule

 

Client/Server Database Programming

Credit    : 3 credits

Level     : Upper division elective course

Offered : once a year

Prerequisite: CIOS 330

Client/server computing is the latest trend in the development of database systems and local area network (LAN) technology.  The move toward client/server architecture is primarily important for database applications because it improves the performance of accessing shared data in a LAN environment and allows more users to access the same data, often using their existing PC software.  It is believed that SQL database servers will play a crucial role in downsizing mainframe applications to client-server LAN-based systems.  It is also believed that professionals involved either in downsizing, upgrading, or the development of new client-server applications will need to have a vigorous and comprehensive understanding of the issues involved in the development of robust client-server database applications.

 This course is designed as an advanced database course to provide students a comprehensive understanding of SQL relational databases and the emerging client-server technologies.  In this course, we’ll concentrate primarily on SQL database application development with Oracle SQL server and introduce Oracle developer, Microsoft Access, and Web Browser as front-end interface development tools.  However, we’ll also have  a comprehensive discussion of SQL data definition, SQL data manipulation, transaction management, system administration, performance tuning, benchmarking, application programming interface, and distributed computing issues in client-server application development.