FE512 Database Engineering


Course Catalog Description

Introduction

The course provides an introduction to SQL databases and NoSQL databases as available to the Hanlon Financial Systems Lab. At the end of the course, the students will be familiar with all the lab resources as well as a working knowledge on how to use them. The students will receive hands on instructions about setting up and working with databases. Most of the software will be introduced using case studies or demonstrations, followed by a lecture of related fundamental knowledge. The course covers SQL (MySQL), NoSQL (MongoDB) and basic introduction to HADOOP. The course will also cover accessing databases using API in different programming languages.

Campus Fall Spring Summer
On Campus X
Web Campus

Instructors

Professor Email Office
Olorundamilola 'Dami' Kazeem
okazeem@stevens.edu Babbio Center Room 109

More Information

Course Description

The course covers basic and advanced knowledge of SQL based on MySQL, including retrieve data, import data, database design and management, etc.. MySQL Connector with other programming language is also covered. Beside of SQL knowledge, advanced technologies related to big data are also covered, including HADOOP, NoSQL.


Course Outcomes

At the end of this course, students will be able to:

1.Have a working understanding of all the databases available for them through the Hanlon lab.

2. Will get a primer on database management as well as advantages and disadvantages.

3. Will develop a self-study plan to obtain more information and proficiency for each software and database.

4. Will understand how to interface, access, and manipulate any database available for them from most computing software using standard connectors.


Course Resources

Textbook

MySQL, Fifth Edition by Paul DuBois

Additional References

MySQL Cookbook: Solutions for Database Developers and Administrators


Grading

Grading Policies

All Stevens, graduate students promise to be fully truthful and avoid dishonesty, fraud, misrepresentation, and deceit of any type in relation to their academic work. A student's submission of work for academic credit indicates that the work is the student's own. All outside assistance must be acknowledged. Any student who violates this code or who knowingly assists another student in violating this code shall be subject to discipline. If identical submissions are founded, the students will receive 0 point for the homework.

Your final grade will be determined by the number of points you collect:

  • 60% Assignments
  • 30% Final Projects
  • 10% Performance

This course will have 5 to 6 assignments and one final project with report and presentation. The final project request you to design a workable database, propose questions and use query to answer the question.


Lecture Outline

Topic Reading
Week 1 Introduction to database management systems. Set up MySQL.
Week 2 CREATE; SELECT from single table; Database Backup & Restore.
Week 3 INSERT/DELETE; Data & Table manipulation; File I/O; Table relationship. Assignment 1
Week 4 Relational Algebra.
Week 5 SELECT from multiple tables; Subquery; Views, Temporary Table; Key, Index, FULLTEXT; Query Optimization. Assignment 2
Week 6 Function & Procedure.
Week 7 Trigger, Event; Database Administrator; Database Design. Assignment 3
Week 8 SQL Connctor; Introduction to NoSQL; Set up MongoDB; Create database, collection, document (update, delete).
Week 9 MongoDB condition, sort, aggregates, index.
Week 10 MongoDB text search, covered query, administration, connector. Assignment 4
Week 11 Hanlon Lab Databases; HADOOP I.
Week 12 HADOOP II
Week 13 HADOOP III
Week 14 Data visualization I
Week 15 Data visualization II
Week 16 Final Review Period
Week 17 Final Presentation