FE512 Database Engineering
Course Catalog Description
Olorundamilola 'Dami' Kazeem
||email@example.com||Babbio Center Room 109|
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.
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.
MySQL, Fifth Edition by Paul DuBois
MySQL Cookbook: Solutions for Database Developers and Administrators
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.
|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|