hfsl_course

FE512 Database Engineering
Financial Engineering (Lab)
M 12p.m. - 1p.m. & F 10a.m. - 12p.m.
Hanlon Financial Systems Lab
T 10a.m. - 12p.m.
  • Fall On Campus
  • Spring On Campus
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 data 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, OneTick) and basic introduction to HADOOP. The course will also cover accessing databases using API in different programming languages.

The course covers basic use of SQL query based on MySQL, including retrieve data, import data, introduction to database 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.

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

MySQL, Fifth Edition by Paul DuBois

MySQL Cookbook: Solutions for Database Developers and Administrators

Assignments – 60% Final Projects – 30%Performance - 10%

Week (Date)  Topic (W) 50min Date  Topic (F) 1.5hr
1 Jan 18
  • Introduction to the class
  • Set up MySQL
Jan 20
  • Introduction to RDBMS
  • Connection, Data Type, Table Creation
  • Practice
2 Jan 25
  • SELECT Query I

Jan 27

  • Database Backup & Restore
  • File I/O
  • SELECT II
  • Practice
3 Feb 1
  • INSERT/DELETE
  • Data & Table manipulation
  • Practice

Feb 3

  • Table relationship
  • JOIN
  • Practice
4 Feb 8
  • Subquery

Feb 10

  • Views, Temporary Table
  • Key
5 Feb 15
  • Index, FULLTEXT
  • Query Optimization
  • Practice

Feb 17

  • Function
  • Procedure
 

Feb 24

  • Procedure
7 Mar 1
  • Trigger, Event

Mar 3

  • Database Administrator
  • Database Design
  • SQL Connector
8 Mar 8
  • Introduction to NoSQL
  • Set up MongoDB
Mar 10
  • Introduction to MongoDB
  • Create database, collection, document (update, delete)
9 Mar22
  • Conditions
  • Sort
  • Aggregates

Mar 24

  • Index
  • Practice
10 Mar 29
  • Text Search
  • Covered Query

Mar 31

  • MongoDB Administration
  • Connector
11 Apr 5
  • MongoDB Practice
Apr 7
  • OneTick I
12 Apr 12
  • HADOOP I
   
13 Apr 19
  • HADOOP I
Apr 21
  • HADOOP II
  • Practice
14 Apr 26
  • Data Visualization I
Apr 28
  • Data Visualization II
15 May 3
  • Q&A
May 4
  • Final Presentation