ITS 221Q - Topics in System Development:Advanced Database Programming with VB

Institution:

Kapiolani Community College

Subject:

Description:

3 hours lecture per week Prerequisite(s): ITS 151 or consent of Business Education Department Chairperson, program coordinator or instructor. ITS 221Q Advanced Database Programming with VB develops the technical skills a programmer needs to design, develop, and implement multi-tier client-server database applications. Topics include advanced programming with the Visual Basic language, client-server applications, and databases. Upon successful completion of ITS 221Q, the student should be able to: Describe the Client-Server Model and different client-server architectures. Describe the importance of multi-tier applications in business environments. Define and execute the stages of designing multi-tier applications (conceptual, logical, physical). 1 Deploy a multi-tier application. Access data using technologies such as ADO, OLE DB and ODBC. Execute advanced database queries using SQL, stored procedures, triggers and views. Implement data validation, error-trapping and transactions. Generate reports. Implement, explain and discuss appropriate measures to address issues of performance and security. Analyze and debug programs to ensure correct results. Collaborate with peers in design, development and deployment of a multi-tier database application.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

kapiolani.hawaii.edu/page/home

Phone Number:

(808) 734-9000

Regional Accreditation:

Western Association of Schools and Colleges

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.