| 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 |