CITE241

Download as PDF

Data Management

Computer Information Tech.Professional/Technical Program

Description

This course covers conceptual data modeling and introduces MySQL. Students will learn how to create simple to complex SELECT queries, including subqueries and joins, and how to use SQL to update and delete data. Topics covered in this course include exposure to MySQL; creating and modifying databases, tables, views, foreign keys and primary keys (FKs and PKs), and indexes; populating tables; and developing queries that range from simple SELECT queries to complex multi-table join queries.

Credit Hours

3

Offering Cycle

Fall Only

Yearly Cycle

All Years

Instructional Method

50d1e892-b440-4ab0-b6fd-dd9d98aeae39

Contact Hours

3