About the Course
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), and normal forms (1NF, 2NF, & 3NF) for database normalization.
- 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).