FE513 Financial Lab: Database Design


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