> ## Content Index
> Fetch the complete content index at: https://fsc.stevens.edu/llms.txt
> Use this file to discover other available public pages before exploring further.

# FE513 Financial Lab: Database Design
- URL: https://fsc.stevens.edu/fe513-financial-lab-database-design/
- Published: 2019-10-15T18:07:20.000Z
- Updated: 2026-10-15T22:44:56.000Z
- Author: hfsladmin
- Tags: Courses, #Import 2025-11-08 22:14

Course Catalog Description

# Introduction

Welcome to FE513! The course aims to introduce the required techniques and fundamental knowledge in data science techniques. It helps students to be familiar with database and data analysis tools. Students will be able to manage data in database and solve financial problems using R program packages. This course is designed for graduate students in the Financial Engineering program at the School of Business 

  
| Campus     | Fall | Spring | Summer |
| ---------- | ---- | ------ | ------ |
| On Campus  | X    | X      |        |
| Web Campus | X    | X      | X      |

  
Instructors

| Professor       | Email                 | Office     |
| --------------- | --------------------- | ---------- |
| Marina Georgiou | mgeorgio1@stevens.edu | Babbio 209 |

  
More Information

# Course Outcomes

The students taking this course are expected to acquire knowledge of interacting with databases. In particular, after successful completion of this course, students will be able to:

- build their own warehouse of data.
- manipulate data inside a database.
- "communicate" (interact) with the database building queries optimally
- perform data analysis and exploratory analysis utilizing data from a database.
- use R programming language for SQL code.
- write prompts for AI-assisted SQL development.
- utilize NoSQL database MongoDB.

  
Course Resources

# Textbook

Avi Silberschatz, Database System Concepts , Fifth Edition, McGraw-Hill, 2006, ISBN0-07-295886-3\. 

Walter Shields, SQL QuickStart Guide: The Simplified Beginner’s Guide to Managing, Analyzing, and Manipulating Data With SQL, ClydeBank Media LLC, 2019, ISBN-101945051752\. 

Eoin Brazil, MongoDB: The Definitive Guide: Powerful and Scalable Data Storage, 3rd Edition, O’Reilly Media, 2019, ISBN-10: 1491954469\. 

# Additional References

There will be a list of recommended readings. Programming Language (https://stackoverflow.com/) Data Science Competition (https://www.kaggle.com/) MongoDB Documentation (https://docs.mongodb.com/manual/tutorial/getting-started/) 

  
Grading

# Grading Policy

- 5% Attendance
- 20% Quizzes
- 35% Assignmetns
- 40% Final Project

  
Lecture Outline

|         | Topic                                                                   | Quizzes |                                        |
| ------- | ----------------------------------------------------------------------- | ------- | -------------------------------------- |
| Week 1  | Course Overview, Introduction & Set up Environment                      |         |                                        |
| Week 2  | SQL Basics, Query Data with pgAdmin, Primary key, Foreign key           | Quiz 1  | (Assignment 1 posted)                  |
| Week 3  | Data Definition Language (DDL) & Data Manipulation Language (DML)       | Quiz 2  |                                        |
| Week 4  | Filtering and Combining Data                                            | Quiz 3  | Assignment 1 due (Assignment 2 posted) |
| Week 5  | Single Value Functions                                                  | Quiz 4  | Final Project posted                   |
| Week 6  | Window Functions                                                        | Quiz 5  | Assignment 2 due (Assignment 3 posted) |
| Week 7  | Subqueries, Common Table Expressions (CTEs), CTAS, Views, Temp Tables   | Quiz 6  | Quiz 6                                 |
| Week 8  | Writing a program in SQL, Triggers, Index & Explain                     | Quiz 7  | Assignment 3 due (Assignment 4 posted) |
| Week 9  | Error Handling, Role Management, Generating AI prompts for SQL queries. | Quiz 8  |                                        |
| Week 10 | Intro to APIs, Connecting SQL to R.                                     | Quiz 9  | Assignment 4 due (Assignment 5 posted) |
| Week 11 | R programming and SQL                                                   | Quiz 10 | Quiz 10                                |
| Week 12 | NoSQL Databases, Intro to Mongo DB I                                    |         | Assignment 5 due                       |
| Week 13 | NoSQL Databases, Intro to Mongo DB II                                   |         |                                        |
| Week 14 | Project Presentations                                                   |         |                                        |