<p>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.</p>

Statistics

College of Letters and Science

Container 1

Statistics and Data Science

STATS 428 - Applied SQL for Data Science

Applied SQL for Data Science

Understand how SQL works, what it is good at, what it is bad at, and how combining tools leads to more robust processes.

Demonstrate understanding of declared variables in SQL and how to build Views and Stored Procedures.

Build a relational database from raw data sources.

Compose queries to view, change, compare, and summarize data.

Explain the relational model and how to build an entity relationship diagram.

Write advanced queries involving cursors and dynamic SQL.

Distinguish and describe data types and how data is stored in a SQL environment.

Optimize a relational database for performance.

Organize and load raw data into a SQL environment and perform queries to prepare the data for analysis.

Write SQL queries independently to answer real-life analytical questions.

Effectively communicate analysis results using written reports and presentations.

Connect SQL to analytical platforms to gather data directly from the data warehouse.

General Catalog

Applied SQL for Data Science

STATS 428

4 units