FE512 Database Engineering

From Hanlon Financial Systems Lab Web Encyclopedia
Jump to: navigation, search



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, WinSQL, PosgreSQL), NoSQL (IBM DB2, OneTick) and database managers Aqua. The course will cover accessing databases using API, SQLConnect and Access methods for DB2.
Campus Fall Spring Summer
On Campus X X
Web Campus

Instructors

Professor Email Office
Xiaodi Zhu
xzhu@stevens.edu Desk outside BC546



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

After taking this course, the students will be able to:

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

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

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

• 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: Assignments – 60% , Final Projects – 30% , Performance - 10%

• 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.
Week 11 Hanlon Lab Databases; HADOOP I.
Week 12 HADOOP II
Week 13 Data visualization
Week 14 Final Presentation