Course Summary
Credit Type:
Organization's ID:
Computer Science 204
Self-paced. 20 weeks (45 hours)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Database Programming


The course objective is to teach students the requisite skills needed to create and manage relational database management systems. Students will learn how to populate, manipulate, and retrieve data; write queries for multiple tables; modify tables; and use regular expressions.

Learning Outcomes:

  • Use SQL commands to populate and retrieve data from a database
  • Write SQL commands to retrieve data from multiple tables using joins: inner, left, right, outer, cross, and self joins
  • Describe views and indexes in databases, Create views and indexes using SQL
  • Write SQL commands to manipulate sets and group data in databases
  • Define relational databases and explain core concepts of database design (normalization, normal forms, queries, and basic SQL commands)
  • Explain data definition language, define SQL data types and describe their use, describe constraints, and create primary and foreign keys in a database
  • Define data manipulation language (DML) and explain its use, write SQL statements to update, delete, and manipulate data in a database
  • Define and explain the use of aliases
  • Write SQL subqueries to query data from multiple tables
  • Explain how to modify tables in SQL
  • Write SQL commands to drop columns, rows, constraints, tables, temporary tables, and indexes using SQL
  • Define sets in databases
  • Perform multi-table inserts
  • Define regular expressions and explain their use in Oracle, MySQL, and SQL Server
  • Explain the importance of database security and describe methods for securing databases through management, use SQL tools for database security, and describe auditing and forensic methods for databases

General Topics:

  • Introduction to relational database management systems
  • Creating and managing database tables
  • Populating and retrieving data in databases
  • Manipulating data in databases
  • Data queries in multiple tables using joins
  • Data queries in multiple tables using subqueries
  • Views and indexes in databases
  • Modifying tables in databases
  • Manipulating large data sets in databases
  • Developing and using regular expressions in databases
  • Database security
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials

Methods of Assessment:

  • Examinations
  • Quizzes

Minimum Passing Score:

Supplemental Materials