Course

Course Summary

Credit Type:

Course

ACE ID:

SDCM-0240

Organization's ID:

Analytics 103

Organization:

Study.com, LLC

Location:

Online

Length:

Self-Paced. 35 hours (10 weeks)

Dates Offered:

Credit Recommendation & Competencies

Level	Credits (SH)	Subject
Lower-Division Baccalaureate	3	Introduction to Database Analytics

Description

Objective:

The course objective is to introduce students to relational databases and structured query language (SQL). It provides the knowledge and skill necessary to explain relational databases and common SQL commands. Students will also be able to build a basic database, and also learn to add, modify, and select data from the database.

Learning Outcomes:

Identify relational database management systems and install developer editions of database systems
Design a relational database, including schemas, entity, and perform normalization
Define SQL, explain different flavors of SQL (T-SQL, PL/SQL, Dynamic SQL, No SQL), create keys in SQL, and write basic SQL commands
Create a database table, describe a schema in SQL and define SQL data types (character, numeric, text, date)
Write SQL commands to insert, retrieve, modify, and delete data in a database; write commands to modify database table structure
Describe SQL joins; create joins to combine data across tables in a relational database; create views and triggers using SQL
Define what is a relational database and contrast it to other database types (flat file, hierarchical)