Course

Credit Type:
Course
ACE ID:
SDCM-0218
Version:
2
Organization's ID:
Computer Science 204
Organization:
Study.com, LLC
Length:
20 weeks (45 hours)
Minimum Passing Score:
70
ACE Credit Recommendation Period:
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 they’ll need 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:

  • 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
  • Use SQL commands to populate and retrieve data from a database
  • Define data manipulation language (DML) and explain its use, write SQL statements to update, delete, and manipulate data in a database
  • Write SQL commands to retrieve data from multiple tables using joins: inner, left, right, outer, cross, and self joins; define and explain the use of aliases
  • Write SQL subqueries to query data from multiple tables
  • Describe views and indexes in databases
  • Create views and indexes using SQL
  • 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; write SQL commands to manipulate sets and group data 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
  • Other
  • Quizzes
  • Students will demonstrate ability to create and manipulate a database
Supplemental Materials
Equivalencies

Other offerings from Study.com, LLC

View All Courses
College Credit Opportunities