CS 810.E - SQL for Analytics

Course Description

Designed to introduce students to the fundamentals of SQL. You will learn to identify the role and structure of relational databases as they apply:

• to data analytics
• the Structured Query Language (SQL) in MySQL for data manipulation language (DML)
• the Structured Query Language (SQL) in MySQL for data definition language (DDL)
• normal forms (1NF, 2NF, & 3NF) for database normalization

Learner Outcomes

• Explain the role and structure of relational databases as they apply to data analytics.
• Extract meaningful insights from relational databases using Data Manipulation Language (DML).
• Design industry-standard relational database schemas using Data Definition Language (DDL).
• Revise database schema to meet criteria of normal forms (1NF, 2NF, & 3NF).