CS 219 - Advanced Database Data Processing

3.0 Credits
Advanced programming features allowing students to make more complex selections in databases, manipulate, clean and process data in more advanced ways with a high level scripting language like R or Python and optimize code to improve performance on very large datasets. This course is part of the Data Analytics for Professionals program.
Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Review basic database commands such as join, select, join, filtering, and union operations.
Apply advanced SQL commands to curated data including aggregate functions, common table expressions, subqueries, and window functions.
Compose code using R or Python to extract, transform and load data, and use libraries to update, insert into, aggregate and synthesize information using common data structures such as lists, tuples and dataframes.
Examine standard techniques in exploring, cleaning, and transforming data for analysis including imputing missing data, binning of data, and one hot encoding.
Assess performance of queries and scripts, and enhance code for optimal runtime.
Describe and articulate differences between relational databases and NoSQL databases.

Course Typically Offered
Fall