Course

Course Summary
Credit Type:
Course
ACE ID:
SDCM-0164
Organization's ID:
Computer Science 303
Organization:
Location:
Classroom-based
Length:
40 weeks (20 hours)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Upper-Division Baccalaureate 3 Computer Science, Computer Information Systems, or Information Technology
Description

Objective:

The course objective is to identify and explain database technologies, management systems, design processes, applications, security, and administration.

Learning Outcomes:

  • Compare and contrast the different kinds of database technology
  • Select, design, and install a database from requirements
  • Define the theory that lead to relational database technology
  • Demonstrate the use of SQL in the creation and manipulation of databases
  • Analyze issues that affect the administration and security of databases.
  • Describe the genesis of modern database technology and the motivation for DBMS
  • Describe the relationship between databases and applications
  • Construct a database from a database design
  • Create web applications based on databases

General Topics:

  • Fundamentals of database technology
  • Database management systems and functions
  • Database types and uses
  • Applications of databases
  • Database design processes
  • Database administration functions
  • Creating databases in SQL
  • Advanced SQL queries
  • Database security and administration
  • Alternative database technologies
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials

Methods of Assessment:

  • Examinations
  • Quizzes
  • Written Papers

Minimum Passing Score:

70%
Supplemental Materials