Summer 2026 Applied Analytics PS5310 section 003

SQL

SQL & RELATIONAL DB

Call Number 11298
Day, Time & Location View Class Schedule & Location in Vergil
Points 3
Grading Mode Standard
Approvals Required None
Instructor Day Yi
Type LECTURE
Method of Instruction In-Person
Course Description

The role of databases in data analytics cannot be overstated; databases facilitate efficient, secure and accurate information storage and retrieval across multiple users and platforms. As a result, proficiency in database design and knowledge of SQL programming are essential skills for the modern analyst and data scientist. This course is designed to help students develop these skills.

Data hardly ever comes ready to be analyzed. In fact, in many analytics projects, –the preparation of data (be it collecting, loading, organizing, filtering, etc.) can take more than 80% of the team’s time and resources, often forcing them to rush through the analyses in order to produce results. This course will demonstrate how relational database design coupled with efficient programming can alleviate the burden of handling messy data, allowing analysts and data scientists to focus on delivering accurate, reliable and reproducible results.

While the Structured Query Language (SQL) has not changed much in the past decade, database systems and the tools that interact with them have continued to evolve. Students will be introduced to the latest programs and database connectors that allow for tight integration with Python and R as well as interactive visualization in Power BI and Tableau.

Additionally, students will be exposed to NoSQL database systems optimized for big data analytics and the techniques necessary for interacting with massive amounts of data.

This course features a final project in which students will leverage their newfound skills to tackle real-life data management scenarios by designing appropriate database schemas and demonstrating how raw data can be transformed into actionable insights.

Weekly Class Meeting 110 min x 14 = 1,540 min; Recitations (Category A) 14 sessions x 50 min = 700 min; Project Group Meeting (Category E) 1 session x 40 min = 40 min; TOTAL = 2,280 min (for entire semester)

Subterm 05/26-08/14 (X)
Department Applied Analytics
Enrollment 26 students (45 max) as of 6:06PM Thursday, November 19, 2026
Subject Applied Analytics
Number PS5310
Section 003
Division School of Professional Studies
Note ON-CAMPUS. APAN STUDENTS ONLY. PRE-REQS: ADVISOR APPROVAL
Section key 20262APAN5310K003