Applied SQL for Data Science

4 units · Graduate professional courses (400-499)

Lecture, three hours; discussion, one hour. Requisite: course 405 or equivalent level of discipline. Limited to Master of Applied Statistics and Data Science students. Students gain fundamental understanding of databases, database design, SQL scripting, and data analytics using SQL combined with other tools. Students acquire ability to take raw data and transform that data into actionable analytics once a database has been designed, prepared, and tuned. Students gain proficiency in SQL scripting, database design, data management, and how to analyze data using SQL. Letter grading.