This course covers conceptual data modeling and provides an introduction to MySQL. Students will learn how to create simple to complex SELECT queries including subqueries and joins, and will also learn how to use SQL to update and delete data. Topics covered in this course include exposure to MySQL; developing physical schemas; creating and modifying databases, tables, views, foreign keys/primary keys (FKs/PKs), and indexes; populating tables; and developing simple Select-From-Where (SFW) queries to complex 3+ table join queries. Students are recommended to complete Data Management – Foundations before starting this course.
- Conceptual Models to Physical Schemas: The graduate creates conceptual data models and translates them into physical schemas.
- Create Databases: The graduate creates databases utilizing SQL Data Definition Language (DDL) in MySQL environment.
- Create/Modify Tables & Views: The graduate writes code to create and modify tables and views employing SQL Data Definition Language (DDL) in MySQL environment.
- Create Primary Keys/Foreign Keys and Indexes: The graduate writes code to create and modify Primary Keys (PKs) and Foreign Keys (FKs) and Indexes with SQL Data Definition Language (DDL) in MySQL environment.
- Populate Tables: The graduate populates tables with insert, update, and delete using Data Manipulation Language (DML) in MySQL environment.
- Create Simple & Complex Queries: The graduate creates simple Select-From-Where (SFW) and complex 3+ table join queries with Data Manipulation Language (DML) in MySQL environment.
Coronel, C., & Morris, S. (2017). Database systems: Design, implementation, and management (12th ed.). Boston, MA: engage Learning. ISBN: 978-1-305-62748-2