Course

Course Summary

Credit Type:

Course

ACE ID:

SOPH-0047

Organization's ID:

CS1011

Organization:

SOPHIA Learning, LLC

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