DATA 138 - Database Programming for Data Analytics

Upper Division

Prerequisites
CS 021

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.

Term Offered
Fall

Course credits: 1