Fall 2026 Applied Analytics PS5310 section D01

SQL

SQL & RELATIONAL DB ONLINE

Call Number 12535
Day, Time & Location View Class Schedule & Location in Vergil
Points 3
Grading Mode Standard
Approvals Required None
Instructor Nikolaos Machairas
Type LECTURE
Method of Instruction On-Line Only
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)

Department Applied Analytics
Enrollment 13 students (40 max) as of 6:06PM Thursday, November 19, 2026
Subject Applied Analytics
Number PS5310
Section D01
Division School of Professional Studies
Open To Professional Studies
Note ONLINE. APAN ONLY. PRE-REQS: NEEDS ADVISOR APPROVAL
Section key 20263APAN5310KD01