DATA 315 - Database Programming

Upper Division

This course prepares students to effectively manage data through a relational database management system (RDBMS), a query language and relevant tools. Fundamental database theories are introduced but the emphasis is on practical and hands-on learning experience. Various topics are covered including data modeling, database development life cycle, entity-relationship (ER) modeling and database design, relational models, normalization, structured query language (SQL), SQL queries, functions as well as advanced topics such as indexes and query performance, advanced queries and Python programming with databases. MySQL, the industry leading open-source RDBMS and the graphical user interface (GUI) and development tool MySQL Workbench are practically introduced and used.

Repeatable
No

Additional Notes
Previous course number: DATA 138

Course credits: 3