Course

Course Summary
Credit Type:
Course
ACE ID:
SOPH-0047
Organization's ID:
CS1011
Organization:
Location:
Online
Length:
Self-paced. Students have up to 60 days to complete
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 relational databases
Description

Objective:

The course objective is for students to learn the basics of databases, including data modeling, SQL statements (DML, DDL and DCL), database administration, and security. Students will explore relational databases such as MariaDB, SQL Server, Oracle or MySQL, including alternative approaches like NoSQL.

Learning Outcomes:

  • use select-from-where queries to collect information from a single table database
  • form a single table database using create and insert commands
  • form a database with multiple tables using primary keys and foreign keys
  • demonstrate awareness of sub-queries, views, indices, and unions
  • summarize importance of backing up data
  • evaluate multiple approaches to securing relational data
  • explore other methods of enhancing relational table design
  • explain the purpose and utility of a database
  • identify the most common database models used today
  • distinguish between several commercial relational DBMS
  • explain the purpose of an ERD
  • explain the purpose of normalization with respect to the relational data model
  • given an ERD depicting non-normalized data, normalize the data model
  • use group by, order by, and aggregate functions
  • alter and update the database table by adding, deleting, or modifying columns
  • use select-from-where queries to combine information from multiple tables in a database using joins

General Topics:

  • Single table query foundations
  • Single table construction
  • Aggregate function queries
  • Updating a single table
  • Querying multiple tables
  • Constructing related tables
  • Specialized queries
  • Views
  • Reliability
  • Security
  • Enhancement
  • Management
  • Utility
  • Common database models
  • Commercial variety
  • Constraints
  • Entity-relationship diagram
  • Normalization
  • Applied normalization
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Computer Based Training
  • Lectures
  • Practical Exercises

Methods of Assessment:

  • Examinations
  • Quizzes

Minimum Passing Score:

70%
Supplemental Materials

Other offerings from SOPHIA Learning, LLC

(SOPH-0006)
(SOPH-0029)