Course

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

Objective:

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:

70%
Supplemental Materials