Database Programming

Catalog description

This course provides an introduction to database programming. Using the SQL language, students will learn how to explore and interact with databases, create and manipulate data, and extract knowledge through analytics and visualization. They will also learn fundamental database design principles and methods, and will apply this knowledge to develop databases of their own. While the course will focus predominantly on the applied use of relational databases, we will also introduce neighboring topics like non-relational data, APIs, extract-transform-load (ETL) processes, and business intelligence (BI) systems. Students taking DAT 153 will not be eligible to take CSC 353 because of a significant overlap in their learning objectives. DAT 153 provides a deeper exploration of practical database programming methods than CSC 353 does, but this comes at the expense of lessons on the theoretical basis of relational database systems. While CSC 353 is aimed specifically students majoring in Computer Science, DAT 153 is accessible for students in the Data Science program, or those who have credit or CSC 121. Satisfies Data Science minor requirement. Satisfies Mathematical and Quantitative Thought requirement. Prerequisites & Notes Prerequisite: one of CSC 110, CSC 121, CSC 240, CSC 209, or DIG 120 Not open to students with credit for or enrolled in CSC 353