CIST 2129 Syllabus

Subject Code

CIST

Course Number

2129

Course Title

Computer Database Techniques

Prerequisites

None

Corequisites

None

Terms Offered

Credit Hours

Course Description

This course provides a study of databases beginning with introductory topics and progressing through advanced development techniques. Topics include advanced database concepts, advanced development techniques, data integration concepts, and troubleshooting and supporting databases.

Course Outcomes

Advanced Database Concepts Order

• Demonstrate the ability to effectively design, create, and manage a database.
• Construct and relate tables to enforce referential integrity.
• Apply advanced techniques of form design to be used to enter and modify data.
• Develop queries including queries that filter, update, and display data in varying forms.
• Design reports which include headers and footers, grouping and sorting, subtotals and totals.

Advanced Development Techniques

• Create, use, and modify macros.
• Design and develop user interfaces.
• Demonstrate the ability to assign macros to command buttons.

Data Integration Concepts

• Demonstrate the skills to export database objects.
• Integrate database with spreadsheet.
• Demonstrate how to import and XML file.
• Integrate with the internet.

Troubleshooting and Supporting Databases

• Use the application's help system.
• Apply database management techniques such as compacting, repairing, splitting, and backup.
• Demonstrate methods of securing a database.
• Show how to analyze database performance.